Hello Tim/Ben, When using the mySQL pooling mechanism, how are the various pooling parameters defined. For example the initial number of connections or the maximum number of connections.
I didn't see any reference to another properties file that does this. Infact source of org.gjt.mm.mysql.jdbc2.optional.MysqlConnectionPoolDataSource + others didn't seem to implement pooling. It would be great to get some inputs in this area. Since poolman looks dead for the time being ,any alternate choices for pooling DB connections would be helpful With Regards Dutta:) -------------------------------------------- Satadip Dutta Software Design Engineer Manageability Solutions Lab Hewlett-Packard Fort Collins, CO Telephone : 970-898-3644 -------------------------------------------- -----Original Message----- From: Timothy Ruppert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 9:10 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] using MySQL pooled connections with Castor 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 ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
