Re: [JBoss-user] Jboss2.4.4_Tomcat4.0.1 with MySQL3.23.47
On Thu, 21 Feb 2002, Christine wrote: Hi, I would like to readdress my question and make it much clearer. I searched both on the Forums and mailing list, as if I did everything right. But I still get error, when I tried to use MySQL. I do appreciate any suggestion! ... attribute name=URLjdbc:mysql://localhost:3306/test/attribute ... [INFO,MySQLDS] Starting [INFO,MySQLDS] XA Connection pool MySQLDS bound to java:/MySQLDS [ERROR,MySQLDS] Stopped java.lang.NullPointerException at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source) I've encountered a similar problem few days ago - I was told that The driver can't connect to the database. Usually its a url problem. In my case my MySQL server was set to communicate only through the local socket, not a tcp port. Try to run mysql -hlocalhost -uroot test. It should fail from the same reasons as your Jboss does. But it should report the problem in a little bit more comprehensible way :-) Pavel ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Jboss2.4.4_Tomcat4.0.1 with MySQL3.23.47
I tried all those suggestions, but I still can't start Mysql server. And I found another problem, if I add attribute name=Blockingtrue/attribute in the mbea for MySQL. The JBoss server won't start. It just stoped at [INFO, MySQLDS] XA Connection pool MySQLDS bound to java:/MySQLDS. Strange! Christine Rajeshwar Rao V wrote: 1)Remove the entry of DefaultDS from jboss.jcml.. 2) else if u r running ur mysql on default port..them remove port number 3306... 3) else change attribute name=Password / to attribute name=Password/attribute -Original Message- From: Christine [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:34 AM To: JBoss User (E-mail) Subject: [JBoss-user] Jboss2.4.4_Tomcat4.0.1 with MySQL3.23.47 Hi, I would like to readdress my question and make it much clearer. I searched both on the Forums and mailing list, as if I did everything right. But I still get error, when I tried to use MySQL. I do appreciate any suggestion! According to the JBoss manual - Configuring JDBC, I downloaded MySQL JDBC driver both version 2.0.6.1. (i didn't find version 2.0.6 suggested by the manual, i tried version 2.0.11 as well) and copy it to Jboss\lib\ext\. And I did changes on Jboss2.4.4_Tomcat4.0.1\conf\catalina\jboss.jcml: mbean code=org.jboss.jdbc.JdbcProvider name=DefaultDomain:service=JdbcProvider attribute name=Driversorg.hsqldb.jdbcDriver, org.gjt.mm.mysql.Driver /attribute /mbean Add one more mbean: mbean code=org.jboss.jdbc.XADataSourceLoader name=DefaultDomain:service=XADataSource,name=MySQLDS attribute name=PoolNameMySQLDS/attribute attribute name=DataSourceClassorg.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl/attr ibute attribute name=URLjdbc:mysql://localhost:3306/test/attribute attribute name=JDBCUserroot/attribute attribute name=MaxSize5/attribute attribute name=Password / attribute name=MinSize0/attribute /mbean The error I am getting is : (the DefaultDS is Hypersonic) [INFO,DefaultDS] Starting [INFO,DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS [INFO,DefaultDS] Started [INFO,MySQLDS] Starting [INFO,MySQLDS] XA Connection pool MySQLDS bound to java:/MySQLDS [ERROR,MySQLDS] Stopped java.lang.NullPointerException at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source) at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav a:412) 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:16 28) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15 23) at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf igurationService.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:16 28) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15 23) at org.jboss.Main.init(Main.java:208) at org.jboss.Main$1.run(Main.java:110) at java.security.AccessController.doPrivileged(Native Method) at org.jboss.Main.main(Main.java:106) -- Jia (Christine) Li 524N ICT Building Department of Computer Science University of Calgary ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user -- Jia (Christine) Li 524N ICT Building Department of Computer Science University of Calgary ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Jboss2.4.4_Tomcat4.0.1 with MySQL3.23.47
On 2002.02.21 16:35:03 -0500 Christine wrote: I tried all those suggestions, but I still can't start Mysql server. And I found another problem, if I add attribute name=Blockingtrue/attribute in the mbea for MySQL. The JBoss server won't start. It just stoped at [INFO, MySQLDS] XA Connection pool MySQLDS bound to java:/MySQLDS. Strange! if MySql server isn't running, you won't be able to connect to it. since XADataSourceLoader tries to establish a connection when it starts, to see if it is configured correctly, you hang. There may be a BlockingTimeoutMillis property in your version of jboss which should get you an exception instead of a hang. david jencks Christine Rajeshwar Rao V wrote: 1)Remove the entry of DefaultDS from jboss.jcml.. 2) else if u r running ur mysql on default port..them remove port number 3306... 3) else change attribute name=Password / to attribute name=Password/attribute -Original Message- From: Christine [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:34 AM To: JBoss User (E-mail) Subject: [JBoss-user] Jboss2.4.4_Tomcat4.0.1 with MySQL3.23.47 Hi, I would like to readdress my question and make it much clearer. I searched both on the Forums and mailing list, as if I did everything right. But I still get error, when I tried to use MySQL. I do appreciate any suggestion! According to the JBoss manual - Configuring JDBC, I downloaded MySQL JDBC driver both version 2.0.6.1. (i didn't find version 2.0.6 suggested by the manual, i tried version 2.0.11 as well) and copy it to Jboss\lib\ext\. And I did changes on Jboss2.4.4_Tomcat4.0.1\conf\catalina\jboss.jcml: mbean code=org.jboss.jdbc.JdbcProvider name=DefaultDomain:service=JdbcProvider attribute name=Driversorg.hsqldb.jdbcDriver, org.gjt.mm.mysql.Driver /attribute /mbean Add one more mbean: mbean code=org.jboss.jdbc.XADataSourceLoader name=DefaultDomain:service=XADataSource,name=MySQLDS attribute name=PoolNameMySQLDS/attribute attribute name=DataSourceClassorg.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl/attr ibute attribute name=URLjdbc:mysql://localhost:3306/test/attribute attribute name=JDBCUserroot/attribute attribute name=MaxSize5/attribute attribute name=Password / attribute name=MinSize0/attribute /mbean The error I am getting is : (the DefaultDS is Hypersonic) [INFO,DefaultDS] Starting [INFO,DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS [INFO,DefaultDS] Started [INFO,MySQLDS] Starting [INFO,MySQLDS] XA Connection pool MySQLDS bound to java:/MySQLDS [ERROR,MySQLDS] Stopped java.lang.NullPointerException at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source) at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav a:412) 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:16 28) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15 23) at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf igurationService.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:16 28) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15 23) at org.jboss.Main.init(Main.java:208) at org.jboss.Main$1.run(Main.java:110) at java.security.AccessController.doPrivileged(Native Method) at org.jboss.Main.main(Main.java:106) -- Jia (Christine) Li 524N ICT Building Department of Computer Science University of Calgary ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user -- Jia (Christine) Li 524N ICT Building Department of Computer Science University of Calgary ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Jboss2.4.4_Tomcat4.0.1 with MySQL3.23.47
Please take me out from your mailing list! I did not subscribe to any of these. [EMAIL PROTECTED] --- Christine [EMAIL PROTECTED] wrote: I tried all those suggestions, but I still can't start Mysql server. And I found another problem, if I add attribute name=Blockingtrue/attribute in the mbea for MySQL. The JBoss server won't start. It just stoped at [INFO, MySQLDS] XA Connection pool MySQLDS bound to java:/MySQLDS. Strange! Christine Rajeshwar Rao V wrote: 1)Remove the entry of DefaultDS from jboss.jcml.. 2) else if u r running ur mysql on default port..them remove port number 3306... 3) else change attribute name=Password / to attribute name=Password/attribute -Original Message- From: Christine [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:34 AM To: JBoss User (E-mail) Subject: [JBoss-user] Jboss2.4.4_Tomcat4.0.1 with MySQL3.23.47 Hi, I would like to readdress my question and make it much clearer. I searched both on the Forums and mailing list, as if I did everything right. But I still get error, when I tried to use MySQL. I do appreciate any suggestion! According to the JBoss manual - Configuring JDBC, I downloaded MySQL JDBC driver both version 2.0.6.1. (i didn't find version 2.0.6 suggested by the manual, i tried version 2.0.11 as well) and copy it to Jboss\lib\ext\. And I did changes on Jboss2.4.4_Tomcat4.0.1\conf\catalina\jboss.jcml: mbean code=org.jboss.jdbc.JdbcProvider name=DefaultDomain:service=JdbcProvider attribute name=Driversorg.hsqldb.jdbcDriver, org.gjt.mm.mysql.Driver /attribute /mbean Add one more mbean: mbean code=org.jboss.jdbc.XADataSourceLoader name=DefaultDomain:service=XADataSource,name=MySQLDS attribute name=PoolNameMySQLDS/attribute attribute name=DataSourceClassorg.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl/attr ibute attribute name=URLjdbc:mysql://localhost:3306/test/attribute attribute name=JDBCUserroot/attribute attribute name=MaxSize5/attribute attribute name=Password / attribute name=MinSize0/attribute /mbean The error I am getting is : (the DefaultDS is Hypersonic) [INFO,DefaultDS] Starting [INFO,DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS [INFO,DefaultDS] Started [INFO,MySQLDS] Starting [INFO,MySQLDS] XA Connection pool MySQLDS bound to java:/MySQLDS [ERROR,MySQLDS] Stopped java.lang.NullPointerException at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source) at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav a:412) 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:16 28) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15 23) at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf igurationService.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:16 28) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15 23) at org.jboss.Main.init(Main.java:208) at org.jboss.Main$1.run(Main.java:110) at java.security.AccessController.doPrivileged(Native Method) at org.jboss.Main.main(Main.java:106) -- Jia (Christine) Li 524N ICT Building Department of Computer Science University of Calgary ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user -- Jia (Christine) Li 524N ICT Building Department of Computer Science University of Calgary ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _ Get your FREE 6MB web-based e-mail @ 1800-Mail.com A FREE service by WIZIW.COM Powered by one of the fastest e-mail engines, EveryOneNet. UserID : YourName @ 1800-Mail.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user