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