Thanks for the reply below are my comments,
>From: Aaron Mulder <[EMAIL PROTECTED]>
>Reply-To: "jBoss" <[EMAIL PROTECTED]>
>To: jBoss <[EMAIL PROTECTED]>
>Subject: Re: [jBoss-User] Error loading DB2 driver
>Date: Tue, 26 Sep 2000 18:45:23 -0400 (EDT)
>
> There are two possibilities here. Either you don't have the DB2
>JDBC JAR in the right place (jboss/lib/ext), or you have the wrong class
Checked again and the db2java.jar file is in the jboss/lib/ext directory.
As JBoss starts up I can see that the jar file is being added to the
classpath. Note: db2java.jar was originally db2java.zip and I renamed it
for JBoss. I don't know if this is a problem, but another developer
suggested it to me.
>name. You might look in the DB2 JAR and make sure you've got the correct
>case (the COM looks suspicious) and class name (is it really
>DB2Driv?) in the entry in jboss.properties.
>
As odd as it may seem, the db2java.jar file contains the class
COM/ibm/db2/jdbc/app/DB2Driver.class.
>Aaron
>
>On Tue, 26 Sep 2000, Brett Palmer wrote:
> > I am trying to connect to a DB2 datasource. I have place the
>db2java.jar
> > file in the ../lib/ext directory. JBoss correctly adds it to the
>classpath,
> > but when it fails to load the driver. Here is my output when the JDBC
> > drivers are loaded (I am also loading the default instantDB and
>Hypersonic)
> >
> > [JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
> > [JDBC] Loaded JDBC-driver:jdbc.idbDriver
> > [JDBC] Could not load driver:COM.ibm.db2.jdbc.app.DB2Driv
> >
> > Of course after that I get SQLException of "No suitable driver found"
>when
> > it tries to create a database connection pool.
> >
> > My jboss.conf file has the following <MLET> entries:
> >
> > <MLET CODE = "org.jboss.jdbc.DataSourceImpl"
> > ARCHIVE="jboss.jar,jdbc2_0-stdext.jar" CODEBASE="../lib/ext/">
> > <ARG TYPE="java.lang.String"
> > VALUE="jdbc:idb:../conf/instantdb.properties">
> > <ARG TYPE="java.lang.String" VALUE="InstantDB">
> > <ARG TYPE="java.lang.String" VALUE="jdbc.idbDriver">
> > <ARG TYPE="java.lang.String" VALUE="">
> > <ARG TYPE="java.lang.String" VALUE="">
> > </MLET>
> >
> > <MLET CODE = "org.jboss.jdbc.DataSourceImpl"
> > ARCHIVE="jboss.jar,jdbc2_0-stdext.jar" CODEBASE="../lib/ext/">
> > <ARG TYPE="java.lang.String"
>VALUE="jdbc:HypersonicSQL:hsql://localhost">
> > <ARG TYPE="java.lang.String" VALUE="Hypersonic">
> > <ARG TYPE="java.lang.String" VALUE="org.hsql.jdbcDriver">
> > <ARG TYPE="java.lang.String" VALUE="sa">
> > <ARG TYPE="java.lang.String" VALUE="">
> > </MLET>
> >
> > <MLET CODE = "org.jboss.jdbc.DataSourceImpl"
>ARCHIVE="jboss.jar,hsql.jar"
> > CODEBASE="../lib/ext/">
> > <ARG TYPE="java.lang.String"
> > VALUE="jdbc:HypersonicSQL:d:\java.dev\iic\jps1.0.1\hsql\client">
> > <ARG TYPE="java.lang.String" VALUE="Petstore_Hypersonic">
> > <ARG TYPE="java.lang.String" VALUE="org.hsql.jdbcDriver">
> > <ARG TYPE="java.lang.String" VALUE="sa">
> > <ARG TYPE="java.lang.String" VALUE="">
> > </MLET>
> >
> > <MLET CODE = "org.jboss.jdbc.DataSourceImpl"
>ARCHIVE="jboss.jar,db2java.jar"
> > CODEBASE="../lib/ext/">
> > <ARG TYPE="java.lang.String" VALUE="jdbc:db2:pervasiv">
> > <ARG TYPE="java.lang.String" VALUE="DB2">
> > <ARG TYPE="java.lang.String" VALUE="COM.ibm.db2.jdbc.app.DB2Driver">
> > <ARG TYPE="java.lang.String" VALUE="db2admin">
> > <ARG TYPE="java.lang.String" VALUE="db2admin">
> > </MLET>
> >
> > Any suggestions with using DB2 and JBoss would be appreciated.
> >
> > Thanks in advance,
> >
> > Brett
> >
> >
Brett
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
