If I remember correctly, mySQL only has limited support for transactions.

Have you tried not using <txIsolationLevel> at all (comment it out)?

You might want to look into PostgreSQL if you need <txIsolationLevel>, it's
got transactions/rollbacks and it's free too.


Greg



-----Original Message-----
From: Michael Deegan [mailto:mpdeegan@h...]
Sent: Friday, June 28, 2002 5:26 PM
To: Pro_JavaServer_Pages
Subject: [pro_jsp] Poolman & Transaction Isolation Levels.


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