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!
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