Event Sub System running on SQL2005 JDBC Driver

Well I have followed the instructions in the KB Article (56631) to a T. I have even tried having the class path as c:\\interwoven\\iw-home\\eventsubsystem\\lib\\sqljdbc.jar, which I presume is an error in the KB and should be \\eventsubsystem\\lib\\sqljdbc.jar. But I have had no luck. The EventSubSystem will not start as it fails to find the class in the sqljdbc.jar giving the error -
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver', cause:
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

What do I have to do so that the Tea,Site EventSubsystem can find this jar and its classes.

BTW I'm running 6.7.1 on Windows 2003, with SQLServer 2005 and I downloaded the jar from Microsoft.

thanks in advance for any bones thrown my way :-)

/Nick

Find more posts tagged with

Comments

Migrateduser

There is an error in the KB article. We'll fix it ASAP. The eventsubsystem.properties file is no longer used. To specify the classpath you would need to edit a registry setting.

\HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\iweventsubd\Parameters

Edit the key "JVM Option 0" and add the location of sqljdbc.jar there.

Let me know if this helps.

Thanks,
Shashi

Migrateduser

Thanks Sashi that worked a treat.
I'm much relieved, but still a little worried about this being currently undocumented. I wasted a whole day tearing my hair out trying to get something to work that was never going to.

Migrateduser

Nick,

I apologize for the fact that this is not properly documented. I'll look into this asap and make sure that the document is updated.

Thanks,
Shashi