Date: Wed, 04 Dec 2002 12:24:53 +0100 From: Emmanuel Bergmans <mb@perceval.be> To: freebsd-java@freebsd.org Subject: Problem using mm mysql jdbc with jboss Message-ID: <3DEDE605.6ABB9398@perceval.be>
next in thread | raw e-mail | index | archive | help
Hi all,
I got a problem to establish a mm mysql jdbc connection with jboss. All kind of help is welcome. See settings and description
below
System configuration
--------------------
FreeBSD 4.6.2
mysql-jdbc-mm-2.0.14
jdk-1.3.1p7_1
JBoss-2.4.9_Tomcat-4.0.4 (joss with embedded Tomcat)
Problem
-------
Configuration file
------------------
JBOSS seems to have a problem to establish the mysql link with datasource mySQLDS.
I got JBOSS errors (Closing DataSource Binding to JNDI name null) and I don't see any attempt in the mysql log. I don't have any
problem to connect to the mysql user with the login/pwd (with command line mysql client)
In server log
[...]
[11:30:53,613,ConfigurationService] Drivers set to org.gjt.mm.mysql.Driver in DefaultDomain:service=JdbcProvider
[11:30:53,621,ConfigurationService] DataSourceClass set to org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl in
DefaultDomain:service=XADataSource,name=mySQLDS
[11:30:53,627,ConfigurationService] PoolName set to mySQLDS inDefaultDomain:service=XADataSource,name=mySQLDS
[11:30:53,633,ConfigurationService] URL set to jdbc:mysql://localhost:3306/[db_name] in
DefaultDomain:service=XADataSource,name=mySQLDS
[11:30:53,639,ConfigurationService] JDBCUser set to [db_user_name] in DefaultDomain:service=XADataSource,name=mySQLDS
[11:30:53,646,ConfigurationService] Password set to [db_password] in DefaultDomain:service=XADataSource,name=mySQLDS
[...]
[11:30:54,201,JdbcProvider] Initializing
[11:30:54,206,JdbcProvider] Loaded JDBC-driver:org.gjt.mm.mysql.Driver
[11:30:54,207,JdbcProvider] Initialized
[11:30:54,207,mySQLDS] Initializing
[11:30:54,208,mySQLDS] Initialized
[...]
[11:30:54,527,mySQLDS] Starting
[11:30:54,535,mySQLDS] setGCInterval(0)
[11:30:54,536,mySQLDS] setGCMinIdleTime(0)
[11:30:54,536,mySQLDS] setIdleTimeout(0)
[11:30:54,536,mySQLDS] setTimestampUsed(false)
[11:30:54,544,XAConnectionFactory] Starting
[11:30:54,545,ObjectPool] Adding pool: mySQLDS, GC enabled: false
[11:30:54,549,mySQLDS] XA Connection pool mySQLDS bound to java:/mySQLDS
[11:30:54,552,XAPoolDataSource] Closing DataSource
[11:30:54,553,XAPoolDataSource] Binding to JNDI name null
[11:30:54,554,ObjectPool] Removing pool: mySQLDS
[11:30:54,560,mySQLDS] Stopped
java.lang.RuntimeException: No ManagedConnections Available!
at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:687)
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:242)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:445)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationSe
rvice.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.<init>(Main.java:209)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[11:30:54,579,ConfigurationService] Unexpected error
java.lang.RuntimeException: No ManagedConnections Available!
at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:687)
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:242)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:445)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationSe
rvice.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.<init>(Main.java:209)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[...]
jboss.conf
----------
at the end of the file
[...]
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="mySQLDS">
<ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
jboss.jcml
----------
[...]
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.gjt.mm.mysql.Driver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,
name=mySQLDS">
<attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute>
<attribute name="PoolName">mySQLDS</attribute>
<attribute name="URL">jdbc:mysql://localhost:3306/[db_name]</attribute>
<attribute name="JDBCUser">[db_user_name]</attribute>
<attribute name="Password">[db_pwd]</attribute>
</mbean>
[...]
Thanks in advance
Perceval Helpdesk Team
helpdesk@perceval.net
----------------------------------------------------------------------------
Perceval Technologies sa/nv
Rue Tenbosch, 9
B-1000 Brussels
BELGIUM
Tel: +32-2-6409194
Fax: +32-2-6403154
URL: http://www.perceval.be/
E-mail for general information: info@perceval.net
E-mail for technical information: helpdesk@perceval.net
----------------------------------------------------------------------------
This e-mail message contains legally PRIVILEGED and CONFIDENTIAL
information intended for the use of the addressee only. If you are not
the intended recipient of this message, please notify the undersigned
by telephone or e-mail reply and destroy this message and any attachments.
Any views or opinions presented in this e-mail are solely those of
the author and do not necessarily represent those of Perceval. The
integrity and security of this message cannot be guaranteed and it may
be subject to data corruption, interception, unauthorised amendment,
viruses and unforeseen delays, for which we accept no liability.
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-java" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3DEDE605.6ABB9398>