[VincentVega]

What operating system and version are you running? –> WIN XP ’02 SP1

What Eclipse version and build id are you using? (Help > About Eclipse Platform)

–>
Eclipse Platform
Version: 3.0.0
Build id: 200406251208

– Was Eclipse freshly installed for MyEclipse? –> yes

– If not, was it upgraded to its current version using the update manager? –> N/A

– Are any other external plugins installed? –> no

– How many plugins in the <eclipse>/plugins directory are like org.eclipse.pde.*
–>
8 plugins:

org.eclipse.pde.build_3.0.0
org.eclipse.pde.core_3.0.0
org.eclipse.pde.doc.user_3.0.0
org.eclipse.pde.junit.runtime_3.0.0
org.eclipse.pde.runtime_3.0.0
org.eclipse.pde.source_3.0.0
org.eclipse.pde.ui_3.0.0
org.eclipse.pde_3.0.0

What MyEclipse version are you using? (Help > About Eclipse Platform > Features)
–>
Version: 3.7.200
Build id: 200407091200-3.8-Beta2

What JDK version are you using to run Eclipse? (java -version) –> JDK version 1.4.2_05

What JDK version are you using to launch your application server? –> JDK version 1.3.1_06

What application server are you using? –> WebLogic Server 7.0 SP2

Are there any exceptions in the Eclipse log file? (<workspace>/.metadata/.log) –> none

What steps did you take that resulted in the issue?

–>

Scott:

I have an existing STRUTS project that I have successfully imported into MyEclipse. I managed to configure a
WebLogic Server 7.0 plugin.

Background:
This project uses a customized batch file to start the WL server (startWebLogic.cmd). All of the classpath and VM entries from the startWebLogic.cmd have been mapped to the WL server plugin configuration.

Issue:
The problem is that I get the following exception: Cannot load driver class: COM.ibm.db2.jdbc.app.DB2Driver
when I start the plugin server. I do not get this exception when starting the WL server using the batch file above.
I have read the following post: ‘DB Driver not found when starting from MyEclipseIDE’ Posted: Sep 23, 2003 – 01:43 AM
regarding the native library issues wrt a type II driver. Taking your suggestions I have included all of the DB2 dirs (under SQLLIB) that contain any dll files in the ‘Append to library path’ portion of the plugin configuration.

Note: db2java.zip and runtime.jar have been prepended and appended to the classpath respectively.

Not sure if I’m doing this correctly. Please advise. Thanks.

Vincent

[Riyad Kalla]

Vincent,
We had a but that is fixed in HEAD with the library path issues that might effect you, but more importantly, if there are any DLLs that your driver requires, they need to be in the System library path so the VM can find them, please see this FAQ entry to help: http://www.myeclipseide.com/FAQ+index-myfaq-yes-id_cat-14.html#105

[VincentVega]

Riyad:

I don’t believe the system library path is the issue since the modified batch file (startWeblogic.cmd) works properly. This

batch file makes use of both the system library path and system classpath variables.

Here are my values for the system library path and system classpath respectively:

C:\>path
PATH=C:\Program Files\Seagate Software\NOTES\;C:\Program Files\Seagate Software\
NOTES\DATA\;C:\Program Files\Windows Resource Kits\Tools\;C:\WINDOWS\system32;C:
\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\nls;C:\WINDOWS\system32\nl
s\ENGLISH;C:\Program Files\Reflection\;c:\perl\bin;C:\ORACLE\ora92\bin;C:\Progra
m Files\Oracle\jre\1.1.8\bin;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\F
UNCTION;%JAVA_HOME%\bin;S:\PB;Y:\;Y:\NLS;S:\DLL;S:\COMMANDR\BIN;S:\CSTA

C:\>echo %classpath%
.;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar
;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license
_cu.jar;C:\PROGRA~1\IBM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar

The DB2Driver class is located in db2java.zip above in the system classpath. The UDB DB2 client software installation assures

that these values are set. The needed dlls will be located in ..SQLIB\BIN and ..SQLIB\FUNCTION.

1. Is there any way to verify the new classpath the plugin generates before starting the server?
[For example, I have included an echo line that redirects the classpath value to file just before callind the WebLogic server. I can use this file for comparison purposes with the plugin generated classpath value]

2. What is the build # for the proposed fix for the library path issue mentioned above?

Thank you for your time and consideration.

[Scott Anderson]

Taking your suggestions I have included all of the DB2 dirs (under SQLLIB) that contain any dll files in the ‘Append to library path’ portion of the plugin configuration.

And that was exactly the right thing to do. Unforunately, there is a bug in the library path in 3.8 Beta 2 that keeps multiple entries from working correctly. It has been fixed for 3.8 GA. However, the easiest workaround is to create one directory that contains all the dll’s you need to add to the library path and simply copy all of them in there, thus leaving you with only one addtion to the path and working around the bug. The other workaround is to modify the preference file directly as documented in this thread:
http://www.myeclipseide.com/PNphpBB2+file-viewtopic-t-3051-highlight-performance+weblogic.html

Sorry for the inconvenience.

[Riyad Kalla]

Ahh, thank you Scott for getting this.

[VincentVega]

Scott and Riyad:

I perfectly understand, these things happen. 🙂

Unfortunately I still haven’t solved this problem. I’ve tried both workarounds.

Workaround 1: Didn’t work 🙁

I created a folder called db2dlls and placed all the dlls and dirs from two locations –

a. ..\IBM\SQLLIB\BIN
b. ..\IBM\SQLLIB\FUNCTION

I then refenced this dir (db2dlls) in the ‘Append to library path’ of the server plugin.

note: The above IBM directories were registered in the system path as indicated in the previous post.

Workaround 2: Didn’t work 🙁

I attempted to manually append the above IBM directories to the library path below.

OPT_LIBRARYPATH1=/Program Files/IBM/SQLLIB/BIN;/Program Files/IBM/SQLLIB/FUNCTION;
LIBRARY_PATH=”D\:\\bea\\jdk131_06\\bin;D\:\\bea\\weblogic700\\bin;D\:\\bea\\weblogic700\\server\\bin;/Program Files/IBM/SQLLIB/BIN;/Program Files/IBM/SQLLIB/FUNCTION”

Not sure if this is correct. Thank you for the insight. Any suggestions?

Vincent.

[Scott Anderson]

Vincent,

Workaround 2 is definately incorrect. It should be:

OPT_LIBRARYPATH1="C\:\\Program Files\\IBM\\SQLLIB\\BIN;C\:\\Program Files\\IBM\\SQLLIB\\FUNCTION;"
LIBRARY_PATH="D\:\\bea\\jdk131_06\\bin;D\:\\bea\\weblogic700\\bin;D\:\\bea\\weblogic700\\server\\bin;"

[VincentVega]

Scott:

Made that change for workaround 2 to no avail. 🙁 Still not working.

Thanks for the quick response.

[Scott Anderson]

Vincent,

Sorry about that. I think the problem is exacerbated because you’re using two drives (C & D). It looks like the first fix should work however. Did you try combining everything into a singel directory on drive C or D? Were all the dlls directly in the new directory, or contained in subdirs? If in subdirs, that won’t work as they must be directly on the library path.

Also, since the workaround has worked for others, you might try placing everything directly on the library path variable, since you’re editing by hand anyway at this point.

LIBRARY_PATH=”D\:\\bea\\jdk131_06\\bin;D\:\\bea\\weblogic700\\bin;D\:\\bea\\weblogic700\\server\\bin;C\:\\Program Files\\IBM\\SQLLIB\\BIN;C\:\\Program Files\\IBM\\SQLLIB\\FUNCTION;”

[VincentVega]

😀

Scott:

Thanks for the tip. Indeed I believe you were right on the money wrt the two dirs obfuscation. The problem was with referencing db2java.zip. This zip file contains the Type 2 DB2 driver and was being referenced on the C: drive where the DB2 client software resides.

I merely copied it to the temp dir or folder (D:\db2dlls) in workaround 1 above and subsequently referenced it there by prepending it to the classpath in the server plugin. Everything seems to be working smoothly. You should close this one immediately. Thank you very much for the help. I am one happy camper! 😆

Vincent

[Riyad Kalla]

Vincent,
We are very glad to hear that, thank you for hanging in there with us on this issue.

[Author]

Posts