You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by pr...@nameplanet.com on 2002/01/18 18:19:40 UTC

Struts DataSource times out; Poolman gives errors

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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: Struts DataSource times out; Poolman gives errors

Posted by Peter Kordel <pk...@zvolve.com>.
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.

pranav@nameplanet.com 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:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>

-- 
Peter Kordel
Software Engineer
Zvolve Systems, Inc.
770-551-4528
http://www.zvolve.com

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>