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
