jdbc connection pool problem, help, thanks!
Hi experts, I am looking for a library for managing connection pool as I can't use Tomcat, I found a couple of third party connection pool but with high coupling - using those require me to change quite a lot existing code, I am looking for something which can return a standard connection to me, any recommendations are much appericated! PS: I posted this question on Java section but no replys :( Ray -- View this message in context: http://www.nabble.com/jdbc-connection-pool-problem%2C-help%2C-thanks%21-tp15673813p15673813.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Announce: LBPool 1.0 beta1 (Load Balancing JDBC Connection Pool)
Kevin Burton wrote: Hey Gang. I wanted to get this out on the list and facilitate some feedback. http://www.feedblog.org/2006/07/announce_lbpool.html What does this have over MySQL Connector/J's load balancing? -- Christopher G. Stach II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Announce: LBPool 1.0 beta1 (Load Balancing JDBC Connection Pool)
There was a thread before about this... this is much better than connector J's load balancing. You can take machines out of production, add thhem back in, it's MySQL slave aware, etc On 7/19/06, Christopher G. Stach II [EMAIL PROTECTED] wrote: Kevin Burton wrote: Hey Gang. I wanted to get this out on the list and facilitate some feedback. http://www.feedblog.org/2006/07/announce_lbpool.html What does this have over MySQL Connector/J's load balancing? -- Christopher G. Stach II -- Founder/CEO Tailrank.com Location: San Francisco, CA AIM/YIM: sfburtonator Skype: burtonator Blog: feedblog.org
Announce: LBPool 1.0 beta1 (Load Balancing JDBC Connection Pool)
Hey Gang. I wanted to get this out on the list and facilitate some feedback. http://www.feedblog.org/2006/07/announce_lbpool.html I CC'd both lists because this might be of interest to the larger MySQL community as the techniques I used here could be implemented in other languages. == The lbpool project provides a load balancing JDBC driver for use with DB connection pools. It wraps a normal JDBC driver providing reconnect semantics in the event of additional hardware availability, partial system failure, or uneven load distribution. It also evenly distributes all new connections among slave DB servers in a given pool. Each time connect() is called it will attempt to use the best server with the least system load. The biggest scalability issue with large applications that are mostly READ bound is the number of transactions per second that the disks in your cluster can handle. You can generally solve this in two ways. 1. Buy bigger and faster disks with expensive RAID controllers. 2. Buy CHEAP hardware on CHEAP disks but lots of machines. We prefer the cheap hardware approach and lbpool allows you to do this. Even if you *did* manage to use cheap hardware most load balancing hardware is expensive, requires a redundant balancer (if it were to fail), and seldom has native support for MySQL. The lbpool driver addresses all these needs. The original solution was designed for use within MySQL replication clusters. This generally involves a master server handling all writes with a series of slaves which handle all reads. In this situation we could have hundreds of slaves and lbpool would load balance queries among the boxes. If you need more read performance just buy more boxes. If any of them fail it won't hurt your application because lbpool will simply block for a few seconds and move your queries over to a new production server. While currently designed for MySQL this could easily be updated to support PostgresQL or any other DB that supports replication. -- Founder/CEO Tailrank.com Location: San Francisco, CA AIM/YIM: sfburtonator Skype: burtonator Blog: feedblog.org
Re: Are Mysql ODBC supporting connection pool?
Hello. See: http://dev.mysql.com/doc/refman/5.0/en/connection-pool.html wangxu wrote: Are Mysql ODBC supporting connection pool? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Are Mysql ODBC supporting connection pool?
Connection pool facility is not in the JDBC driver. It is provided by the application server like JBoss, Websphere, Weblogic, etc. Tool like Hibernate and IBatis also provide it. Vi. wangxu [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Are Mysql ODBC supporting connection pool? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connection pool
Hi, Does anyone has a connection pool built for MySQL using JAva (the application run on Tomcat).. I have one but its not running satisfactorily and leaves some processes suspended.. thnx in adv, sands - 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
How to set up JDBC connection pool with Tomcat?
How do you set up the server.xml and web.xml files to use connection pooling in Tomcat using the org.gjt.mm.mysql.Driver JDLC driver (version mm.mysql-2.0.11)? I have set up and used a simple data source, but I can't get the pooled one working - do I need to set it up differently? Originally, I had the following in server.xml: Resource name=jdbc/mptest auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/mptest parameternamedriverClassName/namevalueorg.gjt.mm.mysql.Driver/v alue/parameter parameternamedriverName/namevaluejdbc:mysql://localhost/mptest/ value/parameter /ResourceParams And the following in web.xml: resource-ref descriptionTest/description res-ref-namejdbc/mptest/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref This works fine, but no connection pooling. I tried substituting javax.sql.ConnectionPoolDataSource for javax.sql.DataSource, but this blows up. Can I set this up via config files? Or do I need to resort to code to set this up? Tia, R - 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
Re: Connection Pool
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
Re: Connection Pool
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-modelocal/management-mode
datasource
dbnametestdb/dbname
jndiNamejndi-testdb/jndiName
driverorg.gjt.mm.mysql.Driver/driver
!-- drivergwe.sql.gweMysqlDriver/driver --
urljdbc:mysql://:3306/x/url
usernamex/username
password/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("htmlbody");
pw.println("h2PoolmanDriverTest/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
Connection pool
Hello to all. First, I'm sorry, but my englis is very, very bad. My problem is 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. Can you help me? Thanks. Gabriel Moreno. __ Ahora que Shrek ya está en video y DVD, Qtal te regala su música, entra en: https://www.qtal.com/shrek/shrek.htm - 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
Connection Pool
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 - 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
