Drew,
My partner and I were trying to use the latest version of poolman (at the
time it was PoolMan 2.0.4) and ran into serious errors (transaction hanging). As
soon as we switched to using new connection pooling drivers in
org.gjt.mm.mysql.jdbc2.optional.MysqlDataSource everything ran perfectly. We are
using mysql version 3.23.48 on FreeBSD version 5.0 (i386) if that matters to
you. Here is our old database.xml and the new one below. Notice that the params
port-number stuff didn't override the default port number default in
MysqlDataSource.
old way that didn't work:
<database name="testDB" engine="mysql" >
<data-source
class-name="org.gjt.mm.mysql.jdbc2.optional.MysqlDataSource"/>
<params user="test" password="test" server-name="localhost"
port-number="3306"/>
</data-source>
<mapping href="mapping.xml"/>
</database>
what we changed it to in order to make it work:
<database name="testDB" engine="mysql" >
<driver class-name="org.gjt.mm.mysql.jdbc2.optional.MysqlDataSource"
url="jdbc:mysql://localhost:3306/testDB?user=test&password=test"/>
<mapping href="mapping.xml"/>
</database>
Cheers,
Tim Ruppert && Ben Cox
Drew Farris wrote:
> I've heard rumors that PoolMan can be used for this:
> http://sourceforge.net/projects/poolman/
>
> But the project itself seems dead see: http://www.codestudio.com/
>
> Does anyone else have any suggestions?
>
> Drew
>
> On Wednesday 06 March 2002 04:26 am, Francisco Hernandez wrote:
> > How do I go about using pooled JDBC MySQL connections with Castor?
> >
> > I'm using MySQL but the JDBC driver im using (org.gjt.mm.mysql.Driver) does
> > not implement the Datasource interface so I'm using it without pooled
> > connections at the moment.
> >
> > -----------------------------------------------------------
> > If you wish to unsubscribe from this mailing, send mail to
> > [EMAIL PROTECTED] with a subject of:
> > unsubscribe castor-dev
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
