|
 |
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...)
|
|
 |