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="Blocking">true</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="Drivers">org.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="PoolName">MySQLDS</attribute> > > <attribute > > name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr > > ibute> > > > > <attribute name="URL">jdbc:mysql://localhost:3306/test</attribute> > > <attribute name="JDBCUser">root</attribute> > > <attribute name="MaxSize">5</attribute> > > <attribute name="Password" /> > > <attribute name="MinSize">0</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