Hi again, Poolman was giving errors because I was using an older version of mysql-jdbc driver. One must use 2.0.7 upwards to be compatible, I guess. Pranav On 18 Jan 2002 17:19:40 -0000 [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]> > >
-- 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]>
