I had a similar problem with Poolman. Turns out the version of mysql we were using didn't support Transaction Isolation Levels (see your error message). I switched to 3.23.46 and all was well. Also, mm.mysql-2.0.9 is now available from sourceforge. This may help clear up some or most other bugs. Read the release notes for more info.
[EMAIL PROTECTED] wrote: > > Hi, > > I have had the experience that Struts DataSource "times out" frequently. I > tried to switch to Poolman, but I get the following error in trying out its > poolman-webapp: > > java.sql.SQLException: SQLException occurred in JDBCPool: java.sql.SQLException: > Transaction Isolation Levels are not supported. > params: org.gjt.mm.mysql.Driver, jdbc:mysql://localhost:3306/nda_catalog. Please > check your username, password and other connectivity info. > at com.codestudio.util.JDBCPool.create(Unknown Source) > at com.codestudio.util.ObjectPool.checkOut(Unknown Source) > at com.codestudio.util.JDBCPool.requestConnection(Unknown Source) > at com.codestudio.util.SQLManager.requestConnection(Unknown Source) > at com.codestudio.sql.PoolManDataSource.getConnection(Unknown Source) > > poolman.xml looks like this: > ----------------------------- > <datasource> > > <!-- ============================== --> > <!-- Physical Connection Attributes --> > <!-- ============================== --> > > <!-- Standard JDBC Driver info --> > > <dbname>nda_catalog</dbname> > <jndiName>jndi-datasource</jndiName> > <driver>org.gjt.mm.mysql.Driver</driver> > <url>jdbc:mysql://localhost:3306/nda_catalog</url> > > <username>root</username> > <password></password> > > <minimumSize>0</minimumSize> > <maximumSize>10</maximumSize> > <connectionTimeout>600</connectionTimeout> > <userTimeout>12</userTimeout> > <shrinkBy>10</shrinkBy> > > <logFile>/var/applogs/poolman.log</logFile> > <debugging>false</debugging> > > <!-- Query Cache Attributes--> > > <cacheEnabled>true</cacheEnabled> > <cacheSize>20</cacheSize> > <cacheRefreshInterval>120</cacheRefreshInterval> > > </datasource> > -------------------------------------------------- > > Has anyone please help me with this? > > Pranav > > -- > Get your firstname@lastname email at http://Nameplanet.com/?su > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- Peter Kordel Software Engineer Zvolve Systems, Inc. 770-551-4528 http://www.zvolve.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
