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]>
