[jBoss-User] I need some help setting up a jdbc->odbc connectionpool.

[Peter Henderson]

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.jdbc.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.