[JBoss-user] Anyone knows the answer to this ........

Suresh Avadhanula Tue, 27 Mar 2001 16:25:30 -0800

Title: Getting MySQL to work with JBoss

-----Original Message-----
From: Suresh Avadhanula
Sent: Sunday, March 25, 2001 12:08 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [JBoss-user] Getting MySQL to work with JBoss

Ok I was able to solve the problem.
There are some things I would like to make clear.

I removed the MLET entry from JBoss.conf



and the JBoss server started OK. Should we have this entry in JBoss.conf file. I have
the entry for MySQL in JBoss.jcml. JBoss documentation says that we need to creat the connection
pool by specifying it in JBoss.conf and give the necessary parameters in JBoss.jcml. Does
this still hold good.

Any help is appreciated.
Thanks.
Suresh

-----Original Message-----
From: Suresh Avadhanula [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 24, 2001 4:59 PM
To: '[EMAIL PROTECTED]'
Subject: [JBoss-user] Getting MySQL to work with JBoss

Hi,
I know most of you must have got it working. For some reason I am having trouble having MySQL as one of the datasource.
I have updated to Jboss.jcml to have the following

<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=mySQL">
<attribute name="PoolName">mySQL</attribute>
<attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:mysql://localhost/gandeev</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">suresh</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">suresh</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>


I see the following error..

[mySQL] Starting
[mySQL] Stopped
[mySQL] java.lang.IllegalStateException: Cannot start XA Connection Pool; there
is no TransactionManager in JNDI!
[mySQL]         at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLo
ader.java:320)
[mySQL]         at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.
java:93)
[mySQL]         at java.lang.reflect.Method.invoke(Native Method)
[mySQL]         at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1628)
[mySQL]         at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1523)
[mySQL]         at org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[mySQL]         at java.lang.reflect.Method.invoke(Native Method)
[mySQL]         at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1628)
[mySQL]         at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1523)
[mySQL]         at org.jboss.Main.<init>(Main.java:190)
[mySQL]         at org.jboss.Main$1.run(Main.java:94)
[mySQL]         at java.security.AccessController.doPrivileged(Native Method)
[mySQL]         at org.jboss.Main.main(Main.java:90)
[Service Control] Could not start DefaultDomain:service=XADataSource,name=null
[Service Control] java.lang.IllegalStateException: Cannot start XA Connection Po
ol; there is no TransactionManager in JNDI!
[Service Control]       at org.jboss.jdbc.XADataSourceLoader.startService(XAData
SourceLoader.java:320)
[Service Control]       at org.jboss.util.ServiceMBeanSupport.start(ServiceMBean
Support.java:93)
[Service Control]       at java.lang.reflect.Method.invoke(Native Method)
[Service Control]       at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1628)
[Service Control]       at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1523)
[Service Control]       at org.jboss.util.ServiceControl.start(ServiceControl.ja
va:97)
[Service Control]       at java.lang.reflect.Method.invoke(Native Method)
[Service Control]       at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1628)
[Service Control]       at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1523)
[Service Control]       at org.jboss.Main.<init>(Main.java:190)
[Service Control]       at org.jboss.Main$1.run(Main.java:94)
[Service Control]       at java.security.AccessController.doPrivileged(Native Me

Now I see that Transaction manager was not started before MySQL Connection pool is being created.
I set the dependency in jboss.dependencies

<service name="DataSource">
    <dependency service="Naming" required="true"/>
    <dependency service="TransactionManager" required="true"/>
    <dependency service="Logging" required="true"/>
    <dependency service="JdbcProvider" required="true"/>
    <dependency service="ClassPathExtension" required="true"/>
    <dependency service="Configuration" required="true"/>
    <dependency service="Hypersonic" required="false"/>
</service>

How can I configure JBoss's JMX so that Transaction managers start first before MySQL connection pool?

Thanks
-Suresh

[JBoss-user] Anyone knows the answer to this ........

Reply via email to