I have tried all the transaction isolation levels
(READ_COMMITTED,READ_UNCOMMITTED,...) and even I have deleted that line in
poolman.xml file, but it isn't working yet
I'm new in mysql and I haven't modified any configuration in mysql. Maybe
any option that I haven't configured. Any idea?
Thanks in advance
----- Original Message -----
From: TAKAHASHI, Tomohiro <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 02, 2001 3:43 PM
Subject: Re: error in mysql using poolman
> HI,
>
> I think MySQL does not support TransactionIsolationLevel NONE.
> And, setTransactionIsolation method of 'org.gjt.mm.mysql.Driver' will
> throw SQL Exception. Because, in that case, driver sends SQL statement
> 'SET SESSION TRANSACTION ISOLATION LEVEL ;'
> to MySQL. This SQL statement is wrong.
>
> Try another Transaction Isolation Level.
>
> Thanks.
>
> felix wrote:
> >
> > First of all, sorry for this email if you are not the proper person, but
I'm
> > desperate with this problem
> >
> > I am testing PoolMan to provide database connection pooling on W98
running
> > mysql with the mm.mysql JDBC drivers and JDK 1.3.1.
> >
> > When I execute my sample code the next error appears:
> >
> > "java.sql.SQLException: SQLException occurred in JDBCPool:
> > java.sql.SQLException:
> > Transaction Isolation Levels are not supported.
> > params: org.gjt.mm.mysql.Driver, jdbc:mysql://127.0.0.1/cd. Please check
> > your us
> > ername, password and other connectivity info."
> >
> > I have checked the params of the database connection and it's working
> > correctly with another sample code using standard Java API to access
> > database.
> >
> > The definition of datasource in poolman.xml is:
> >
> > <datasource>
> >
> > <dbname>mydb</dbname>
> > <jndiName>jndi-mydb</jndiName>
> > <driver>org.gjt.mm.mysql.Driver</driver>
> > <url>jdbc:mysql://127.0.0.1/cd</url>
> >
> > <username></username>
> > <password></password>
> > <minimumSize>0</minimumSize>
> > <maximumSize>10</maximumSize>
> > <txIsolationLevel>NONE</txIsolationLevel>
> >
> > <logFile>C:\felix\bd\poolman-2.1-b1\test\mydb.log</logFile>
> >
> > </datasource>
> >
> > An the java sample code is:
> > Class.forName("com.codestudio.sql.PoolMan").newInstance();
> > Connection con = DriverManager.getConnection("jdbc:poolman://"
+
> > "mydb");
> >
> > What's wrong?
>
> --
> TAKAHASHI, Tomohiro
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
