Wrox Home  
Search P2P Archive for: Go

  Return to Index  

j2ee thread: Poolman & Transaction Isolation Levels


Message #1 by "Mike Deegan" <mpdeegan@h...> on Tue, 2 Jul 2002 17:40:52
I'm developing JavaServer Pages using Poolman / MySQL / Tomcat. 

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

I am getting the following error in startup of Tomcat. 

java.sql.SQLException: SQLException occurred in JDBCPool: 
java.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? 
Thanks 

Mike 
(mpdeegan@h...) 

  Return to Index