Event Subsystem Error

I am on TS6.7.1 in Win 2003, when i am trying to start event subsystem it is throwing this exception and it never getting started, do any one recall having this?

[html]
OpenJMS 0.7.6.1
The OpenJMS Group. (C) 1999-2004. All rights reserved.
http://openjms.sourceforge.net
org.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)
at org.exolab.jms.persistence.DatabaseService.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.instance(Unknown Source)
at org.exolab.jms.server.JmsServer.registerServices(Unknown Source)
at org.exolab.jms.server.JmsServer.init(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)

[/html]

Thanks

Find more posts tagged with

Comments

nipper

It appears you the subsystem cannot find the SQL server drivers.

How did you configure the event subsystem ? Via the install or after the fact?

You should have provided a path to the jar files (mssql.jar, msbase.jar, mssqlserver.jar - I think)

Bhargav Coca

I did it manually after installation. Where would one specify the path to the *.jar files? i know that they recide in $IWHOME\eventsubsystem\lib. I don't see a path to these jar files in jmsconfignew.xml or log4j.xml....

Please advice.

Thanks

nipper

Not certain about after the fact, the installer asked that Q. I cannot find any files that contain my path (which was not in IW_HOME but in the SQLSERVER client install area).

nbwoven

-You are right ;the classpath that eventsubsystem searches is :
CLASSPATH=$IWHOME/eventsubsystem/lib

Can you check if the jdbc driver is in the CLASSPATH for the eventsubsystem, also try copying the jdbc jar file to $IWHOME/eventsubsystem/lib again.

On windows, an additional step has to be performed to complete this process. Edit the following registry key \\HKEY_LOCAL_MACHINE\SYSTEM\Services\iweventsubd\parameters\JVM Option Number 0 to include the path to the jdbc driver file.

Migrateduser

The sql sever JDBC driver jars are not found by the event Subsystem.

Here are the steps from KB article 54178.

To configure MSSQL server as the database for event subsystem, you need to perform the following steps:

Create a database schema using create_sqlserver.sql file located under c:\iw-home\eventsubsystem\conf\ddl directory
Copy the jar files, mssqlserver.jar, msutil.jar, and msbase.jar, from the MSSQL server lib directory to the c:\iw-home\eventsubsystem\lib directory
Edit the registry key to include the path of the JDBC driver file: \\HKEY_LOCAL_MACHINE\SYSTEM\Current ControlSet\Services\iweventsubd\Parameters\JVM Option Number 0
Delete the events.lock file if it is located under the iw-home\eventsubsystem directory
Make the following changes in the jmsconfignew.xml file located under iw-home\eventsubsystem\conf directory:

garbageCollectionThreadPriority="5">

url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=events;selectMet

hod=cursor"

user="test"

password="test"

maxActive="10"

maxIdle="5"

minIdleTime="1800"

evictionInterval="3600" />
Restart the event subsystem service.

If you are receiving an error after performing the above steps, you need to add the dba user in the Administrators group. Note: Make sure to add a trailing semi-colon ( ; ) in the value of the registry key changes. Stop search and index services before trying to start the event subsystem.

Bhargav Coca

Thank you so much, I have done this before, i keep forgetting. Well adding the path in the registry solved the problem.

Thanks