Wrox Home  
Search P2P Archive for: Go

  Return to Index  

j2ee thread: Re: Poolman & Transaction Isolation Levels


Message #1 by "mitch chan" <mjchan@e...> on Wed, 21 Aug 2002 23:23:18
Mike, Mysql does not support transactions.  So Poolman barfs when it trys 
to connect.

Try replacing the line
   <txIsolationLevel>READ_COMMITTED</txIsolationLevel> 
with
   <txIsolationLevel>NONE</txIsolationLevel> 

Good luck.  -Mitch

> I'm developing JavaServer Pages using Poolman / MySQL / Tomcat. 

> Using CATALINA_BASE: C:\jakarta-tomcat-4.0.3 
U> sing CATALINA_HOME: C:\jakarta-tomcat-4.0.3 
U> sing JAVA_HOME:     C:\jdk1.3.1_02 

> I am getting the following error in startup of Tomcat. 

> java.sql.SQLException: SQLException occurred in JDBCPool: 
j> ava.sql.SQLException: Transaction Isolation Levels are not supported. 

> Does someone know where I should I start looking. 

> The following is from my Poolman.xml: 

> (PS: I have tried all values of <txIsolationLevel>) 

> <!-- ============================== --> 
<> !-- Physical Connection Attributes --> 
<> !-- ============================== --> 

> <!-- Standard JDBC Driver info --> 
<> dbname>fef_db</dbname> 
<> jndiName>jndi-fef_db</jndiName> 
<> driver>org.gjt.mm.mysql.Driver</driver> 
<> url>jdbc:mysql://localhost:3306/fef_db</url> 
<> username>deegs</username> 
<> password>********</password> 

> <!-- Transaction Isolation Level, an optional value that, --> 
<> !-- if present, must be one of the following:            --> 
<> !-- NONE                                                 --> 
<> !-- READ_COMMITTED                                       --> 
<> !-- READ_UNCOMMITTED                                     --> 
<> !-- REPEATABLE_READ                                      --> 
<> !-- SERIALIZABLE                                         --> 
<> !-- If the value is misspelled or ommitted, the default  --> 
<> !-- will be applied. The value is not case-sensitive.    --> 
<> !-- DEFAULT: READ_COMMITTED                              --> 
<> txIsolationLevel>READ_COMMITTED</txIsolationLevel> 

> 

> Does someone know where I should I start looking or has anyone 
experienced 
a>  similar problem? 
T> hanks 

> Mike 
(> mpdeegan@h...) 

  Return to Index