Currently, I'm running JBoss 2.0 with the Oracle thin driver and the
mm.mysql-2.0.4 driver.
The main problem I had setting up mySQL as a datasource was setting up users
and priveleges in mySQL. Read the mySQL documentation carefully.
Here are my configuration entries.
jboss.properities
jdbc.drivers=org.gjt.mm.mysql.Driver,oracle.jdbc.driver.OracleDriver
jboss.conf
<MLET CODE = "org.jboss.jdbc.JdbcProvider"
ARCHIVE="jboss.jar,classes12.jar,mysql.jar" CODEBASE="../../lib/ext/">
</MLET>
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,mysql.jar"
CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="mySQLPool">
<ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
jboss.jcml
<mbean name="DefaultDomain:service=XADataSource,name=mySQLPool">
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:mysql://localhost/store</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">store</attribute>
<attribute name="MaxSize">32</attribute>
<attribute name="Password">manager</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">32</attribute>
</mbean>
-----Original Message-----
From: Steven Webster [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 31, 2001 1:34 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] MySql and JBoss
Hi all,
I'm having a real hard time trying to get JBoss working with MySQL;
reading through the list archives, all I can really ascertain is that
the docs are not necessarily correct with regards to setting up JBoss.
Has anyone successfully setup JBoss with MySql, that could perhaps
send me the various entries they've made in the properties, conf and
jcml files, to get things working ? I've got the driver installed ok,
and checked it works with some simple JDBC client code (non EJB code).
As an aside; in looking for the answer, I've noticed a few people
allude to the jboss.conf file being deprecated, in preference for
the jboss.jcml file - is this the case ?
Also; when I make changes for logging to the .jcml file, including
adding the GUI Logger (I guess I'm answering my own question from
earlier today), the changes don't seem to take immediate effect...how
often are these files read, and are they parsed into a cached format
in any way, shape or form ??
Help :)
Steven
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
