Orly here is my jboss.jcml
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.gjt.mm.mysql.Driver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=MYSQL">
<attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">MYSQL</attribute>
<attribute name="URL">jdbc:mysql://localhost/jboss</attribute>
<attribute name="JDBCUser">mydbusername</attribute>
<attribute name="Password">mydbpassword</attribute>
</mbean>
hope this helps
Patrick
-----Original Message-----
From: Orly Tchemkin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 11:27 AM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] How to set MySQL DataSource for JBoss
Hello,
I am new to the Jboss users community and I would very appreciate any help
regarding the following problem:
I am trying to set the MySQL DataSource in jboss.jcml in order to work
with database
through JBoss. I dothe following steps:
1) put in <jboss_home>\lib\ext the MySQL driver file:
mm.mysql-2.0.4-bin.jar
2) add to CLASSPATH this file
3) Here is the contents (about jdbc) of jboss.jcml:
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.gjt.mm.mysql.Driver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=SvetikDS">
<attribute name="PoolName">SvetikDS</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
<attribute name="URL">jdbc:mysql://localhost:3306/database</attribute>
<attribute name="JDBCUser">root</attribute>
<attribute name="Password">password</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
--> When starting jboss the following error messages appeared:
...
[JDBC provider] Initializing
[JDBC provider] Loaded JDBC-driver:org.gjt.mm.mysql.Driver
[JDBC provider] Initialized
...
[JDBC provider] Starting
[JDBC provider] Started
[SvetikDS] Starting
[SvetikDS] XA Connection pool SvetikDS bound to java:/SvetikDS
[SvetikDS] Stopped
[SvetikDS] java.lang.NullPointerException
[SvetikDS] at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc
e.java:165)
[SvetikDS] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)
[SvetikDS] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[SvetikDS] at java.lang.reflect.Method.invoke(Native Method)
[SvetikDS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[SvetikDS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[SvetikDS] at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[SvetikDS] at java.lang.reflect.Method.invoke(Native Method)
[SvetikDS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[SvetikDS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[SvetikDS] at org.jboss.Main.<init>(Main.java:203)
[SvetikDS] at org.jboss.Main$1.run(Main.java:107)
[SvetikDS] at java.security.AccessController.doPrivileged(Native
Method)
[SvetikDS] at org.jboss.Main.main(Main.java:103)
[Service Control] Could not start
DefaultDomain:service=XADataSource,name=SvetikDS
[Service Control] java.lang.NullPointerException
[Service Control] at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc
e.java:165)
[Service Control] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)
[Service Control] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Service Control] at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Service Control] at org.jboss.Main.<init>(Main.java:203)
[Service Control] at org.jboss.Main$1.run(Main.java:107)
[Service Control] at
java.security.AccessController.doPrivileged(Native Method)
[Service Control] at org.jboss.Main.main(Main.java:103)
If somebody of you have any experience and can help, I would very
appreciate this.
Thanks in advance,
Orly
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
