Hi,
This is the one I use to make mySQL work. Hope it's useful to you too.
Don't forget to put mm.mysql-2.0.4-bin.jar in %JBOSS_HOME%\lib\ext.
<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/mysql</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">username</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">password</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>
Good luck!
Jonathan Gibbons wrote:
>
> Hi,
>
> Yes! Take a look at the jboss on-line documentation for how to do it. Also
> download the LowRoad (http://www.faraway.co.uk/tallsoft/lowroad/) and read
> the jboss_mysql_guide.txt.
>
> Jonathan
>
> >Anyone successfully load and use mm.mysql.jdbc or other MySQL driver from
> >an entry in jboss.jcml.
> >
> >
> >Thanks,
> >r.b.
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> _______________________________________________
> 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
