Re: HOW DOES TOMCAT JNDI CONNECTION POOLING WORKS

2005-09-23 Thread David Smith
1. Does tomcat really look into the pool? Yes. The pool code is really the commons DBCP project code refactored slightly to avoid collisions with the real DBCP project code. 2. on conn.close(), are we really pushing the connection back into the pool? Yes. Sorry I can't help you on the Eclipse

HOW DOES TOMCAT JNDI CONNECTION POOLING WORKS

2005-09-23 Thread rahul
Hi all, My questing is derived from the sample code given at : http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html#Database%20Connection%20Pool%20(DBCP)%20Configurations If you can see the subsection 4(i.e. testcode) of section "MySQL DBCP Example", to get a conne

Tomcat DB Connection Pooling

2005-09-05 Thread Dhiren Bhatia
Hi I'm having a problem reclaiming connections in my database connection pool. I'm using the standard db conn pooling with Tomcat 5.5.9 with MySQL. I release the connection as well as close the PreparedStatement in the code after use. However, I still get errors with logEnabled set to true sayi

RE: Has anyone used Tomcat 5.5.9 connecting to MS SQL Server usin g JNDI and Connection Pooling?

2005-08-24 Thread Wylie, Ian
Hi Allistair, The problem was that I had duplicated the TOMCAT_HOME/conf/Catalina/localhost/webappname.xml entry in server.xml. So I removed the context element from server.xml. Then, the basic datasource JNDI started working. I will investigate the change you suggested for Connection Pooling

RE: Has anyone used Tomcat 5.5.9 connecting to MS SQL Server using JNDI and Connection Pooling?

2005-08-24 Thread Allistair Crossley
ubject: RE: Has anyone used Tomcat 5.5.9 connecting to MS SQL Server > using JNDI and Connection Pooling? > > > Hi Allistair, > > I just got the basic JNDI datasource working for MS SQL > Server with Tomcat > 5.5. > > I tried using the ConnectionPoolDataSource inst

RE: Has anyone used Tomcat 5.5.9 connecting to MS SQL Server using JNDI and Connection Pooling?

2005-08-24 Thread Allistair Crossley
m: Wylie, Ian [mailto:[EMAIL PROTECTED] > Sent: 24 August 2005 12:33 > To: Tomcat Users List > Subject: RE: Has anyone used Tomcat 5.5.9 connecting to MS SQL Server > using JNDI and Connection Pooling? > > > Hi Allistair, > > I just got the basic JNDI datasource workin

RE: Has anyone used Tomcat 5.5.9 connecting to MS SQL Server usin g JNDI and Connection Pooling?

2005-08-24 Thread Wylie, Ian
web.xml file. I changed the driverclass name from the standard datasource class of com.microsoft.jdbc.sqlserver.SQLServerDriver - used with standard datasource to the com.microsoft.jdbcx.sqlserver.SQLServerDataSource class used by MS connection pooling in the TOMCAT_HOME/conf/Catalina/localhost

RE: Tomcat application won't start with MySQL Connection Pooling

2005-08-08 Thread James Adams
> Please note the following for the path attribute in > the Tomcat 5.5 doc for : > > "The value of this field must not be set except when > statically defining a Context in server.xml, as it > will be infered [sic] from the filenames > used for either the .xml context file or the > docBase." > > A

RE: Tomcat application won't start with MySQL Connection Pooling

2005-08-06 Thread Caldarale, Charles R
> From: James Adams [mailto:[EMAIL PROTECTED] > Subject: RE: Tomcat application won't start with MySQL > Connection Pooling > > I have now created a context.xml according to the > example in the Tomcat 5.5 documentation and this time > I've placed it my appl

RE: Tomcat application won't start with MySQL Connection Pooling

2005-08-05 Thread James Adams
> > I'm curious: why are you using the documentation for an > older level to configure the current version? Things > have changed in this area (among others) between 5.0 > and 5.5. > You bring up a very good point, thanks for spotting that for me. I have now created a context.xml according to

RE: Tomcat application won't start with MySQL Connection Pooling

2005-08-05 Thread Caldarale, Charles R
> From: James Adams [mailto:[EMAIL PROTECTED] > Subject: Tomcat application won't start with MySQL Connection Pooling > > I have tried adding connection pooling for a MySQL > database in Tomcat 5.5 by following the steps described > [URL=http://jakarta.apache.org/tomcat/t

Tomcat application won't start with MySQL Connection Pooling

2005-08-05 Thread James Adams
I have tried adding connection pooling for a MySQL database in Tomcat 5.5 by following the steps described [URL=http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html]here[/URL]. Now when I start Tomcat my application fails to load. The only message I can find in

Tomcat Connection Pooling - Future of?

2005-07-18 Thread Pete Steijn
Greetings, I am a student at the University of Delaware looking to do research on connection pooling. Currently I am analyzing the feasability of optimizing connection pooling. My hypothesis is that using a statistical analysis of the usage history to create a prediction of usage levels in

Re: AW: Tomcat 5.5.9 connection pooling

2005-07-18 Thread Chris. Grobmeier
Hi Peter, i've had this problem in a project long ago. I left the company befor i solved this, but meanwhile i am quite sure this was not a problem of Tomcat, but of using ResultSet wrong. Maybe this is your problem too. ResultSet is a connection to the database- if you iterate over ResultSet

AW: Tomcat 5.5.9 connection pooling

2005-07-18 Thread Peter . Zoche
: Tomcat 5.5.9 connection pooling Can you attach the exception thrown ? Viorel Dragomir . .. --- - Original Message - From: [EMAIL PROTECTED] To: tomcat-user@jakarta.apache.org Sent: Monday, July 18, 2005 13:38 Subject

Re: Tomcat 5.5.9 connection pooling

2005-07-18 Thread Yasir Khan
Can you please write what exception do you get when you try to close the database connection? - Original Message - From: [EMAIL PROTECTED] To: tomcat-user@jakarta.apache.org Sent: Monday, July 18, 2005 4:38 PM Subject: Tomcat 5.5.9 connection pooling Hi! I am using

Re: Tomcat 5.5.9 connection pooling

2005-07-18 Thread Viorel Dragomir
pooling Hi! I am using Tomcat 5.5.9 and I have established a DataSource for database connection pooling where I can get connections from. But when I try to close the connection via myConnection.close(), always an exception is thrown. Is it right to close the connection this way or do I have to return

Tomcat 5.5.9 connection pooling

2005-07-18 Thread Peter . Zoche
Hi! I am using Tomcat 5.5.9 and I have established a DataSource for database connection pooling where I can get connections from. But when I try to close the connection via myConnection.close(), always an exception is thrown. Is it right to close the connection this way or do I have to return the

Re: Tomcat5.0 Database Connection Pooling Configuration

2005-07-14 Thread Alon Belman
you can define resources for all of a host's contexts by using a GlobalNamingResources element see here for more info: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/globalresources.html On 7/13/05, Foo Shyn <[EMAIL PROTECTED]> wrote: > Hi there, > > Have a question on dbcp settings. I'd

Tomcat5.0 Database Connection Pooling Configuration

2005-07-13 Thread Foo Shyn
Hi there, Have a question on dbcp settings. I'd done the settings by configuring the server.xml and the web.xml of my application and it works fine. But since i need to install multiple application on the same Tomcat server, i'll need to place different tag in the server.xml for each applicati

Re: still not clear with connection pooling in tomcat

2005-04-11 Thread Krishnakant Mane
hello Mr. Ajay Kumar, thanks a lot. I am using tomcat 5.0.25 and I have the context file in the conf/Catalina/localhost directory. in that file where should I put the code u provided in server.xml after the tag is over or before the tag is closed? thanks Krishnakant. Send instant messages to your

connection pooling with JTOpen Toolbox_tomcat 5.5.7

2005-04-11 Thread sudip shrestha
Using: tomcat 5.5.7, JTOpen 4.7 JDBC Driver for AS/400 DB2 The DBAdmin of the company I work for ends the subsystems at night time for the backup, so the connection dies during that time and when I try to reconnect to application server via my webapp in the morning, it throws me exception saying th

Re: still not clear with connection pooling in tomcat

2005-04-11 Thread ajay kumar
Hi I also struggled for the Tomcat Connection Pooling problem for one week and i got the solution. write the follwing code snippets in respective files: -web.xml-- jdbc/TestDB javax.sql.DataSource Container

Re: still not clear with connection pooling in tomcat

2005-04-09 Thread Krishnakant Mane
thanks a lot doug, if I have any problem I will trouble again. just a couple of questions. there were two parameters in the email you sent the other day. I did not get the meaning of those parameters stating that active connections should be 100 and the other with 30 as the value. what is the diffe

Re: still not clear with connection pooling in tomcat

2005-04-08 Thread Parsons Technical Services
Mane" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Friday, April 08, 2005 5:06 AM Subject: Re: still not clear with connection pooling in tomcat thanks doug. I got my application right. only one problem remains. where do I initialise the connection. and what should I do

Re: still not clear with connection pooling in tomcat

2005-04-08 Thread Krishnakant Mane
thanks doug. I got my application right. only one problem remains. where do I initialise the connection. and what should I do in the init method of the servlet. or is it that I wont need to use the init method at all? thanks again Krishnakant. Send instant messages to your online friends http://uk

Re: still not clear with connection pooling in tomcat

2005-04-06 Thread Parsons Technical Services
Message - From: "Krishnakant Mane" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Wednesday, April 06, 2005 8:08 AM Subject: Re: still not clear with connection pooling in tomcat never mind doug, in fact it seams that your asking questions reflects nothi

Re: still not clear with connection pooling in tomcat

2005-04-06 Thread Krishnakant Mane
never mind doug, in fact it seams that your asking questions reflects nothing but professionalism and perfection. that's the way to do it. by the way the relation to databases is one to one with web apps. one web app is going to refer to only one database. so that is the way it is going to be. t

Re: still not clear with connection pooling in tomcat

2005-04-05 Thread Parsons Technical Services
"" + rowData[col]); } } buffer.append("\n"); return(buffer.toString()); } } This has one drawback, you cannot take advantage of an updatable recordset. Any changes must be written back to the database with an update. - Original Message - From: "Krishnakant Mane&q

Re: still not clear with connection pooling in tomcat

2005-04-05 Thread Krishnakant Mane
hello doug, I will be using this tomcat server for many web applications. and yes the mysql instance will be the same. I just run one mysqld instance for my server. there will be different databases and different web applications. thanks Krishnakant. Send instant messages to your online friends

Re: connection pooling basic help please

2005-04-04 Thread Kwok Peng Tuck
Krishnakant Mane wrote: hello, I refered to the docs in tomcat 5 for connection pooling. the document is pritty comprehencive and I understood the server.xml part of it. but now I want to know how exactly can I use a connection from the pool in my servlet. the example in tomcat documentation is

Re: still not clear with connection pooling in tomcat

2005-04-04 Thread Parsons Technical Services
> To: "Tomcat Users List" Sent: Monday, April 04, 2005 7:25 AM Subject: Re: still not clear with connection pooling in tomcat doug, thanks again for ur response. Well it is not 5.5. It is 5.0.xx Thanks Krishnakant. Send instant messages to your online friends htt

Re: still not clear with connection pooling in tomcat

2005-04-04 Thread Krishnakant Mane
doug, thanks again for ur response. Well it is not 5.5. It is 5.0.xx Thanks Krishnakant. Send instant messages to your online friends http://uk.messenger.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional c

Re: still not clear with connection pooling in tomcat

2005-04-04 Thread Parsons Technical Services
cat Users List" Sent: Monday, April 04, 2005 2:16 AM Subject: Re: still not clear with connection pooling in tomcat hello doug, I am sending the following details on the questions you asked. and thanks for your help. I am using mysql as the database back-end and tomcat version 5. I have

Re: still not clear with connection pooling in tomcat

2005-04-03 Thread Krishnakant Mane
hello doug, I am sending the following details on the questions you asked. and thanks for your help. I am using mysql as the database back-end and tomcat version 5. I have the mysql jdbc the latest stable version. and the server is right now going to support a single application but I plan to ser

Re: still not clear with connection pooling in tomcat

2005-04-03 Thread Parsons Technical Services
OS version. Doug - Original Message - From: "Krishnakant Mane" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Sunday, April 03, 2005 8:47 AM Subject: RE: still not clear with connection pooling in tomcat hello all, Thanks for your help on this issue. ho

RE: still not clear with connection pooling in tomcat

2005-04-03 Thread Krishnakant Mane
hello all, Thanks for your help on this issue. however I still can't get my problem solved. 10 different articles give 10 different solutions. however my problem is simple. I have a streight forward question. I want to implement connection pooling in the tomcat 5 web container and I hav

RE: still not clear with connection pooling in tomcat

2005-04-02 Thread Guy Katz
connection pooling in tomcat hello all, I am still a bit confused on the pooling issue in tomcat. I will be very happy if some one could explain connection pooling with reference to my problems listed below. 1. there are the jakarta commons libraries like the dbcp etc in the catalina/common/lib

still not clear with connection pooling in tomcat

2005-04-02 Thread Krishnakant Mane
hello all, I am still a bit confused on the pooling issue in tomcat. I will be very happy if some one could explain connection pooling with reference to my problems listed below. 1. there are the jakarta commons libraries like the dbcp etc in the catalina/common/lib directory. how do I take

Re: connection pooling basic help please

2005-04-02 Thread QM
On Sat, Apr 02, 2005 at 08:21:24PM +0100, Krishnakant Mane wrote: : the example in tomcat documentation is on a jsp based : applicatio. but I don't understand how I use a pooled : connection in a servlet. : [snip] : should I initialise the connection in the Init method? : how and when should I cl

connection pooling basic help please

2005-04-02 Thread Krishnakant Mane
hello, I refered to the docs in tomcat 5 for connection pooling. the document is pritty comprehencive and I understood the server.xml part of it. but now I want to know how exactly can I use a connection from the pool in my servlet. the example in tomcat documentation is on a jsp based applicatio

Re: connection pooling confusion help needed

2005-03-29 Thread Preeti Iyer
ava servlets > with tomcat 5 on a production ready server for real > time use. > I am thinking of using connection pooling but I am a > bit confused. I have initialised all my connections > in the servlet's init method and closed them in > distroy method. > so these connections

active and idle connection pooling confusion!

2005-03-27 Thread Krishnakant Mane
hello, I have been going through the connection pooling docs in the tomcat 5 documentation. and fortunately I found out the sample for mysql jdbc. now there is a confusion. I want to know what is the difference between max active and max idle connections. I mean what is the concept behind these

RE: connection pooling confusion help needed

2005-03-25 Thread pandu yelamanchili
To: tomcat-user@jakarta.apache.org Subject: connection pooling confusion help needed Date: Fri, 25 Mar 2005 19:11:15 + (GMT) hello all, im going to put a web application in java servlets with tomcat 5 on a production ready server for real time use. I am thinking of using connection pooling but I am a bit c

connection pooling confusion help needed

2005-03-25 Thread Krishnakant Mane
hello all, im going to put a web application in java servlets with tomcat 5 on a production ready server for real time use. I am thinking of using connection pooling but I am a bit confused. I have initialised all my connections in the servlet's init method and closed them in distroy metho

RE: Connection pooling verse one connection per session

2005-03-10 Thread Caldarale, Charles R
> From: Mark Winslow [mailto:[EMAIL PROTECTED] > Subject: RE: Connection pooling verse one connection per session > > Sorry, just had one other question about the use of > static variables. Can this really be a problem? I > thought that a static variable only gets a sin

RE: Connection pooling verse one connection per session

2005-03-10 Thread Caldarale, Charles R
> From: Mark Winslow [mailto:[EMAIL PROTECTED] > Subject: RE: Connection pooling verse one connection per session > > The memory usage grows and grows unexplicably. Modern JVMs also try to avoid doing GC if they can. So, if you've given the JVM a large amount of memory, i

RE: Connection pooling verse one connection per session

2005-03-10 Thread Mark Winslow
Sorry, just had one other question about the use of static variables. Can this really be a problem? I thought that a static variable only gets a single copy per JVM/Context. For instance the use of static variables to define formats shouls save on memory usage shouldn't it? public class Helper

RE: Connection pooling verse one connection per session

2005-03-10 Thread Mark Winslow
I don't know. I have one pure Tomcat (no Apache) server that all it does is serve about 300,000 static files per day. The memory usage grows and grows unexplicably. I run a cron job that restarts it everyday, which I had to started running with version 5.0.something or else it would eventually r

Re: Connection pooling verse one connection per session

2005-03-10 Thread QM
On Thu, Mar 10, 2005 at 01:52:02PM -0800, Mark Winslow wrote: : I'm still not entirely sure about this issue. The : close/=null + finally blocks make for pretty ugly and : error prone code if you ask me. Well, certainly no one's forcing you to code that way. It's just a fairly standard practice

RE: Connection pooling verse one connection per session

2005-03-10 Thread Caldarale, Charles R
> From: Mark Winslow [mailto:[EMAIL PROTECTED] > Subject: RE: Connection pooling verse one connection per session > > "if ever."??? Is that really the case? My personal > experience with Tomcat is that it does indeed have > memory leak problems. Nearly all the memo

RE: Connection pooling verse one connection per session

2005-03-10 Thread Mark Winslow
"if ever."??? Is that really the case? My personal experience with Tomcat is that it does indeed have memory leak problems. In theory, shouldn't all objects created in a web user session eventually be garbage collected after the session ends? I in fact did mean the finalize() method. Is that th

RE: Connection pooling verse one connection per session

2005-03-10 Thread Caldarale, Charles R
On Thu, Mar 10, 2005 at 10:31:41AM -0800, Mark Winslow wrote: > > 2. Have better control of connection releases via the > finalize() method in a session "helper" class that > contains the one single connection. I hope you meant "finally clause" rather than "finalize() method". A finalize() met

Re: Connection pooling verse one connection per session

2005-03-10 Thread Mark Winslow
Connection%20Pool%20(DBCP)%20Configurations > : > : "There is one problem with connection pooling. A > web > : application has to explicetely close ResultSet's, > : Statement's, and Connection's." > > I'd hardly say that's a "problem"; that

Re: Connection pooling verse one connection per session

2005-03-10 Thread QM
On Thu, Mar 10, 2005 at 12:30:22PM -0800, Mark Winslow wrote: : http://jakarta.apache.org/tomcat/tomcat-5.5-doc/printer/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations : : "There is one problem with connection pooling. A web : application h

Re: Connection pooling verse one connection per session

2005-03-10 Thread Mark Winslow
OK, I see your points and they are well taken. A lot of my concern has to do with this http://jakarta.apache.org/tomcat/tomcat-5.5-doc/printer/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations "There is one problem with connection pooling.

Re: Connection pooling verse one connection per session

2005-03-10 Thread QM
On Thu, Mar 10, 2005 at 10:31:41AM -0800, Mark Winslow wrote: : Hi, I have a sort of theoretical question. I'm : wondering about the pros and cons of using a "one : connection per tomcat session" strategy for connecting : to a Postgresql server rather than connection pooling. Th

Connection pooling verse one connection per session

2005-03-10 Thread Mark Winslow
Hi, I have a sort of theoretical question. I'm wondering about the pros and cons of using a "one connection per tomcat session" strategy for connecting to a Postgresql server rather than connection pooling. My users generally login in the morning and keep my app open for exte

Re: Cluster and Connection Pooling problem

2005-02-21 Thread Peter Johnson
proper order regarding the connection pooling needed by the application. The application's error log indicates that the connection pooling parms are not really being read in the server.xml. What is the conflict? Anyone else encountered this? I hesitate to supply xml in this forum if so

Cluster and Connection Pooling problem

2005-02-18 Thread Sumpter, Chuck
application, I run into a wall attempting to get things in the proper order regarding the connection pooling needed by the application. The application's error log indicates that the connection pooling parms are not really being read in the server.xml. What is the conflict? Anyone

Re: Tomcat 5 - Datasource Connection Pooling

2005-01-24 Thread Trond G. Ziarkowski
Hi! 1)My problem is my working directory is different. I use ant to create war file and then i manually stop the server - delete existing war file / existing directory (This is due to some Win TomCat problem .??..). Then i deploy it using TomCat Manager. It automatically creates META-INF file f

Tomcat 5 - Datasource Connection Pooling

2005-01-24 Thread Manisha Sathe
Finally after long struggle I could get the datasource things running. The things are working when i specified all into GlobalResources and GlobalContext inside server.xml My server.xml is something like below.. - url jdbc

RE: Connection Pooling with Tomcat 4.1 and SQL Server 2000

2005-01-06 Thread Johnson, Jay
I can connect using my current driver without connection pooling. You may be correct; the driver may not support it. I'm using Microsoft's standard type 4 driver. I'll try using Tomcat 5 also and see if it makes a difference. I'll also see if I can find another driv

Re: Connection Pooling with Tomcat 4.1 and SQL Server 2000

2005-01-06 Thread Friedrich Gonzalez
Everything you did with the driver,server.xml,web.xml is ok. But it sounds like your driver of sql server 2000 doesnt support connection pooling ... did you tried to connect without the connection pool? i also recommend going to tomcat 5... i had a couple of issues with connection pooling in

Connection Pooling with Tomcat 4.1 and SQL Server 2000

2005-01-05 Thread Johnson, Jay
I am trying to establish a connection pool in Tomcat 4.1 to SQL Server 2000. Looking at the SQL Server trace utility, it appears Tomcat connects with the correct username/password and then the following exception is thrown: java.lang.UnsupportedOperationException at org.apache.commons.dbcp.Poo

RE: tomcat problem related connection pooling help needed

2004-12-19 Thread Jan Behrens
> From: Krishnakant Mane [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 19, 2004 2:17 PM > To: [EMAIL PROTECTED] > Subject: tomcat problem related connection pooling help needed > > > hello Jan and other friends, > I read the mail that was sent as a reply for my > proble

tomcat problem related connection pooling help needed

2004-12-19 Thread Krishnakant Mane
hello Jan and other friends, I read the mail that was sent as a reply for my problem. thanks jan for ur valuable help. I must mention that I am new to the jdbc stuff. so I could not figure out the connection pooling issue. I understand that with pooling I can have live objects of say connection

Re: connection pooling

2004-12-17 Thread Didier McGillis
;Tomcat Users List" <[EMAIL PROTECTED]> Subject: Re: connection pooling Date: Thu, 16 Dec 2004 16:13:03 -0600 depends on what connection pool you use. but in almost all causes, its a pretty trivial thing (unless your code is funky of course) in our system, all we did was to switch the d

Re: connection pooling

2004-12-16 Thread Filip Hanik - Dev
- Original Message - From: "Didier McGillis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 16, 2004 3:49 PM Subject: connection pooling I'm about to the point where I'm going to switch to db connection pooling. however before I undertak

connection pooling

2004-12-16 Thread Didier McGillis
I'm about to the point where I'm going to switch to db connection pooling. however before I undertake this seemly easy task I have a question, which will make this a huge project or a simple one. The current site uses typical MySQL connection, where a connection is opened and so o

Tomcat Connection Pooling

2004-11-29 Thread Cumbers
it does work within my web application. However I want to ensure that this is actually a connection pool. I want to test to see how many connections are in the pool, is there a way? Or can someone tell me for sure if I have set connection pooling up? Thanks Rich

Re: Tomcat 4.1: Setting Up Connection Pooling, Adding Resource to server.xml,

2004-11-26 Thread David Stevenson
ht be a class not defined exception because I didn't supply the connection pooling .jar files as required by the instructions. 2004-11-26 20:15:24 org.apache.catalina.INVOKER.ClientListPooledServlet: ClientListPooledServlet.init: javax.naming.NameNotFoundException: Name java:comp is not bou

Tomcat 4.1: Setting Up Connection Pooling, Adding Resource to server.xml

2004-11-26 Thread David Stevenson
The question relates to my home study of the Tomcat Server via the book referenced below. Added Context via Tomcat Administration page. Added Resource, ResourceParams, and parameter tags by hand-editing the server.xml file, and re-starting. Reference: Ian McFarland, Peter Harrison, Mastering Tomc

Re: AW: connection pooling

2004-11-11 Thread Eric Wulff
What informix db version are you working with? I do not know how to get the serial value. I use an informix driver that supports connection pooling and I'm not familiar with the ifmxStatement. Depending on the informix version, I suggest utilizing a type 4 informix jdbc driver(search).

Re: AW: connection pooling

2004-11-09 Thread Eric Wulff
ue > > > removeAbandonedTimeout > 300 > > > > logAbandoned > true > > > > > > thanks for any hint > > Mohammed > > -Ursprünglic

Re: AW: connection pooling

2004-11-09 Thread Nishant Deshpande
> > > url > > > jdbc:informix-sqli://s0062033.vt.bb.de:300056/coadb:informixserver=coadbzentral > > > > > removeAbandoned > true > > > removeAbandonedTimeout > 300 > >

AW: connection pooling

2004-11-09 Thread Akacem Mohammed
Kirk [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 9. November 2004 01:40 An: 'Eric Wulff'; 'Tomcat Users List' Betreff: RE: connection pooling Worth clarifyig what we are meaning by "DBCP". The DBCP I was referring to was the specific implementation of connecti

Re: connection pooling

2004-11-08 Thread Eric Wulff
Well, my informix driver does support connection pooling as-is so I do not need to use a Jakarta Commons DBCP wrapper in order to take advantage of database connection pooling. Thx for clarifying and for sharing your ResourceParams. I need to study this issue some more in general since I only

RE: connection pooling

2004-11-08 Thread Steve Kirk
Worth clarifyig what we are meaning by "DBCP". The DBCP I was referring to was the specific implementation of connection pooling that is part of Jakarta Commons: http://jakarta.apache.org/commons/dbcp/ There are other pooling implementations which are alternatives to Commons DBCP

Connection pooling under Tomcat 5.0.28 Probleme

2004-11-08 Thread Akacem Mohammed
Hello every body, I have read in die archive the e-mail exchange about configuring Datasource in Tomcat for connection pooling. ( I also read the Tomcat doc ) the jar file commons-collection- 3.1.jar, commons-dbcp-1.2.1.jar, commons-pool-1.2.jar und the database driver ifjdbc.jar are in the

Re: connection pooling

2004-11-06 Thread V D
wrote: No, you don't need that many params. I think your problem might be the driver. Where did you drop off your informix jdbc jar? -Original Message- From: Eric Wulff [mailto:[EMAIL PROTECTED] Sent: October 7, 2004 5:56 PM To: Tomcat Users List Subject: Re: con

Re: {an alternative}Re: connection pooling

2004-11-06 Thread Atishay Kumar
9 +0530, Atishay Kumar > > > > <[EMAIL PROTECTED]> wrote: > > > > > hi, > > > > > i am not sure but you may try downloading latest jar files for > > > > > following froom tomcat site and try them out. copy the old jar files > > > > &g

Re: AW: {an alternative}Re: connection pooling

2004-11-06 Thread Ben Souther
> What escapes me is, why is this not more obviously documented? > Perhaps it's in the Tomcat docs but I mostly abandoned those some time > ago as they are so amazingly detailed and lengthy that unless you want > to become a TC guru, which I am inspired to try and be more like, > there is simply t

Re: AW: {an alternative}Re: connection pooling

2004-11-05 Thread Eric Wulff
>Von: Eric Wulff [mailto:[EMAIL PROTECTED] > >Gesendet: Freitag, 5. November 2004 07:35 > >An: Atishay Kumar > >Cc: Tomcat Users List > >Betreff: Re: {an alternative}Re: connection pooling > > > > > >Atishay, the DefaultContext does work once I comment out the

Re: connection pooling

2004-11-05 Thread Eric Wulff
but do not list the factory class > under your Resource, e.g. : > > factory > org.apache.commons.dbcp.BasicDataSourceFactory > > > I have not seen any Java source code on this thread, maybe you posted it > before I started reading it. > > Thinking slightly laterally I'll pass on something I learned

Re: AW: {an alternative}Re: connection pooling

2004-11-05 Thread sven morales
t define a context with > path="/wms". > > Cheers, > nick. > > >-Ursprungliche Nachricht- > >Von: Eric Wulff [mailto:[EMAIL PROTECTED] > >Gesendet: Freitag, 5. November 2004 07:35 > >An: Atishay Kumar > >Cc: Tomcat Users List > >Betref

RE: {an alternative}Re: connection pooling

2004-11-05 Thread Steve Kirk
ce v5.x (rather than putting it in server.xml). manager.xml is for the manager webapp. > -Original Message- > From: Nick Pellow [mailto:[EMAIL PROTECTED] > Sent: Friday 05 November 2004 07:40 > To: Tomcat Users List > Subject: AW: {an alternative}Re: connection pooling > > &g

RE: connection pooling

2004-11-05 Thread Steve Kirk
iday 05 November 2004 13:32 > To: Tomcat Users List > Subject: RE: connection pooling > > > > Hi, > > >Eric - you are correct, you do not need both and > > > That's only because we try to accommodate less able > developers/administrators. You

RE: connection pooling

2004-11-05 Thread Shapira, Yoav
Hi, >Eric - you are correct, you do not need both and That's only because we try to accommodate less able developers/administrators. You DO need if you want your app to be compliant with the Servlet Specification and portable to other containers. Yoav Shapira http://www.yoavshapira.com

RE: connection pooling

2004-11-05 Thread Steve Kirk
n any Java source code on this thread, maybe you posted it before I started reading it. Thinking slightly laterally I'll pass on something I learned from Yoav recently on this list you don't need to use container-managed resources to do connection pooling. In other words you don't ne

AW: {an alternative}Re: connection pooling

2004-11-04 Thread Nick Pellow
alhost and make sure that they do not define a context with path="/wms". Cheers, nick. >-Ursprungliche Nachricht- >Von: Eric Wulff [mailto:[EMAIL PROTECTED] >Gesendet: Freitag, 5. November 2004 07:35 >An: Atishay Kumar >Cc: Tomcat Users List >Betreff: Re:

Re: {an alternative}Re: connection pooling

2004-11-04 Thread Eric Wulff
he latest jar files. > > > > 1) Commons Collections > > > > 2)Commons DBCP > > > > 3)Commons Pool > > > > > > > > > > > > > > > > > > > > On Thu, 7 Oct 2004 15:29:40 -0700, Eric Wulff <[EMAIL PROTECT

Re: {an alternative}Re: connection pooling

2004-11-04 Thread Eric Wulff
n Thu, 7 Oct 2004 15:29:40 -0700, Eric Wulff <[EMAIL PROTECTED]> wrote: > > > > Except that the driver works for connecting if I'm not utilizing a > > > > connection pool, i.e., I am able to connect to the db and manipulate > > > > data via DriverManager.getConne

Re: connection pooling

2004-11-04 Thread Eric Wulff
> > > > > > > > > > > > > On Thu, 7 Oct 2004 15:29:40 -0700, Eric Wulff <[EMAIL PROTECTED]> wrote: > > > > Except that the driver works for connecting if I'm not utilizing a > > > > connection pool, i.e., I am able to connect to

{an alternative}Re: connection pooling

2004-11-04 Thread Atishay Kumar
; > > > > > The driver is located in CATALINA_HOME/commons/lib > > > > > > Eric > > > > > > On Thu, 7 Oct 2004 18:22:45 -0400, Phillip Qin > > > <[EMAIL PROTECTED]> wrote: > > > > No, you don't need that many params. I

Re: connection pooling

2004-11-04 Thread Atishay Kumar
> > > > > Eric > > > > > > On Thu, 7 Oct 2004 18:22:45 -0400, Phillip Qin > > > <[EMAIL PROTECTED]> wrote: > > > > No, you don't need that many params. I think your problem might be the > > > > > > > > > > dr

Re: connection pooling

2004-11-04 Thread Eric Wulff
gt; > > > You need to provide details otherwise we can't help. > > > > > > > > This was all included in my original post. Ok, actually my 2nd post > > > > because I accidentally hit send prior to completing my post via th

RE: Database connection pooling

2004-10-27 Thread Steve Kirk
small correction: putting inside server.xml is not recommended since v5.0, not 5.5 > -Original Message- > From: Steve Kirk [mailto:[EMAIL PROTECTED] > Sent: Wednesday 27 October 2004 13:14 > To: 'Tomcat Users List' > Subject: RE: Database connection pooling

RE: Database connection pooling

2004-10-27 Thread Steve Kirk
o the howto. Having said that, as of v5.5, placing s inside server.xml is not recommended. > -Original Message- > From: Nat Titman [mailto:[EMAIL PROTECTED] > Sent: Wednesday 27 October 2004 12:22 > To: [EMAIL PROTECTED] > Subject: Database connection pooling > > > H

RE: Database connection pooling

2004-10-27 Thread Allistair Crossley
IL PROTECTED] > Subject: Database connection pooling > > > Hi, > > I'm attempting to integrate database connection pooling into an > exisiting JSP-based web application. > > I'm running Tomcat 5.5.2 Server, with J2SE 1.5.0 and a MySQL database > (versio

  1   2   3   4   5   6   7   >