Re: OracleConnectionPoolDataSource

2007-07-23 Thread Julio J. Suárez Salinero
Zdeněk Vráblík escribió: Hi, 4. I use OracleConnectionPoolDataSource because with javax.sql.DataSource it doesn't close correctly close connections from pool and server got to hang up. Have you got any exception? It throwed Closed Statement, Exhausted Resultset and NullPointerException,

RE: OracleConnectionPoolDataSource

2007-07-23 Thread Propes, Barry L
Zdenek, I had gotten those errors, but like I said, it entailed me going back and properly closing each opened statement and connection. -Original Message- From: Julio J. Suárez Salinero [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 9:08 AM To: Tomcat Users List Subject: Re

Re: OracleConnectionPoolDataSource

2007-07-23 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Julio, Julio J. Suárez Salinero wrote: Zdeněk Vráblík escribió: Hi, 4. I use OracleConnectionPoolDataSource because with javax.sql.DataSource it doesn't close correctly close connections from pool and server got to hang up. Have you got any

RE: OracleConnectionPoolDataSource

2007-07-23 Thread Propes, Barry L
narrow it down for you. If you'd like to just send me a few files individually, go right ahead. I'll try to take a look at it and be of help. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 10:27 AM To: Tomcat Users List Subject: Re

Re: OracleConnectionPoolDataSource

2007-07-23 Thread Julio J. Suárez Salinero
not Zdenek. I'm Julio. Regards. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 10:27 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Julio, Julio J. Suárez Salinero wrote

RE: OracleConnectionPoolDataSource

2007-07-23 Thread Propes, Barry L
ok...is it you having problems or Zdenek? Sorry for my mistaking you two. -Original Message- From: Julio J. Suárez Salinero [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 11:46 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource Propes, Barry L escribió: Like I

Re: OracleConnectionPoolDataSource

2007-07-20 Thread Julio J. Suárez Salinero
Popov escribió: Yes, this is Oracle specific. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 12:24 PM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Seva, Seva Popov

RE: OracleConnectionPoolDataSource

2007-07-20 Thread Propes, Barry L
on this: -Original Message- From: Julio J. Suárez Salinero [mailto:[EMAIL PROTECTED] Sent: Friday, July 20, 2007 10:13 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource 3. factory attribute is new. I have found it in google and it began to work when I started using

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Julio J. Suárez Salinero
I have get it to work from a context resource. I've had to specify a factory attribute. Currently context.xml is this: Context path=/test docBase=test debug=0 reloadable=true Resource name=jdbc/test auth=Container type=oracle.jdbc.pool.OracleConnectionPoolDataSource

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
: Thursday, July 19, 2007 9:43 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource I have get it to work from a context resource. I've had to specify a factory attribute. Currently context.xml is this: Context path=/test docBase=test debug=0 reloadable=true Resource name=jdbc/test auth

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
:05 AM To: Tomcat Users List Subject: RE: OracleConnectionPoolDataSource how do you know the user and password won't work from the context? Are you just trying to store it elsewhere or did you try it? Also, on the driver reference, I saw something on Oracle's site suggesting the use

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Julio J. Suárez Salinero
PROTECTED] Sent: Thursday, July 19, 2007 9:43 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource I have get it to work from a context resource. I've had to specify a factory attribute. Currently context.xml is this: Context path=/test docBase=test debug=0 reloadable=true

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Seva Popov
You need to use user=test instead of username=test. This should work in the context.xml file. -Original Message- From: Julio J. Suárez Salinero [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 8:16 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource Propes

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Julio, Julio J. Suárez Salinero wrote: Context path=/test docBase=test debug=0 reloadable=true Seriously... get rid of those path and docBase attributes. Resource name=jdbc/test auth=Container

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Seva, Seva Popov wrote: You need to use user=test instead of username=test. This should work in the context.xml file. Is this Oracle-specific? I use 'user=username' in my Resource element and it works perfectly. - -chris -BEGIN PGP

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource Zdeněk Vráblík escribió: Hi, There is error in driverClassName. Try use this: driverClassName=oracle.jdbc.driver.OracleDriver Thanks, but I already have tested that with the same results. Zdenek On 7/18/07, Julio J. Suárez

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
PROTECTED] Sent: Wednesday, July 18, 2007 8:12 PM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, Propes, Barry L wrote: are you importing the following packages? You maybe should. import javax.naming.Context; import

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
it's NOT Oracle specific. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 2:24 PM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Seva, Seva Popov wrote: You need

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, Propes, Barry L wrote: it's NOT Oracle specific. If the user attribute is not Oracle-specific, then Seva is out of his mind: Seva Popov wrote: You need to use user=test instead of username=test. This should work in the context.xml file.

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
I do use user, but it's not required by OracleI could use something like o_user if I wanted to. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 4:01 PM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource -BEGIN

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, Propes, Barry L wrote: I do use user, but it's not required by OracleI could use something like o_user if I wanted to. Huh? You can do this: Resource ... o_user=my_username ... / ... and it will work? Through what voodoo does

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
no, not for the resource tag. Sorry -- but for the table title. My apologies. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 4:12 PM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource -BEGIN PGP SIGNED MESSAGE

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
List Subject: Re: OracleConnectionPoolDataSource -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, Propes, Barry L wrote: I do use user, but it's not required by OracleI could use something like o_user if I wanted to. Huh? You can do this: Resource ... o_user=my_username

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Seva Popov
Yes, this is Oracle specific. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 12:24 PM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Seva, Seva Popov wrote: You need

RE: OracleConnectionPoolDataSource

2007-07-18 Thread Caldarale, Charles R
From: Julio J. Suárez Salinero [mailto:[EMAIL PROTECTED] Subject: OracleConnectionPoolDataSource I'm Trying to connect a JSP tomcat-based application to Oracle using OracleConnectionPoolDataSource and related classes. Don't suppose you'd be interested in telling us the version of Tomcat

Re: OracleConnectionPoolDataSource

2007-07-18 Thread Zdeněk Vráblík
Hi, There is error in driverClassName. Try use this: driverClassName=oracle.jdbc.driver.OracleDriver Zdenek On 7/18/07, Julio J. Suárez Salinero [EMAIL PROTECTED] wrote: I'm Trying to connect a JSP tomcat-based application to Oracle using OracleConnectionPoolDataSource and related classes. I

Re: OracleConnectionPoolDataSource

2007-07-18 Thread Julio J. Suárez Salinero
Zdeněk Vráblík escribió: Hi, There is error in driverClassName. Try use this: driverClassName=oracle.jdbc.driver.OracleDriver Thanks, but I already have tested that with the same results. Zdenek On 7/18/07, Julio J. Suárez Salinero [EMAIL PROTECTED] wrote: I'm Trying to connect a JSP

Re: OracleConnectionPoolDataSource

2007-07-18 Thread Julio J. Suárez Salinero
Caldarale, Charles R escribió: From: Julio J. Suárez Salinero [mailto:[EMAIL PROTECTED] Subject: OracleConnectionPoolDataSource I'm Trying to connect a JSP tomcat-based application to Oracle using OracleConnectionPoolDataSource and related classes. Don't suppose you'd be interested in

RE: OracleConnectionPoolDataSource

2007-07-18 Thread Propes, Barry L
Users List Subject: Re: OracleConnectionPoolDataSource Zdeněk Vráblík escribió: Hi, There is error in driverClassName. Try use this: driverClassName=oracle.jdbc.driver.OracleDriver Thanks, but I already have tested that with the same results. Zdenek On 7/18/07, Julio J. Suárez Salinero

Re: OracleConnectionPoolDataSource

2007-07-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, Propes, Barry L wrote: are you importing the following packages? You maybe should. import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; Erm if he weren't importing those packages,