From owner-freebsd-java Wed Dec 4 3:24:54 2002 Delivered-To: freebsd-java@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6DB2A37B401 for ; Wed, 4 Dec 2002 03:24:50 -0800 (PST) Received: from indra.perceval.net (indra.perceval.net [194.183.225.100]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5356F43EC2 for ; Wed, 4 Dec 2002 03:24:49 -0800 (PST) (envelope-from mb@perceval.be) Received: from perceval.be (oberon.perceval.be [194.183.229.171]) by indra.perceval.net (8.11.6/8.11.6) with ESMTP id gB4BOmO84196; Wed, 4 Dec 2002 12:24:48 +0100 (CET) (envelope-from mb@perceval.be) Message-ID: <3DEDE605.6ABB9398@perceval.be> Date: Wed, 04 Dec 2002 12:24:53 +0100 From: Emmanuel Bergmans Reply-To: mb@perceval.be Organization: Perceval X-Mailer: Mozilla 4.75 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: freebsd-java@freebsd.org Subject: Problem using mm mysql jdbc with jboss Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-java@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org 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.(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.(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 [...] jboss.jcml ---------- [...] org.gjt.mm.mysql.Driver org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl mySQLDS jdbc:mysql://localhost:3306/[db_name] [db_user_name] [db_pwd] [...] 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