Hi Peter,
I did exactly what you're just trying to do (the only difference is that I
wanted to connect to a MS SQL DB using a type 4 JDBC driver, instead of the
ODBC bridge), but I failed doing so with the same document you're using.
Try this one instead (it's very precise and really explains each step) :
http://www.jboss.org/manual/index.html
and the section you're looking for is :
http://www.jboss.org/manual/adv_config.html#datasources
Following the instructions of this section made it work right the first
time, so I hope it will be the same for you.
Hope it helps,
Pascal Davoust.
-----Original Message-----
From: Peter Henderson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 20, 2000 6:58 PM
To: jBoss
Subject: [jBoss-User] I need some help setting up a jdbc->odbc connection
pool.
Hi all.
I have been following the instructions at
http://www.jboss.org/documentation/mssql.htm
Im using jboss final from the zip.
My jboss.properties
jdbc.drivers=org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,sun.jd
bc.odbc.JdbcOdbcDriver
My jboss.config
<MLET CODE = "org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,rt.jar"
CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="jdbc:odbc:ContactCenter">
<ARG TYPE="java.lang.String" VALUE="ContactCenter">
<ARG TYPE="java.lang.String" VALUE="sun.jdbc.odbc.JdbcOdbcDriver">
<ARG TYPE="java.lang.String" VALUE="sa">
<ARG TYPE="java.lang.String" VALUE="">
</MLET>
I get this exception when stating jboss (it goes away when i remove the mlet
code above)..
[Classpath extension] Initializing
[Classpath extension] Initialized
[JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
[JDBC] Loaded JDBC-driver:sun.jdbc.odbc.JdbcOdbcDriver
[Webserver] Initializing
...
javax.management.ReflectionException
at
com.sun.management.jmx.MBeanServerImpl.internal_instantiate(MBeanServerImpl.
java:2207)
at
com.sun.management.jmx.MBeanServerImpl.createMBean(MBeanServerImpl.java:761)
at javax.management.loading.MLet.getMBeansFromURL(MLet.java:540)
at javax.management.loading.MLet.getMBeansFromURL(MLet.java:369)
at org.jboss.Main.<init>(Main.java:119)
at org.jboss.Main$1.run(Main.java:87)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:83)
So is 'org.jboss.jdbc.XADataSourceLoader' the correct class for connection
pooling ?
I have also tried 'org.jboss.jdbc.JdbcProvider' which also fails.
The online help uses org.jboss.jdbc.DataSourceImpl which l couldnt find in
the jboss sources..
Can anyone help me?
Peter.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
