Win 2003, SQL Server 2006, TS 6.7.1 new install. I have read KB 56631. So I want to confirm what I did (if anything was wrong)
I downloaded SQLJDBC from MS, ran the install and have in this folder d:\Interwoven\sqljdbc_1.1\sqljdbc_1.1\enu these files (install.txt, license.txt, release.txt, sqljdbc.jar) and these folders (auth, help, xa). I also put this entry into the registry for JVM Option Number 0
-Djava.class.path=D:\Interwoven\sqljdbc_1.1\sqljdbc_1.1\enu\sqljdbc.jar;D:\Interwoven\iw-home\eventsubsystem\lib\ant-1.5.3-1.jar;D:\Interwoven\iw-home\eventsubsystem\lib\ant-optional-1.5.3-1.jar;
\Interwoven\iw-home\eventsubsystem\lib\antlr-2.7.2.jar;D:\Interwoven\iw-home\eventsubsystem\lib\castor-0.9.5.jar;D:\Interwoven\iw-home\eventsubsystem\lib\classes12.zip;D:\Interwoven\iw-home\eventsubsystem\lib\commons-collections-2.1.jar;
\Interwoven\iw-home\eventsubsystem\lib\commons-dbcp-1.1.jar;D:\Interwoven\iw-home\eventsubsystem\lib\commons-logging-1.0.3.jar;D:\Interwoven\iw-home\eventsubsystem\lib\commons-pool-1.1.jar;
\Interwoven\iw-home\eventsubsystem\lib\concurrent-1.3.2.jar;D:\Interwoven\iw-home\eventsubsystem\lib\exolabcore-0.3.7.jar;D:\Interwoven\iw-home\eventsubsystem\lib\hsqldb-1.6.1.jar;D:\Interwoven\iw-home\eventsubsystem\lib\jdbc-2.0.jar;
\Interwoven\iw-home\eventsubsystem\lib\jdbm.jar;D:\Interwoven\iw-home\eventsubsystem\lib\jms-1.0.2a.jar;D:\Interwoven\iw-home\eventsubsystem\lib\jndi-1.2.1.jar;D:\Interwoven\iw-home\eventsubsystem\lib\jta-1.0.1.jar;
\Interwoven\iw-home\eventsubsystem\lib\junit-3.7.jar;D:\Interwoven\iw-home\eventsubsystem\lib\log4j-1.2.7.jar;D:\Interwoven\iw-home\eventsubsystem\lib\openjms-0.7.6.1.jar;
\Interwoven\iw-home\eventsubsystem\lib\openjms-client-0.7.6.1.jar;D:\Interwoven\iw-home\eventsubsystem\lib\openjms.war;D:\Interwoven\iw-home\eventsubsystem\lib\oro-2.0.7.jar;D:\Interwoven\iw-home\eventsubsystem\lib\servletapi-2.3.jar;
\Interwoven\iw-home\eventsubsystem\lib\xerces-2.3.0.jar;D:\Interwoven\iw-home\eventsubsystem\lib\xml-apis-1.0.b2.jar
(move to multiple lines for readability)
Is there a way to test out my SQLJDBC ? Anything look out of place ? Anyone have a beer ?
So I am at a loss. I still get this when I try to start the event subsystem:
OpenJMS 0.7.6.1
The OpenJMS Group. (C) 1999-2004. All rights reserved.
http://openjms.sourceforge.netorg.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver', cause:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:730)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.exolab.jms.persistence.DBCPConnectionManager.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(Unknown Source
