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
ubject: Re: OracleConnectionPoolDataSource -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 clo

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 f

RE: OracleConnectionPoolDataSource

2007-07-23 Thread Propes, Barry L
ubject: Re: OracleConnectionPoolDataSource 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

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", "Exha

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

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
this is not the problem. 3. "factory" attribute is new. I have found it in google and it began to work when I started using it. 4. I use OracleConnectionPoolDataSource because with javax.sql.DataSource it doesn't close correctly close connections from pool and server got to h

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
anks, 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 tomcat-based application to Oracle using >> OracleConnectionPoolDataSource and related

RE: OracleConnectionPoolDataSource

2007-07-19 Thread Propes, Barry L
); >> ctx = (Context) initCtx.lookup("java:/comp/env"); >> fuenteDatos = (OracleConnectionPoolDataSource) ctx.lookup("/jdbc/test"); >> PooledConnection pc = fuenteDatos.getPooledConnection(); >> con = pc.getConnection(); >> -Original Message- From

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
ssword doesn't work in context.xml. Huh? If that's true, then you have a crappy DataSource and/or Factory implementation. > Context ctx = (Context) initCtx.lookup("java:/comp/env"); > OracleConnectionPoolDataSource fuenteDatos = > (OracleConnectionPoolDataSource) ctx.lookup(

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
;java:/comp/env"); OracleConnectionPoolDataSource fuenteDatos = (OracleConnectionPoolDataSource) ctx.lookup("/jdbc/test"); pc = fuenteDatos.getPooledConnection(dbUser, dbPassword); dbUser and dbPassword are loaded from a configuration file. Now, I can set pool maximum size in context.xml, but it still cr

Re: OracleConnectionPoolDataSource

2007-07-18 Thread Christopher Schultz
ren't importing those packages, his code wouldn't compile. The OP has a problem with /configuration/: >>> I'm Trying to connect a JSP tomcat-based application to Oracle >>> using OracleConnectionPoolDataSource and related classes. I have >>> used javax.sql.Dat

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

Re: OracleConnectionPoolDataSource

2007-07-18 Thread Julio J. Suárez Salinero
: I'm Trying to connect a JSP tomcat-based application to Oracle using OracleConnectionPoolDataSource and related classes. I have used javax.sql.DataSource an it did work fine. I have made changes I need for using that classes and when I get the DataSource it throws exception "javax.n

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 OracleConne

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

OracleConnectionPoolDataSource

2007-07-18 Thread Julio J. Suárez Salinero
I'm Trying to connect a JSP tomcat-based application to Oracle using OracleConnectionPoolDataSource and related classes. I have used javax.sql.DataSource an it did work fine. I have made changes I need for using that classes and when I get the DataSource it throws exce