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
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.
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
>
> _________________________________________________________________________
> 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]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
