>1. Make sure you've got the JDBC driver jar file
>"mm.mysql-2.0.4-bin.jar" and put it into %JBOSS_HOME%\lib\ext. It will
>be loaded into classpath automatically when you start JBOSS.
>2. Create a new database record in mysql, let's call it "sample".
>3. Create a new "temp" table with sql statement such as "create table
>temp (...)".
>4. You need to modify the jboss.jcml file with the following sections :-
All done. Looks like it failed. Here's the jboss.jcml changes & exceprt
from server log:
jboss.jcml
<!-- JDBC -->
<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="PoolName">mySQL</attribute>
<attribute name="DataSourceClass">
org.opentools.minerva.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">xxxxxx</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
server.log
[JDBC provider] Initializing
[JDBC provider] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC provider] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
[JDBC provider] Initialized
[mySQL] Initializing
[mySQL] Initialized
<snip>
[JDBC provider] Starting
[JDBC provider] Started
[mySQL] Starting
[mySQL] Stopped
[mySQL] java.lang.ClassNotFoundException:
[mySQL] org/opentools/minerva/jdbc/xa/wrapper/XADataSourceImpl
[mySQL]
[mySQL] at java.lang.Class.forName0(Native Method)
[mySQL] at java.lang.Class.forName(Class.java:120)
[mySQL] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:270)
[mySQL] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[mySQL] at java.lang.reflect.Method.invoke(Native Method)
[mySQL] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[mySQL] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[mySQL] at org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[mySQL] at java.lang.reflect.Method.invoke(Native Method)
[mySQL] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[mySQL] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[mySQL] at org.jboss.Main.<init>(Main.java:217)
[mySQL] at org.jboss.Main$1.run(Main.java:121)
[mySQL] at java.security.AccessController.doPrivileged(Native Method)
[mySQL] at org.jboss.Main.main(Main.java:117)
[Service Control] Could not start
DefaultDomain:service=XADataSource,name=mySQL
[Service Control] java.lang.ClassNotFoundException:
[Service Control] org/opentools/minerva/jdbc/xa/wrapper/XADataSourceImpl
Any ideas?
Thanks,
r.b.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
