EventSubSystem & net.sourceforge.jtds.jdbc.Driver

Hi,

TS 65 on Win2k

Does anybody have the event subsystem working with the (open-source) net.sourceforge.jtds.jdbc.Driver?
Is it 'supported' to use another jdbc driver then the ones mentioned in de iwov-docs?
How can you add this jar-file to the classpath where the sussystem is searching for it's drivers?

We have copied the jar-file with the driver in the iw-home/eventsubsystem/lib directory.

For your detail, here is de error we are getting:

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 'net.sourceforge.jtds.jdbc.Driver', cause:
java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
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.<init>(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.<init>(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)

Hope to hear from one of you, Ronals

TS552, Win2k
OD560

Find more posts tagged with

Comments

stefanmaier

Hi all,

I have the same problem with a MS SQL Server 2000:

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:199)
at java.security.AccessController.doPrivileged(Native Method)
...

The necessary MS-JDBC-Driver are in the directory \iw-home\eventsubsystem\lib.

Additionaly I've tried to configure the file \iw-home\eventsubsystem\conf\eventsubsystem.properties, there is an entry
jdbc_classpath=... in it. Without success.

Did somebody know how to configure the event subsystem?

Regards
Stefan

TS65+Patch 1551 on W2K3

stefanmaier

Hi all,

to change the classpath on windows systems you can edit the registry.
You can include the missing jars through the registry entry:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\iweventsubd\parameters\JVM Option Number 0

I've changes this value, the database driver of my eventsubsystem seems to be loaded (well, now I can see that there is a new error message... :-)

For more information see KB 53407 (attention: the registry key in the KB article seems to be wrong)

Regards
Stefan

TS65+Patch1551

RonaldV

Thanks,

support had pointed me to the same kb-article. Here's the full story of how I set up the system at least for a sqlserver database (with lot's of debugging that was not in the iwov manuals):

- first you need to download a jdbc driver for sqlserver. Here's some I found:

> Microsoft: http://www.microsoft.com/sql/downloads/ (bound to be (re)moved following the normal MS-policy)
> Datadeploy: una200.jar under datadeploy\lib
> Opensource: http://jtds.sourceforge.net/

(all of them worked for me, that is gave no errors from the event system)

- copy the driver to home/lib and add it to the classpath in de regex as described above.

- if you use the microsoft driver make sure to add "SelectMethod=Cursor" to the url so it says this:
jdbc:microsoft:sqlserver://myServer:1433;SelectMethod=Cursor
(if not you'll get errors about a cursor)

- last you'll need a synonym in the database for the users table. In sqlserver this is called sysusers but the event system is querying for 'users':

create view users
as select * from sysusers

should do the trick. If you don;t do this you will see an error about 'unknown object users'.

In this config the event log did not give any error in it's logfile but also did not write any data to the database. Don't know why yet.

Last tip, the event subsystem is just a copy of the opensource openjms code. See http://openjms.sourceforge.net for more info.

Hope this will help any of you.

Ronald

TS552, Win2k
OD560

Edited by RonaldV on 01/27/05 00:23 AM (server time).