Hi,
My environmment is next
WindowsNT 4.0(SP5)
Tomcat 3.2.3
MySql-max 3.23.46
Driver MySql: mm.mysql-2.0.8-bin.jar or gweMysql.jar
Poolman 2.0.4
It works fine.
I will attach my SimpleServet and poolman.xml for testing connection
to Database below.
I think PoolMan2.1.-b1 does not work fine.
-------- poolman.xml -------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<poolman>
<management-mode>local</management-mode>
<datasource>
<dbname>testdb</dbname>
<jndiName>jndi-testdb</jndiName>
<driver>org.gjt.mm.mysql.Driver</driver>
<!-- <driver>gwe.sql.gweMysqlDriver</driver> -->
<url>jdbc:mysql://xxxxxxxx:3306/xxxxx</url>
<username>xxxxx</username>
<password>xxxxxxxx</password>
</datasource>
</poolman>
----------------------------------------------------
-------- PoolmanDriverTest.java ---------------------
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class PoolmanDriverTest extends HttpServlet{
static String db_url = "jdbc:poolman://testdb"; // Virtual URL
static String driver = "com.codestudio.sql.PoolMan"; // PoolMan Driver
public void init() throws ServletException {
try{
Class.forName(driver).newInstance();
}
catch(Exception e){
e.printStackTrace();
}
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html; charset=Shift_JIS");
PrintWriter pw = res.getWriter();
pw.println("<html><body>");
pw.println("<h2>PoolmanDriverTest</h2>");
Connection conn = null;
try{
conn = DriverManager.getConnection(db_url);
System.out.println("OK!!!!!!!!!!!!!!!!!");
}
catch (Exception e){
e.printStackTrace();
}
finally{
if( conn != null )
{
try {
conn.close();
}
catch(Exception e){}
conn = null;
}
}
pw.println("</body></html>");
}
}
------------------------------------------------------
--
TAKAHASHI, Tomohiro
GABRIELMORENO wrote:
>
> Hi, Takahshi
>
> My environmment is the next:
> Windows 2000 Advanced Server
> Tomcat 4.0
> MySql 3.23.44
> Driver MySql: mm.mysql-2.0.8-bin.jar
> Poolman 2.1.-b1
>
> Regards
>
> Gabriel
>
> --------------------------------------------------------------------------------
>
> Subject: Re: Connection Pool
> Date: Tue, 11 Dec 2001 20:28:53 +0900
> From: "TAKAHASHI, Tomohiro" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> References: <[EMAIL PROTECTED]>
>
> Hi,
>
> Please tell about your environment.
> What is MySQL(-max) version?
> What is PoolMan version?
>
> Thanks.
>
> GABRIELMORENO wrote:
> >
> > My problem was the next:
> > I'm using Poolman to create a conecction pool in Tomcat 4 to access a
> > MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver,
> > JDBC throws this exception:
> >
> > java.sql.SQLException: Transaction Isolation Levels are not supported.
> > params: org.gjt.mm.mysql.Driver, jdbc:mysql://localhost/myDataBase.
> > Please check your username, password and other connectivity info.
> > java.sql.SQLException: Transaction Isolation Levels are not supported.
> >
> > My solution is the next: the problem is the MySql driver, I get a new
> > version and the problem is over. The new version is 2.0.8.
> >
> > Gabriel
>
> --
> 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
