-
1. Re: mysql on Jboss 3.2
hasanali00 May 3, 2003 9:53 AM (in response to sysuser1)read "JBoss3.2.0 & mySQl solution " under 'datasource configuration' forum
-
2. Re: mysql on Jboss 3.2
fbiaggi May 3, 2003 1:05 PM (in response to sysuser1)Ciao,
this is my config and works without problems:
mysql-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for MySQL using 2.0.11 driver -->
<!-- ==================================================================== -->
<local-tx-datasource>
<jndi-name>sisaejb</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/mydb?autoReconnect=true&useUnicode=true</connection-url>
<!-- <driver-class>com.mysql.jdbc.Driver</driver-class> -->
<driver-class>com.p6spy.engine.spy.P6SpyDriver</driver-class>
<user-name>root</user-name>
</local-tx-datasource> -
-
4. Re: mysql on Jboss 3.2
natonoll May 6, 2003 10:58 PM (in response to sysuser1)That has worked well for me but I've been going around in circles wondering if that is enough?
Don't I need a connection pool for my MySQL data source. The JCA docs say to use the datasource example which I have but when I look at the Connection Factories they are all using DefaultDS still.
When I look at the Hypersonic datasource it has pooling setting, like I'd expect.
Do I need a connection pool or is my weblogic experience blinding my judgement?
Thanks,