Problem starting connection pooling

2010-01-22 Thread Mark Witczak
I'm very new to MySQL, Tomcat, connection pooling, JSP, etc. and I've been banging my head against a wall for two weeks trying to get a simple program to connect to a MySQL database. *Vital Stats:* Ubuntu 9.10, Java 1.6.0_0, Java Servelet 2.5, Java Server Pages 2.1, JSTL 1.2, Apache2

Re: Problem starting connection pooling

2010-01-22 Thread Mark Matthews
On Jan 22, 2010, at 10:21 AM, Mark Witczak wrote: [snip] I create the WAR (jar cvf testapp.war *), undeploy the old version and redeploy the new one through Tomcat Web Application Manager. Then restart Tomcat (sudo /etc/init.d/tomcat restart). The result is: Jan 21, 2010 9:40:35 PM

Re: Problem starting connection pooling

2010-01-22 Thread Mark Witczak
Alright, here is the entire log entry: Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextInitialized() Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log INFO: SessionListener: contextInitialized() Jan 21, 2010 9:43:06 PM

Re: Problem starting connection pooling

2010-01-22 Thread Mark Matthews
On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote: Alright, here is the entire log entry: Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextInitialized() Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log INFO:

Re: Problem starting connection pooling

2010-01-22 Thread Mark Witczak
skip-networking is OFF On 1/22/2010 12:09 PM, Mark Matthews wrote: On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote: Alright, here is the entire log entry: Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextInitialized() Jan 21, 2010

Connection Pooling with mysql-5.1.11-beta-linux-i686

2006-08-28 Thread Rob Emanuele
Greetings all, I'm working with mysql-5.1.11-beta-linux-i686 set up using the NDB cluster. I was wondering if there are any limitations or inefficiencies if I was to use a connection pool to the mysql server(s) front-ending the cluster? Several processes will make a request of our server and

Re: Connection Pooling

2006-05-09 Thread romyd misc
Has anyone implemented connection pooling in C# .NET? On 5/8/06, romyd misc [EMAIL PROTECTED] wrote: What i meant by implementing connection pooling i meant if i need to do any code changes other than changes in connection string. Thanks, Romy On 5/8/06, Tim Lucia [EMAIL PROTECTED] wrote

Connection Pooling

2006-05-08 Thread romyd misc
one request try to access database, i get object reference errors. I don't get this error when frequency of database calls is low. Does it sounds like i need to implement connection pooling? I tried to lookup online, but couldn't find any help under mysql documentation. Can someone help me setting up

RE: Connection Pooling

2006-05-08 Thread Tim Lucia
I don't hear you need to implement connection pooling. Maybe, but I think you might still have errors under load, as you approach the maximum connection count in the pool. Tim -Original Message- From: romyd misc [mailto:[EMAIL PROTECTED] Sent: Monday, May 08, 2006 2:37 PM To: mysql

Re: Connection Pooling

2006-05-08 Thread William R. Mussatto
stress or when more than one request try to access database, i get object reference errors. I don't get this error when frequency of database calls is low. Does it sounds like i need to implement connection pooling? I tried to lookup online, but couldn't find any help under mysql documentation. Can

Re: Connection Pooling

2006-05-08 Thread romyd misc
What i meant by implementing connection pooling i meant if i need to do any code changes other than changes in connection string. Thanks, Romy On 5/8/06, Tim Lucia [EMAIL PROTECTED] wrote: I don't hear you need to implement connection pooling. Maybe, but I think you might still have errors

RE: Connection Pooling

2006-05-08 Thread Tim Lucia
PROTECTED] Sent: Monday, May 08, 2006 4:33 PM To: Tim Lucia Cc: mysql@lists.mysql.com Subject: Re: Connection Pooling What i meant by implementing connection pooling i meant if i need to do any code changes other than changes in connection string. Thanks, Romy On 5/8/06, Tim Lucia [EMAIL PROTECTED

Table Lock Delays and Connection Pooling

2004-10-18 Thread Aaron
. It will also wait for the first SELECT to finish! So what constitutes a new client exactly? We use Perl and DBI to connect to MySQL. Does this mean that everytime we connect to the DBase it is considered a new client? If so , would some form of connection pooling/caching help reduce the lock delays

Re: Table Lock Delays and Connection Pooling

2004-10-18 Thread Eric Bergen
for the UPDATE to finish. It will also wait for the first SELECT to finish! So what constitutes a new client exactly? We use Perl and DBI to connect to MySQL. Does this mean that everytime we connect to the DBase it is considered a new client? If so , would some form of connection pooling

Desperate here: Connection error 08000 and Connection Pooling

2004-09-08 Thread Michael McQuade
Server, MySql v = 4.1.3b-beta-nt, ConnectorJ v 3.0.11-stable-bin and running Servlets on = Tomcat v 5.0.27 and attempting to run Connection Pooling. PLEASE, if anyone is running this sort of configuration, email me = directly at [EMAIL PROTECTED], I desperately need some minor help, = I been

Connection pooling with C?

2004-08-23 Thread Jaye Mathisen
based connection pooling thingamabob I can use, like mysql_pconnect, and some external demon of some kind to assist? Thanks in advance for any help. I can find tons of stuff for perl/web based stuff, but I need it for C. Thanks. -- MySQL General Mailing List For list archives: http

Re: Tomcat, Connection Pooling, and MySQL

2003-10-04 Thread Adam Hardy
I set it up months ago Dan Greene -Original Message- From: Steven Nakhla [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 9:42 AM To: MySQL Subject: Tomcat, Connection Pooling, and MySQL Has anyone managed to setup Tomcat to use MySQL for database connection pooling

Tomcat, Connection Pooling, and MySQL

2003-10-03 Thread Steven Nakhla
Has anyone managed to setup Tomcat to use MySQL for database connection pooling? I've found this document which gives information on it: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html However, when I try and run it I get messages about not being able

RE: Tomcat, Connection Pooling, and MySQL

2003-10-03 Thread Dan Greene
the right one... Sorry that I'm being incredibly vague I set it up months ago Dan Greene -Original Message- From: Steven Nakhla [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 9:42 AM To: MySQL Subject: Tomcat, Connection Pooling, and MySQL Has anyone managed to setup

MySql JDBC connection pooling in Websphere

2003-01-07 Thread Tom O'Neil
I have configured WAS Express 5.0 to connect to MySql 4.0, however I am unable to open any connections. I know that the connection to the MySql server works, because if I change any of the connection parameters (port, database name, login), the JDBC driver returns the appropriate error message. I

Re: MySql JDBC connection pooling in Websphere

2003-01-07 Thread Mark Matthews
? As far as I can tell, this is a bug in WebSphere's connection pooling classes, because getTypeMap() is not required to be implemented (by the JDBC spec. You can try returning an empty java.util.HashMap() from that method and see if that makes your connection pool work. If so, I can add

Re: JDBC Connection Pooling Not Quite Right?

2002-11-09 Thread Rick Mann
sql, query ... just to make the filter happy. on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: You are missing something, I am afraid. To quite Sun's Javadoc for the PooledConnection class Thank you so much for the quick reply. Now I understand why the implementation of

Re: JDBC Connection Pooling Not Quite Right?

2002-11-09 Thread Mark Matthews
between a JDBC driver and an application server to provide connection pooling. On the other hand, you don't need to re-invent the wheel either. There is a lot of open source connection pooling code out there. The one I'm currently recommending (as it sees the most current development) is DBCP from

JDBC Connection Pooling Not Quite Right?

2002-11-08 Thread Rick Mann
Hi. I hope this is the right place to discuss this, now that the drivers are part of the official MySQL stuff. If not, please let me know where I should post this. Thanks. I've been using the 2.0.14 version of the drivers, and just recently switched to using the pooled connections supplied by

Re: JDBC Connection Pooling Not Quite Right?

2002-11-08 Thread Alec . Cawley
Hi, Rick, Hi. I hope this is the right place to discuss this, now that the drivers are part of the official MySQL stuff. If not, please let me know where I should post this. Thanks. The Java list - [EMAIL PROTECTED] - would probaby be more appropriate than the general list, but otherwise

Re: InnoDB transactions with Connection Pooling

2002-04-22 Thread Jeremy Zawodny
On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote: Mark, if you do not explicitly do SET AUTOCOMMIT=0 then MySQL automatically calls COMMIT after every SQL statement. Make that: SET AUTOCOMMIT=1 Heikki is probably low on coffee. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL

Re: InnoDB transactions with Connection Pooling

2002-04-22 Thread Heikki Tuuri
Jeremy, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:37 AM Subject: Re: InnoDB transactions with Connection Pooling On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote

Re: InnoDB transactions with Connection Pooling

2002-04-21 Thread Heikki Tuuri
PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, April 22, 2002 3:35 AM Subject: InnoDB transactions with Connection Pooling Fellow MySQL gurus, I am using Apache::DBI to accomplish connection pooling. I am working with an InnoDB table that gets updated very frequently. My question

Connection Pooling (closing of connections)

2001-08-16 Thread gaurav
Hi, I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.the application is deployed in tomcat.I am using connection pooling package in my application.i am able to create a pool when the first user logs in.kindly advice how i can close or destroy the connections when the server

Connection Pooling(closing)

2001-08-16 Thread gaurav
Hi, I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.the application is deployed in tomcat.I am using connection pooling package in my application.i am able to create a pool when the first user logs in.kindly advice how i can close or destroy the connections when the server

Connection Pooling

2001-08-09 Thread gaurav
Hi, I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.I want to use connection pooling in my application.Kindly advice connection pooling package which is suitable for the above application. Thanking You, Gaurav Tuli

RE: Connection Pooling

2001-08-09 Thread Jamie Krasnoo
, August 09, 2001 12:33 AM To: [EMAIL PROTECTED] Subject: Connection Pooling Hi, I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.I want to use connection pooling in my application.Kindly advice connection pooling package which is suitable for the above application. Thanking You