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]
