I am trying to configure jBoss 2.2.1+tomcat to use SQL Server 2000, using
Sun's JDBC-ODBC bridge, as documented in the jBoss.org documentation
http://www.jboss.org/documentation/HTML/ch11s22.html. But I just couldn't
get it to work. When I start jBoss, it gives the error:

[SQLServerPool] java.lang.IllegalStateException: Cannot start XA Connection
Pool; there is no TransactionManager in JNDI
!
[SQLServerPool]         at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:320)
[SQLServerPool]         at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[SQLServerPool]         at java.lang.reflect.Method.invoke(Native Method)
[SQLServerPool]         at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[SQLServerPool]         at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[SQLServerPool]         at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[SQLServerPool]         at java.lang.reflect.Method.invoke(Native Method)
[SQLServerPool]         at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[SQLServerPool]         at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[SQLServerPool]         at org.jboss.Main.<init>(Main.java:203)
[SQLServerPool]         at org.jboss.Main$1.run(Main.java:107)
[SQLServerPool]         at
java.security.AccessController.doPrivileged(Native Method)
[SQLServerPool]         at org.jboss.Main.main(Main.java:103)

Please help! Also, I think that there may be some typo in the document. For
example, the MLET entry in jboss.conf should be :

<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,rt.jar"
CODEBASE="../lib/ext/">
   <ARG TYPE="java.lang.String" VALUE="SQLServerPool">
   <ARG TYPE="java.lang.String"
VALUE="org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl">
</MLET>
(not org.jboss.minerva.xa.XADataSourceImpl)

And the MBean entry in jboss.jcml should be:

<mbean name="DefaultDomain:service=XADataSource,name=SQLServerPool">
   <attribute name="URL">jdbc:odbc:jboss_odbc</attribute>
   <attribute name="JDBCUser">Admin</attribute>
   <attribute name="Password">admin</attribute>
</mbean>

(without the ';' in the mbean name)

Very much appreciated!
ChetHong Lau

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to