Re: connection pooling

2002-08-27 Thread Glenn Nielsen
The advantage of letting the container (Tomcat) setup a JNDI DataSource is abstraction. It abstracts out the source of data from the web application. You no longer have to configure somewhere within your web application the db connection, user, password, etc. This allows you to have a developmen

Re: connection pooling

2002-08-27 Thread Ashish Kulkarni
Hi, A Question about JNDI, to use it i have to configure it in server.xml file, suppose if i have to change my app server , say to JRun, or Weblogic or websphere...how will it affect me,i think since all these are J2EE compliant servers, they must have some place for defining it, also what if i ke

Re: connection pooling

2002-08-27 Thread Glenn Nielsen
Yes, any J2EE compliant app server will have the ability to create a JNDI DataSource. The choice of whether to use a container provided DataSource or your own connection pool within the webapp is up to you. I prefer a container managed JNDI DataSource. Regards, Glenn Ashish Kulkarni wrote: >

Re: Connection Pooling

2002-10-21 Thread Mehdi . Nejad
Comment on my question.. Ive been having a read, It seems if you do not specify a factory, tomcats "default factory is used" - org.apache.naming.factory.DbcpDataSourceFactory If correct, is it a good idea to go with this ? Med

RE: Connection Pooling

2002-07-02 Thread Turner, John
Using a JNDI Resource, tomcat has connection pooling built-in. Since tomcat is the reference spec for Java application servers, my guess is that the pooling in Websphere is simply the same. Here is the how-to for JNDI: http://jakarta.apache.org/tomcat/tomcat-4.0-doc/jndi-resources-howto.html J

Re: Connection Pooling

2002-07-02 Thread Jacob Kjome
Hello Kevin, See this: http://marc.theaimsgroup.com/?l=tomcat-user&m=102348915728231&w=2 and this: http://marc.theaimsgroup.com/?l=tomcat-user&m=102383138524775&w=2 also this: http://marc.theaimsgroup.com/?l=tomcat-user&m=101631189730747&w=2 They might be what you are looking for. Jake

RE: Connection Pooling

2002-07-02 Thread William Gustave
There is plug-in in the nightly builds http://jakarta.apache.org/builds/jakarta-commons/nightly/ Check out the following commons-dbcp/ commons-pool/ This link is a howto someone using this email group put up. http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2 Re

Re: Connection Pooling?

2002-07-04 Thread
Hey! You could try to use this connection pool. I've used it and its a decent good working pool. www.javaexchange.com/api/com/javaexchange/dbConnectionBroker/ DbConnectionBroker.html But the site seems to be down at the moment. Elm > Hi, > I want to implement my application with Connection P

RE: Connection Pooling?

2002-07-04 Thread Les Hughes
I think I should set up a cron job to email this link out every day http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2 > -Original Message- > From: Meichun Li [mailto:[EMAIL PROTECTED]] > Sent: 04 July 2002 13:09 > To: Tomcat Users List > Subject: Connection Pooling?

RE: Connection Pooling?

2002-07-04 Thread Meichun Li
Thanks for the help! I followed the steps in the howto page http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2 I compiled my java test file and there is no error message. But when I run it, I run it, I got the error message as below.Could anyone please give me some hints? Tha

RE: Connection Pooling?

2002-07-08 Thread Jacob Kjome
Try this with Either Tomcat-4.1.3 which I've tested with the instructions at the link below and know it to work. Also, you might try Tomcat-4.1.7 whch just came out. I had tried Tomcat-4.1.6 and it failed so, presumably, the nightly builds around the time of 4.1.6 development were broken as f

RE: Connection Pooling?

2002-07-08 Thread Andrew Conrad
ightly build of commons-dbcp.jar 2002-07-02 or later (there were some recent fixes). - Andrew -Original Message- From: Meichun Li [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 1:40 PM To: Tomcat Users List Subject: RE: Connection Pooling? Thanks for the help! I fo

RE: Connection Pooling?

2002-07-08 Thread Clay Graham
-Original Message- From: Jacob Kjome [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 1:03 AM To: Tomcat Users List Subject:RE: Connection Pooling? Try this with Either Tomcat-4.1.3 which I've tested with the instructions at the link below and know it to work.

RE: Connection Pooling?

2002-07-09 Thread Meichun Li
Thanks for everyone's help and thanks for the guide to this URL. I followed the steps posted and my connection pool is working now ;-) Thanks! Meichun On Thu, 4 Jul 2002, Les Hughes wrote: > I think I should set up a cron job to email this link out every day > > http://marc.theaimsgroup.c

Re: Connection Pooling

2001-04-11 Thread Anand Raman
i guess all u will have to do is servlet.getAttribute("attr-name"); cast this down to ur ConnectionPool object and call the appropriate method to get the connection.. hope this helps Anand On Wed, Apr 11, 2001 at 01:07:20PM +0100, Lakshmeenarayana G G wrote: >Hi... >I am creating the object of

Re: Connection Pooling

2001-04-11 Thread Mark Diggory
Shouldn't you be able to access the bean by setting the tags scope attribute to application? This is pretty basic tutorial stuff on the Sun site. At 01:07 PM 4/11/01 +0100, you wrote: >Hi... >I am creating the object of Connection pool manager in my Start up JSP. >The pool manager object is

Re: Connection Pooling

2001-04-17 Thread Jeff Kilbride
Go to http://www.javaexchange.com/ and download the DbConnectionBroker class. It includes examples in the documentation. --jeff - Original Message - From: "Balaji Muniraja" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 17, 2001 6:26 PM Subject: C

RE: Connection Pooling

2001-04-17 Thread Vinoj Vijayan
Doesn't JDBC 2.0 provide inherent connection pooling mechanism? Has anyone tried it out ? If yes, how effective is the same? TIA Vinoj -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 11:05 AM To: [EMAIL PROTECTED] Subject: Re: Conne

Re: Connection Pooling

2001-04-18 Thread Jeff Kilbride
le to use. http://java.sun.com/products/jdbc/articles/package2.html Thanks, --jeff - Original Message - From: "Vinoj Vijayan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 17, 2001 11:18 PM Subject: RE: Connection Pooling > Doesn't J

RE: Connection Pooling

2001-04-18 Thread Vinoj Vijayan
Hi Does JDBC 2.0 work well with Tomcat? Rgds Vinoj -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 12:51 PM To: [EMAIL PROTECTED] Subject: Re: Connection Pooling Connection pooling can be done with the JDBC 2.0 Optional Package

Re: Connection Pooling

2001-04-18 Thread eric chacon
I'm not aware of any connection pooling software that's native, or comes bundled with Tomcat. I've downloaded PoolMan (http://www.codestudio.com/), but I had some luck with v. 1.4.1 -- version 2.0beta (their latest) does not work (for me) at all. There are some other packages also (dbconnec

Re: Connection Pooling

2001-05-10 Thread Bip Thelin
On Thu, 10 May 2001, Mike Ash wrote: > Does Tomcat create a connection pool for databases or do I have to use > poolman or something like that? Tomcat are not supporting DB Connection pooling, but you can use pretty much anyone. There's one hosted under the Jakarta umbrella. Check under jakarta

Re: Connection Pooling

2001-03-06 Thread Ryan
go here: http://www.webdevelopersjournal.com/columns/connection_pool.html and also look up threads and singleton patterns at www.javasoft.com -ryan - Original Message - From: "Carlos López M." <[EMAIL PROTECTED]> To: "Tomcat-User" <[EMAIL PROTECTED]> Sent: Tuesday, March 06, 2001 12:35

RE: Connection Pooling

2001-03-06 Thread Carlos López M.
Thanks a lot I would go there and se what I could find -Mensaje original- De: Ryan [mailto:[EMAIL PROTECTED]] Enviado el: Martes, 06 de Marzo de 2001 02:55 p.m. Para: [EMAIL PROTECTED] Asunto: Re: Connection Pooling go here: http://www.webdevelopersjournal.com/columns

Re: Connection Pooling

2001-03-07 Thread Sebastian Schulz
hi, take a look at PoolMan, its a nice generic implementation for datasources, special for jdbc-derived ones like Connections. the url is: http://poolman.sourceforge.net/ by the way: this implementaion was mentioned in the very helpful book: 'Profession JSP' from wrox bAs T. "Carlos López M."

RE: Connection Pooling

2001-03-08 Thread Byrom Robert-LRB005
- From: Carlos López M. [mailto:[EMAIL PROTECTED]] Sent: 06 March 2001 20:53 To: [EMAIL PROTECTED] Subject: RE: Connection Pooling Thanks a lot I would go there and se what I could find -Mensaje original- De: Ryan [mailto:[EMAIL PROTECTED]] Enviado el: Martes, 06 de Marzo de 2001 02:55 p.m

RE: Connection Pooling

2001-03-08 Thread Brett Knights
http://www.bitmechanic.com/projects/jdbcpool/ I have been using this for a couple of years. It has worked well so far. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]

RE: Connection pooling

2003-01-21 Thread Venkat
Sorry, for spelling mistake. Connection pool Thaks in advance venkat -Original Message- From: Venkat [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 2:57 PM To: Tomcat Subject: Connection pooling Hi, How to set up a connection poll and use the connection pool from jsp in tom

Re: Connection pooling

2003-01-21 Thread Peng Tuck Kwok
Venkat wrote: Hi, How to set up a connection poll and use the connection pool from jsp in tomcat4.0? Any url or doc will help's me. Look up the tomcat docs , go to the section that says jndi datasources. There is a copy of the docs that come with each distribution of tomcat. That should set

Re: Connection Pooling

2003-02-20 Thread Jeffrey Pajor
I actually just wrote on article on that in my newsletter. Using the JNDI method get's you connection pooling. I've attached it. Sebastiªo Carlos Santos said: > Somebody has some experience or example in the > configuration and use of pool of connections with the > commons-dbcp. > I am a little

Re: Connection Pooling

2003-02-20 Thread pcampaigne
Jeffery, Your attachment didn't come through. Phil - Original Message - From: "Jeffrey Pajor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 12:45 PM Subject: Re: Connection Pooling > I actually just wrote on article on tha

RE: Connection Pooling

2003-02-21 Thread pqin
There are two options. 1. Tomcat JNDI: refer to Tomcat's JNDI datasource how-to 2. commons-dbcp + commons-pooling: refer to commons-dbcp and pooling API documentation Which one do you want to know? Regards, PQ "This Guy Thinks He Knows Everything" "This Guy Thinks He Knows What He Is Doin

RE: Connection Pooling

2003-02-23 Thread "Sebastião Carlos Santos"
Indeed which is the difference of using 1. Tomcat JNDI: or 2. commons-dbcp + commons-pooling: ? Thank you There are two options. 1. Tomcat JNDI: refer to Tomcat's JNDI datasource how-to 2. commons-dbcp + commons-pooling: refer t

Re: Connection pooling

2003-02-24 Thread Arcadius A.
"Arcadius A." <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello! > I'm using Tomcat 4, mod_jk1.2 and Apache 1.3.27 on Redhat > > I'm in need of connection pooling example to get me started > I've had a look at http://jakarta.apache.org/commons/dbcp/api/index.html > and th

RE: Connection Pooling

2003-02-25 Thread Malcolm Green
I have DBCP connection pooling working as follows using Tomcat 4.1.12: Under the element for your application (this can either be in the server.xml file or a separate xml file in the webapps dir) I have the following config:

RE: Connection Pooling

2003-02-25 Thread pqin
quot; "This Guy Thinks He Knows What He Is Doing" -Original Message- From: Malcolm Green [mailto:[EMAIL PROTECTED] Sent: February 25, 2003 5:36 AM To: 'Tomcat Users List' Subject: RE: Connection Pooling I have DBCP connection pooling working as follows using Tomcat 4

RE: Connection Pooling

2003-02-25 Thread Warden, Matt
On Feb 25, Malcolm Green had something to say about RE: Connection Pooling >I have DBCP connection pooling working as follows using Tomcat 4.1.12: > >Under the element for your application (this can either be in the >server.xml file or a separate xml file in the webapps dir)

RE: connection pooling

2003-06-06 Thread Nadia Kunkov
3:15 PM To: Tomcat Users List Subject: RE: connection pooling Howdy, >Thanks, but do you know what is abandoned connection? As I understand it, >abandoned connection is the one that has not been used in some time but it >still could be a live connection. I need to go through all the c

RE: connection pooling

2003-06-05 Thread Shapira, Yoav
Howdy, Tomcat uses DBCP by default for connection pooling, although you can use other packages as well. DBCP supports evicting idle connections with a configurable timeout on how long the connection must be idle before eviction. DBCP also supports configurable validation queries (checking for st

RE: connection pooling

2003-06-05 Thread Nadia Kunkov
Subject: RE: connection pooling Howdy, Tomcat uses DBCP by default for connection pooling, although you can use other packages as well. DBCP supports evicting idle connections with a configurable timeout on how long the connection must be idle before eviction. DBCP also supports configurable

RE: connection pooling

2003-06-05 Thread Shapira, Yoav
Howdy, >Thanks, but do you know what is abandoned connection? As I understand it, >abandoned connection is the one that has not been used in some time but it >still could be a live connection. I need to go through all the connections >in the pool and check if every connection is a valid, live c

RE: Connection Pooling

2003-08-02 Thread Gregg Bolinger
Ok, got that resolved. I just had the element order in my web.xml file wrong. Of course now I am getting this error: cannot create resource instance So I am off to research that. Gregg -Original Message- From: Gregg Bolinger [mailto:[EMAIL PROTECTED] Sent: Saturday, August 02, 2003 1

Re: Connection Pooling

2003-09-16 Thread Filip Hanik
look at the docs - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 16, 2003 9:06 PM Subject: Connection Pooling Hi All, Can anybody send me the configuration for DBCP Connection pooling with TOmcat 4.0 Regards, Santosh Bhushan i-flex soluti

Re: connection pooling

2004-04-15 Thread Antonio Fiol Bonnín
I can't remember the specifics off hand, but... There is a mechanism in DBCP that allows you to check a connection with a "validationQuery" (use this term when googling for it!) that can be run a) every now and then on an idle connection (very useful if a firewall sits in the middle) b) before

Re: Connection pooling

2004-04-22 Thread Parsons Technical Services
Is this a direct cut and paste? If yes you are missing a > at the end of the Logger. Otherwise watch the order of the elements in the Resource. It can make a difference in some cases. What are the errors? What does the web.xml look like? Doug www.parsonstechnical.com - Original Message ---

RE: Connection Pooling

2004-01-07 Thread D'Alessandro, Arthur
I believe when you close the connection, which should be added in a finally block eg. } finally { try { oConn.close(); } catch (Exception ex) { // Can't recovery gracefully,

Re: Connection Pooling

2004-01-07 Thread James Neville
Justin, That would all depend on the pooling implementation you're using. Commonly, its pool.free(conn) or pool.freeConnection(conn). Remember *not* to close the connection if you're using connection pooling, as this should be handled by the pool itself. That said one of my colleagues mentio

RE: Connection Pooling

2004-01-07 Thread Edson Alves Pereira
Usually every databse has its own ConnectionPool implementation. > -- > De: James Neville[SMTP:[EMAIL PROTECTED] > Responder:Tomcat Users List > Enviada: quarta-feira, 7 de janeiro de 2004 13:50 > Para: Tomcat Users List > Assunto: Re:

RE: Connection Pooling

2004-01-08 Thread Hume, John - NA US HQ Delray
al Message- From: James Neville [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:51 AM To: Tomcat Users List Subject: Re: Connection Pooling Justin, That would all depend on the pooling implementation you're using. Commonly, its pool.free(conn) or pool.freeConnection(conn). Remember

Re: connection pooling

2000-12-04 Thread Craig R. McClanahan
Mukul Sood wrote: > Hello All, > > I would like to know whether Tomcat supports database connection pooling. > If not then do developers have to implement their own connection pool. > Also can one use jdbc 2.0 data source with Tomcat. > Would appreciate any info on these questions. > > Thanks in

RE: connection pooling

2000-12-05 Thread Stevenson, John
: 05 December 2000 01:36 To: [EMAIL PROTECTED] Subject: Re: connection pooling Mukul Sood wrote: > Hello All, > > I would like to know whether Tomcat supports database connection pooling. > If not then do developers have to implement their own connection pool. > Also can one us

Re: connection pooling

2004-10-06 Thread jthompson
java code: Context ctx = (Context) init.lookup("xx"); server.xml: web.xml: xx javax.sql.DataSource Container The entries I've labelled 'xx' should all be the same. John Thompson |-+> | | Eric Wulff | |

Re: connection pooling

2004-10-06 Thread jthompson
Please ignore my last post - it's wrong. (Answered before verifying). John Thompson |-+> | | Eric Wulff | | | <[EMAIL PROTECTED]| | | >| | || |

Re: connection pooling

2004-10-06 Thread jthompson
parameter> url jdbc:informix-sqli://url:port/dbName:INFORMIXSERVER=serverName Is that litterally what you have in your server.xml? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: connection pooling

2004-10-06 Thread Eric Wulff
No, literally I have the actual values. The same connection string I use to successfully connect via JDBC using DriverMangager.getConnection() minus the user and passoword. Eric On Thu, 7 Oct 2004 11:04:22 +1300, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > parameter> > url > >

Re: connection pooling

2004-10-06 Thread jthompson
Is there a x.xml file in (TOMCAT_HOME)/conf/Catalina/localhost, where xx is the context name? (this is an independent context configuration that may have been created independently when you first deployed your application on Tomcat). If so, either delete it, or move your data source d

Re: connection pooling

2004-10-06 Thread Eric Wulff
Context name? I assume your referring to the ResourceParams name attribute, jdbc/test_connect in this case, from the Context declaration in my server.xml. So, I'd be looking for a test_connect.xml. There are NO .xml files in the TOMCAT_HOME/conf/Catalina/localhost with this name or any name whic

RE: connection pooling

2004-10-07 Thread Phillip Qin
Detail, detail, detail. 1. your context.xml 2. your web.xml 3. how do you obtain connection from pool, java code pls. 4. can you connect using pool 5. commons-pool version Etc. etc. You need to provide details otherwise we can't help. -Original Message- From: Eric Wulff [mailto:[EMAIL P

Re: connection pooling

2004-10-07 Thread Atishay Kumar
On Wed, 6 Oct 2004 14:37:58 -0700, Eric Wulff <[EMAIL PROTECTED]> wrote: > I have gone over some of the tomcat docs and googled errors > but there is SO much information covering JNDI, connection pooling, > and Datasources. Can someone review the info below and consult or > point me in the right d

Re: connection pooling

2004-10-07 Thread Eric Wulff
Hi Phillip, On Thu, 7 Oct 2004 09:29:09 -0400, you wrote: > Detail, detail, detail. > > 1. your context.xml > 2. your web.xml > 3. how do you obtain connection from pool, java code pls. > 4. can you connect using pool > 5. commons-pool version > > Etc. etc. > > You need to provide details other

Re: connection pooling

2004-10-07 Thread Eric Wulff
Hi Atishay, added your suggestion to the server.xml. While it is not the fix, I do have a different error listing. Is this a clue to you? Eric current last listing of stack trace... Caused by: java.lang.NullPointerException at com.informix.jdbc.IfxDriver.checkURL(IfxDriver.java:473) at com.info

RE: connection pooling

2004-10-07 Thread Phillip Qin
;jdbc/test_connect"); ... -Original Message- From: Eric Wulff [mailto:[EMAIL PROTECTED] Sent: October 7, 2004 4:34 PM To: Tomcat Users List Subject: Re: connection pooling Hi Phillip, On Thu, 7 Oct 2004 09:29:09 -0400, you wrote: > Detail, detail, detail. > &g

Re: connection pooling

2004-10-07 Thread Eric Wulff
t; > testWhileIdle > true > > > > > 3. code > > Context initContext = new InitialContext(); > Context jdbcContext = (Context) > initContext.lookup("java:comp/env"

RE: connection pooling

2004-10-07 Thread Phillip Qin
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: connection pooling Yes, I

Re: connection pooling

2004-10-07 Thread Eric Wulff
PM > To: Tomcat Users List > Subject: Re: connection pooling > > Yes, I have added . Now different errors are reported > via stack trace as I posted in response to Atishay's suggestion that I add > this. I'll try adding your suggestions and see what happens. Also, you

Re: connection pooling

2004-10-07 Thread Atishay Kumar
> -Original Message- > > From: Eric Wulff [mailto:[EMAIL PROTECTED] > > Sent: October 7, 2004 5:56 PM > > To: Tomcat Users List > > Subject: Re: connection pooling > > > > Yes, I have added . Now different errors are reported > > via stack trace as I

Re: connection pooling

2004-11-04 Thread Eric Wulff
mmons/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 think your problem might be the > > > > > > > driver. Where did you drop o

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
> > > > > > > > > > > > > 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

RE: connection pooling

2004-11-05 Thread Steve Kirk
ed to set any Resource or Context to get it to work. > -Original Message- > From: Eric Wulff [mailto:[EMAIL PROTECTED] > Sent: Friday 05 November 2004 05:57 > To: Tomcat Users List; Atishay Kumar > Subject: Re: connection pooling > > > Thx for your input but, as me

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
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 Eric Wulff
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 need to set any Resource > or Context to get it to work. > > > > > -Original Message- > > From: Eric Wulff

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: connection pooling

2004-11-08 Thread Steve Kirk
url jdbc:mysql://localhost:3306/myDb > -Original Message- > From: Eric Wulff [mailto:[EMAIL PROTECTED] > Sent: Friday 05 November 2004 18:34 > To: Steve Kirk > Cc: Tomcat Users List > Subje

Re: connection pooling

2004-11-08 Thread Eric Wulff
> password > secret > > > url > jdbc:mysql://localhost:3306/myDb > > > > > > > > -Original Message--

Re: connection pooling

2004-12-16 Thread Filip Hanik - Dev
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 driver name (to the pooled driver), and it would pick up our connection pool. so it was a one line change. Filip -

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 Solution

2002-05-26 Thread Les Hughes
. Thanks Les > -Original Message- > From: Rick Fincher [mailto:[EMAIL PROTECTED]] > Sent: 24 May 2002 18:37 > To: [EMAIL PROTECTED] > Subject: Re: Connection Pooling Solution > > > Thanks a million Les, > > This is very helpful. > > Quick question: I

RE: Connection Pooling Solution

2002-05-26 Thread Jacob Kjome
t way (a) >someone else might answer first and (b) the answer will end up in the mail >archives. > >Thanks > >Les > > > > -Original Message- > > From: Rick Fincher [mailto:[EMAIL PROTECTED]] > > Sent: 24 May 2002 18:37 > > To: [EMAIL PROT

RE: Connection Pooling Solution

2002-05-26 Thread Cindy Ballreich
t; > > >Thanks > > > >Les > > > > > > > -Original Message- > > > From: Rick Fincher [mailto:[EMAIL PROTECTED]] > > > Sent: 24 May 2002 18:37 > > > To: [EMAIL PROTECTED] > > > Subject: Re: Connection

Re: Connection Pooling Solution

2002-05-26 Thread Vic Cekvenich
apache.org/builds/jakarta-commons/nightly/commons-dbcp/ >>> >>>And could you keep your mails to the list instead of direct? That way (a) >>>someone else might answer first and (b) the answer will end up in the mail >>>archives. >>> >>>Thank

Re: Connection Pooling Solution

2002-05-30 Thread Rick Fincher
Because the MySql driver is a javax.sql.DataSource and that's what gets passed back by the pool, making the pool transparent (no pun intended). That way you can later change the driver or the pooling details without changing your code (assuming the SQL dialect still works). Rick - Original

Re: Connection Pooling Solution

2002-05-30 Thread Cindy Ballreich
At 03:43 PM 5/30/02 -0400, Rick Fincher wrote: >Because the MySql driver is a javax.sql.DataSource and that's what gets >passed back by the pool, making the pool transparent (no pun intended). > >That way you can later change the driver or the pooling details without >changing your code (assuming

Re: Connection Pooling Solution

2002-05-30 Thread Phillip Morelock
javax.sql.DataSource itself is not returning Connections. DataSource is an interface -- what this means in practice is that some random class (in this case, BasicDataSource) is implementing that interface. You're actually asking that class for a Connection, and you "know" that you can call any me

Re: Connection Pooling Solution

2002-05-30 Thread Cindy Ballreich
fillup, At 01:28 PM 5/30/02 -0700, Phillip Morelock wrote: >javax.sql.DataSource itself is not returning Connections. > >DataSource is an interface -- what this means in practice is that some >random class (in this case, BasicDataSource) is implementing that interface. >You're actually asking tha

Re: Connection Pooling Solution

2002-05-30 Thread Phillip Morelock
On 5/30/02 2:05 PM, "Cindy Ballreich" <[EMAIL PROTECTED]> wrote: > Yes, much more so. Thanks! I was misunderstanding the whole relationship. I Cool! Yeah, if you look at the packages: javax.servlet.http and javax.sql and java.sql I think you'll start to see how powerful the concept of interface

RE: Connection pooling Question

2001-08-22 Thread Filip Hanik
and where does Tomcat fit into this? sounds like a design issue, try making a search in google.com for java connection pools. that should take care of you Filip ~ Namaste - I bow to the divine in you ~ Filip Hanik Software Architect [EMAIL PROTECTED] www.filip.net >-Original Message- >F

Re: Connection pooling Question

2001-08-22 Thread Bo Xu
"A.L." wrote: > I have created a servlet class (using > DBConenctionbroker from javaexchange) which upon > initialization creates a number of database > conenctions. The init method is the only method > defined. > > My plan now is to create a number of servlets which > extend this class by defi

Re: Connection pooling - simplified?

2001-02-05 Thread John Golubenko
Well, creating a JavaBean, with DatabaseManager class, and load DatabaseManager and that JavaBean class on startup. (web.xml file), you can put all connectivity to DatabaseManager class, make up a doInsert(), doUpdate(), getValue() methods in it, with empty query. Once those puppies are loaded,

RE: Connection pooling - simplified?

2001-02-05 Thread Garmaev, Vladimir A
A good simple freebie DB ConnectionManager: http://www.webdevelopersjournal.com/columns/connection_pool.html BTW, the author is one of the Tomcat developers. -Original Message- From: John Coonrod [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 4:04 PM To: [EMAIL PROTECTED] Sub

RE: Connection Pooling Help

2002-12-09 Thread Roberts, Eric
Kevin, Try: Context ctx = new InitialContext(); Context envCtx = (Context) ctx.lookup("java:/comp/env/"); DataSource ds = (DataSource) envCtx.lookup("/jdbc/shiltonDB"); -Original Message- From: Kevin Passey [mailto:[EMAIL PROTECTED]] Sent: Montag, 09. Dezember 2002

RE: Connection Pooling Help

2002-12-09 Thread Kevin Passey
Eric, It's the same - DS == null. :-( Thanks anyway. Kevin -Original Message- From: Roberts, Eric [mailto:[EMAIL PROTECTED]] Sent: 09 December 2002 13:33 To: Tomcat Users List Subject: RE: Connection Pooling Help Kevin, Try: Context ctx = new InitialContext(); Co

RE: Connection Pooling Help

2002-12-09 Thread Hari Venkatesan
omcat Users List' Subject: RE: Connection Pooling Help Eric, It's the same - DS == null. :-( Thanks anyway. Kevin -Original Message- From: Roberts, Eric [mailto:[EMAIL PROTECTED]] Sent: 09 December 2002 13:33 To: Tomcat Users List Subject: RE: Connection Pooling Hel

RE: Connection Pooling Help

2002-12-09 Thread Manavendra Gupta
8:40 AM To: 'Tomcat Users List' Subject: RE: Connection Pooling Help Eric, It's the same - DS == null. :-( Thanks anyway. Kevin -Original Message- From: Roberts, Eric [mailto:[EMAIL PROTECTED]] Sent: 09 December 2002 13:33 To: Tomcat Users List Subject: RE: Connecti

RE: Connection Pooling Help

2002-12-09 Thread Bodycombe, Andrew
I too am surprised by the number of people facing this problem. Andy. -Original Message- From: Manavendra Gupta To: Tomcat Users List Sent: 09/12/2002 14:14 Subject: RE: Connection Pooling Help I am surprised with the number of ppl facing this problem, including myself. And it makes me w

RE: Connection Pooling Help

2002-12-09 Thread Roberto Bouza
someone who had faced and subsequently resolved this problem. > > Manav. > > -Original Message- > From: Hari Venkatesan [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 7:27 PM > To: Tomcat Users List > Subject: RE: Connection Pooling Help &

RE: Connection Pooling Help

2002-12-09 Thread Manavendra Gupta
Thanks for the reply. How do i make it a global resource? Just declare the resource in the "global" section? -Original Message- From: Bodycombe, Andrew [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 8:09 PM To: '[EMAIL PROTECTED]' Subject: RE: Connection

RE: Connection Pooling Help

2002-12-09 Thread Manavendra Gupta
onday, December 09, 2002 8:19 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: RE: Connection Pooling Help The main problem if you are using apache or not, is the "connector". I don't know if you are using apache but if you are using apache with tomcat DON'T USE the

RE: connection pooling saga

2003-03-31 Thread Filip Hanik
who needs foreign keys, they only slow your DB down anyway :) DBCP can support any DB, you will need an ODBC bridge for Access, then you just give DBCP the odbc bridge driver info, and it should work Filip > -Original Message- > From: JS [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31

  1   2   3   >