facebook

JDBC Problems with tomcat 5.5 within myeclipseide…

  1. MyEclipse Archived
  2.  > 
  3. Application Servers and Deployment
Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #232296 Reply

    P.G.Taboada
    Member

    Hi,

    I was playing around with TC 5.5 and DB2…

    The following simple piece of code…

    Class.forName(“the ugly db2 jdbc drive class name”);
    DriverManager.getConnection(“ugly url”, “bored user”, “simple passwd”);

    // do some jdbc here

    …Runs well as TestCase outside of tomcat
    …Runs well in a Servlet inside of tomcat outside of eclipse
    …Throws a “Cannot find a suitable driver” Exception when starting
    tomcat through myeclipseide inside of eclipse

    Oh yes, I added all my strange classpath entries to the startup
    parameter in the appserver config.

    Any ideas?

    brgds

    Papick

    #232315 Reply

    Riyad Kalla
    Member

    Oh yes, I added all my strange classpath entries to the startup
    parameter in the appserver config.

    And what were those exactly?

    When you run tomcat outside of Eclipse, how are you running it? Windows service? Batch file? etc.

    #232344 Reply

    P.G.Taboada
    Member

    Outside: batch file, setting CATALINA_HOME and JAVA_HOME manually
    Inside: added the two zip files from the dbs runtime client to the classpath and the bin directory too (those settings should now match the output of a “set classpath” in the command window)

    Brgds,

    Papick

    #232360 Reply

    P.G.Taboada
    Member

    hi,

    just wondering – how is tomcat startet from within myeclipseide?

    #232364 Reply

    Riyad Kalla
    Member

    Papick it sounds like you are doing what you should be to duplicate the setup of the batch file, there is likely a library or driver you have missed. Have you tried deploying your JDBC driver to your /common/lib directory in Tomcat to see if that helped?

    #233094 Reply

    P.G.Taboada
    Member

    Well, I matched both envronments, looked equal to me. The DB2 driver was a Type2 one, calling a native installed driver.
    I do not have access to those machines anymore (course is finished, students loved myeclipse 🙂 ), but maybe someone else is going to run into the same problem in the future…

    thanks for your support,

    brgds,

    Papick

    #233100 Reply

    Riyad Kalla
    Member

    Papick,
    Sorry to hear it didn’t get worked out. We did have a bug w.r.t. to the resolution of DLLs on the library path for our app servers, so I wonder if this was the cause (it will be fixed in M3)

Viewing 7 posts - 1 through 7 (of 7 total)
Reply To: JDBC Problems with tomcat 5.5 within myeclipseide…

You must be logged in to post in the forum log in