Hi, Dennis
I had the same problem to start MySQL(3.23.47) with Jboss 2.4.4-Tomcat4.0.1. I did
config the jboss.jcml under
Jboss-2.4.4_Tomcat-4.0.1/jboss/conf/catalina. The changes are as follow:
1. <mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.hsqldb.jdbcDriver, org.gjt.mm.mysql.Driver
</attribute>
</mbean>
2. 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</attribute>
<attribute name="URL">jdbc:mysql://localhost:3306/test</attribute>
<attribute name="JDBCUser"></attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password" />
<attribute name="MinSize">0</attribute>
</mbean>
Any suggestion will be really appreciated.
Regards,
Christine
Dennis Keller wrote:
> Pavel -
>
> I had similar problems when I was starting out with JBoss. Turns out
> that I was configuration the wrong jboss.jcml file. If you're running
> jboss with catalina built-in, then you need to be editing the jboss.jcml
> file under JBoss-2.4.4_Tomcat-4.0.1/jboss/conf/catalina. Be sure you're
> not editing the jboss.jcml file under
> JBoss-2.4.4_Tomcat-4.0.1/jboss/conf/default (as I was).
>
> Dennis
>
> On Thu, 2002-02-14 at 07:58, Pavel Kolesnikov wrote:
> > Hallo,
> >
> > I've tried to configure Jboss 2.4.4 to use MySQL database.
> >
> > Unfortunatelly I found only JBoss 3.0 configuration on Jboss site, so
> > I tried some directions found on the web with Google.
> >
> > So I've changed JdbcProvider mbean in jboss.jcml to:
> >
> > <mbean code="org.jboss.jdbc.JdbcProvider"
> > name="DefaultDomain:service=JdbcProvider">
> > <attribute
>name="Drivers">org.hsqldb.jdbcDriver,org.gjt.mm.mysql.Driver</attribute>
> > </mbean>
> >
> > ... and added following 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</attribute>
> > <attribute name="Properties"></attribute>
> > <attribute name="URL">jdbc:mysql:/localhost/test</attribute>
> > <attribute name="GCMinIdleTime">1200000</attribute>
> > <attribute name="JDBCUser">root</attribute>
> > <attribute name="MaxSize">10</attribute>
> > <attribute name="Password">***</attribute>
> > </mbean>
> >
> > standardjaws.xml starts with following few lines:
> > <?xml version="1.0" encoding="UTF-8"?>
> > <jaws>
> > <datasource>java:/mySQLDS</datasource>
> > <type-mapping>mySQL</type-mapping>
> > <debug>false</debug>
> >
> > When I'm starting JBoss, I'm getting following message in its logfile:
> > [16:44:19,979,mySQLDS] Starting
> > [16:44:20,253,mySQLDS] XA Connection pool mySQLDS bound to java:/mySQLDS
> > [16:44:20,719,mySQLDS] Stopped
> > java.lang.NullPointerException
> > at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
> > at
>org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java: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:1628)
> > at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> > at
>org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)
> > at $Proxy0.start(Unknown Source)
> > ...
> >
> > Could anyone of more experienced JBoss users tell me what could be wrong?
> > Sorry if this problem seems to be too stupid, I'm real JBoss newbie.
> >
> > Thanks a lot
> >
> > Pavel
> >
> >
> >
> > _______________________________________________
> > 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
--
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
