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?
Thanks in advance.
---------------------------------------------------------------------
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
