[cmcfarland]

As pointed out in other posts to this forum, utilizing the DB2 type 2 driver COM.ibm.db2.jdbc.app.DB2Driver under Tomcat requires us to reference both the driver JAR (db2java.jar) in the classpath (most appropriately by adding it to TOMCAT_HOME/common/lib) and the driver dll (db2jdbc.dll) by adding its directory (C:\Program Files\IBM\SQLLIB\BIN on 99+% of the windows installations) to the library path. With MyEclipse this second part is accomplished via Windows > Preferences > MyEclipse > App Servers > Tomcat 5 > Paths > Append to library path.

HOWEVER, my problem is that the *space* in “Program Files” then causes a JVM error starting Tomcat. The only way it works is if I copy the SQLLIB\BIN directory somewhere else or copy the specific dll file to the jre\bin folder, or something like that. Is there any way in Tomcat or MyEclipse to add this directory to the library path besides the Eclipse GUI? I need to be able to set something to work for other people “out of the box”, not just myself.

I realize this might be something with the JVM, but any help/ideas are appreciated.

BTW, I’m using:
MyEclipse 4.0 M2 for Eclipse 3.1
jdk 1.4.3_02
Tomcat 5.0.28

Thanks

[Riyad Kalla]

The good news is that this is a bug that will be fixed in M3, the “spaces in paths” issues with the connectors was fixed. So for now please use the workaround you have found, and when M3 comes out please change it back to use the dir with spaces and make sure we fixed it, we need to kill this bug.

[Author]

Posts