Thanks! :) By the way, I have "bad" news... The OracleConnectionCachingImpl class is actually deprecated. Use OracleConnectionCacheManager with OracleDataSource instead. Take a look at:
oracle JDBC reference: http://download-west.oracle.com/docs/cd/B12037_01/java.101/b10979/toc.htm oracle JDBC resources: http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/oracle10g/conncache/Readme.html Found it 2 days ago, thanks to an Eclipse warning :) How to port this to Spring/Struts2 I have no idea... I am actually doing my Model layer using directly jdbc. cheers On 12/18/07, kenk <[EMAIL PROTECTED]> wrote: > > > Filipe, > > Funny, I was looking for the same information. Here's the Spring > configuration I'm moving forward with to use the Oracle connection > pooling: > > <!-- Database connection using the Oracle connection pool --> > <bean id="dataSource" class="oracle.jdbc.pool.OracleConnectionCacheImpl" > > <property name="connectionPoolDataSource" > > <bean class=" > oracle.jdbc.pool.OracleConnectionPoolDataSource" > > <property name="URL" value=" > jdbc:oracle:thin:@devlxdb02:1522:xxxxxx" > /> > <property name="user" value="xxxxxx" /> > <property name="password" value="xxxxxx" /> > </bean> > </property> > <property name="maxLimit" value="10" /> > <property name="minLimit" value="2" /> > </bean> > > Seems to work for now. There is probably a less verbose way to do this. > And yes I agree this isn't a Struts question, but I hope it helps. > > thx, > Ken K > -- > View this message in context: > http://www.nabble.com/Struts-2-%2B-Spring-2-%2B-JPA-%2B-Oracle-%2B-Connection-Caching-Pooling-tp14284397p14398750.html > Sent from the Struts - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Filipe David Manana, [EMAIL PROTECTED] Obvious facts are like secrets to those not trained to see them.
