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

Re: OracleConnectionPoolDataSource

2007-07-23 Thread Julio J. Suárez Salinero
it. Note: I'm 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,

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 S

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

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 S

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-20 Thread Zdeněk Vráblík
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? 5. con variable is of type Connection. I found this in an example in google. May it be of type PooledCon

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

Re: OracleConnectionPoolDataSource

2007-07-20 Thread Julio J. Suárez Salinero
play stress test, I see only one connection and two users cannot log in at the same time. Seva 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: O

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

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
o: Tomcat Users 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: ... and it will

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 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: ... and it will work? Through what voodoo does that work? I thought that the element ende

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 -

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

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

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
have made are these: >> That's why I thought he needed to import that package. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 8:12 PM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource -BEGIN PGP SIGN

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
: "Julio J. Suárez Salinero" [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 8:07 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource Zdeněk Vráblík escribió: > Hi, > > There is error in driverClassName. > > Try use this: > driverClassName="or

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 element and it works perfectly. - -chris -BEGIN PGP SIGNATURE-

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Julio, Julio J. Suárez Salinero wrote: > Seriously... get rid of those "path" and "docBase" attributes. > type="oracle.jdbc.pool.OracleConnectionPoolDataSource" > factory="oracle.jdbc.pool.OracleDataSourceFactory" You didn't have a "factory" attr

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

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Julio J. Suárez Salinero
sage- From: "Julio J. Suárez Salinero" [mailto:[EMAIL 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.xm

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 t

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
to:[EMAIL 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: User and password doesn't

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: User and password doesn't work in context.xml. I have used a getPooledConnection overload: Context ctx = (Context) initCtx.lookup("java:/comp/env"); OracleConnectionPoolD

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 pack

RE: OracleConnectionPoolDataSource

2007-07-18 Thread Propes, Barry L
8:07 AM 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 r

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

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 T