Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Berglas, Anthony
Hello, I am trying to set up 0racle connection pooling. Some of the parameters are reflected normally, but some are specified via a property lists. How do I set the property list properties using Tomcat/JNDI? I can set up the basic DataSource, but I cannot set the maxLimit parameter on the

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Rainer Jung
Berglas, Anthony wrote: Hello, I am trying to set up 0racle connection pooling. Some of the parameters are reflected normally, but some are specified via a property lists. How do I set the property list properties using Tomcat/JNDI? I can set up the basic DataSource, but I cannot set the

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread David Smith
Be careful of your attribute names as case matters. Attribute names = class property names and class properties are usually referred to with a lower case first letter as in initialLimit=5, not InitialLimit=5. --David Andrew Hole wrote: Hello! I think that I have the same problem.

RE: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Caldarale, Charles R
From: Andrew Hole [mailto:[EMAIL PROTECTED] Subject: Re: Datasource Property Parameters (Oracle) JNDI I don't see examples with initial size of pool! Exists some default value for pool initial size?? To quote from the doc: See the DBCP documentation for a complete list of configuration

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Andrew Hole
I don't see examples with initial size of pool! Exists some default value for pool initial size?? On Jan 11, 2008 2:27 PM, Caldarale, Charles R [EMAIL PROTECTED] wrote: From: Andrew Hole [mailto:[EMAIL PROTECTED] Subject: Re: Datasource Property Parameters (Oracle) JNDI Could you help me

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Andrew Hole
maxIdle=10 minIdle=5 maxWait=-1 defaultAutoCommit=false / On Jan 11, 2008 2:40 PM, Caldarale, Charles R [EMAIL PROTECTED] wrote: From: Andrew Hole [mailto:[EMAIL PROTECTED] Subject: Re: Datasource Property Parameters (Oracle) JNDI I don't see examples with initial size of pool

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Andrew Hole
Hole [EMAIL PROTECTED] To: Tomcat Users List users@tomcat.apache.org Sent: Friday, January 11, 2008 10:14 AM Subject: Re: Datasource Property Parameters (Oracle) JNDI Well, REsource A works nice. When I startup Tomcat, are created 5 new database connections. Resource B allows connections

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Martin Gainty
=alert initialSize=5 maxActive=50 maxIdle=10 minIdle=5 maxWait=-1 defaultAutoCommit=false / On Jan 11, 2008 2:40 PM, Caldarale, Charles R [EMAIL PROTECTED] wrote: From: Andrew Hole [mailto:[EMAIL PROTECTED] Subject: Re: Datasource Property Parameters (Oracle) JNDI I don't

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Andrew Hole
Property Parameters (Oracle) JNDI This doesn't resolve your problem, but you have errors in your KMS.xml file. Context path=/KMS docBase=KMS debug=5 reloadable=true crossContext=true Assuming you're using a reasonably current version of Tomcat (you didn't explicitly tell us, but your Resource

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Andrew Hole
Hello! I think that I have the same problem. Resource name=ehr auth=Container type=oracle.jdbc.pool.OracleDataSource factory=oracle.jdbc.pool.OracleDataSourceFactory driverClassName=oracle.jdbc.OracleDriver url=jdbc:oracle:thin:@192.168.1.244:1521:SID user=

RE: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Caldarale, Charles R
From: Andrew Hole [mailto:[EMAIL PROTECTED] Subject: Re: Datasource Property Parameters (Oracle) JNDI Well, REsource A works nice. When I startup Tomcat, are created 5 new database connections. Resource B allows connections to be created, but without pooling. Your resource A is using

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Andrew Hole
, January 11, 2008 11:08 AM Subject: Re: Datasource Property Parameters (Oracle) JNDI I already change from ehr to jdbc/ehr but the problem of pooling remaining. Initial sessions are not created. Please, help me. Thanks a lot On Jan 11, 2008 3:45 PM, Andrew Hole [EMAIL PROTECTED] wrote

RE: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Caldarale, Charles R
From: Berglas, Anthony [mailto:[EMAIL PROTECTED] Subject: Datasource Property Parameters (Oracle) JNDI This doesn't resolve your problem, but you have errors in your KMS.xml file. Context path=/KMS docBase=KMS debug=5 reloadable=true crossContext=true Assuming you're using a reasonably

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Martin Gainty
did you verify the listener on port 1521 is listening? netstat -a | grep 1521 M-- - Original Message - From: Andrew Hole [EMAIL PROTECTED] To: Tomcat Users List users@tomcat.apache.org Sent: Friday, January 11, 2008 11:08 AM Subject: Re: Datasource Property Parameters (Oracle) JNDI I

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Andrew Hole
Sent: Friday, January 11, 2008 10:14 AM Subject: Re: Datasource Property Parameters (Oracle) JNDI Well, REsource A works nice. When I startup Tomcat, are created 5 new database connections. Resource B allows connections to be created, but without pooling. I'm without ideas

RE: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Caldarale, Charles R
From: Andrew Hole [mailto:[EMAIL PROTECTED] Subject: Re: Datasource Property Parameters (Oracle) JNDI Could you help me to setup my datasource to works fine? The instructions are here: http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.h tml - Chuck THIS COMMUNICATION

RE: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Propes, Barry L
how are those even different? Aside from the username? -Original Message- From: Andrew Hole [mailto:[EMAIL PROTECTED] Sent: Friday, January 11, 2008 9:14 AM To: Tomcat Users List Subject: Re: Datasource Property Parameters (Oracle) JNDI Well, REsource A works nice. When I startup Tomcat

Re: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Juha Laiho
Berglas, Anthony wrote: I am trying to set up 0racle connection pooling. Some of the parameters are reflected normally, but some are specified via a property lists. How do I set the property list properties using Tomcat/JNDI? I can set up the basic DataSource, but I cannot set the maxLimit

RE: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Caldarale, Charles R
From: Propes, Barry L [mailto:[EMAIL PROTECTED] Subject: RE: Datasource Property Parameters (Oracle) JNDI how are those even different? Aside from the username? They look very different to me. Resource A type=javax.sql.DataSource driverClassName=oracle.jdbc.driver.OracleDriver

RE: Datasource Property Parameters (Oracle) JNDI

2008-01-11 Thread Propes, Barry L
(Oracle) JNDI From: Propes, Barry L [mailto:[EMAIL PROTECTED] Subject: RE: Datasource Property Parameters (Oracle) JNDI how are those even different? Aside from the username? They look very different to me. Resource A type=javax.sql.DataSource driverClassName