I'm not using dbcp. I need to investigate this further. Thanks again for your help.
-----Original Message----- From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:32 PM To: user-java@ibatis.apache.org Subject: Re: oracle and dbcp ibatis only asks the datasource for a connection. it is up to that datasource to pool or not to pool. Do you see your problems when using both the build in simple connection pool and the dbcp from apache? On 9/20/06, Robert King <[EMAIL PROTECTED]> wrote: > Nathan, thank you for the help. I did make that assumption;) My > problem is performance. Does ibatis keep a pool of open connections? I > recently moved to a new database that has a long connection time but > short query times. I am experiencing severe performance problems and am > a loss as how to solve this problem. I think ibatis is doing a connect > on every database access. Any suggestions? > > -----Original Message----- > From: Nathan Maves [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 20, 2006 5:20 PM > To: user-java@ibatis.apache.org > Subject: Re: oracle and dbcp > > Guide even and it can be found > http://cvs.apache.org/dist/ibatis/ibatis.java/docs/iBATIS-SqlMaps-2_en.p > df > > On 9/20/06, Nathan Maves <[EMAIL PROTECTED]> wrote: > > I hope you don't assume that you can just change SIMPLE to DBCP and > > have it work :) > > > > Please review page 13 of the current Developers guild for and example > of each. > > > > Nathan > > > > On 9/20/06, Robert King <[EMAIL PROTECTED]> wrote: > > > Follows is my configuration info. > > > > > > Form Database.properties > > > > > > driver=oracle.jdbc.driver.OracleDriver > > > url=jdbc:oracle:thin:@curie.hire.com:1521:rec01 > > > ... > > > > > > From sqlMapConfig.xml > > > <transactionManager type="JDBC"> > > > <dataSource type="SIMPLE"> > > > <property value="${driver}" name="JDBC.Driver"/> > > > <property value="${url}" name="JDBC.ConnectionURL"/> > > > <property value="${username}" name="JDBC.Username"/> > > > <property value="${password}" name="JDBC.Password"/> > > > <property name="Pool.MaximumActiveConnections" value="10" > /> > > > <property name="Pool.MaximumIdleConnections" value="5" /> > > > <property name="Pool.MaximumCheckoutTime" value="120000" > /> > > > > > > </dataSource> > > > </transactionManager> > > > > > > -----Original Message----- > > > From: Nathan Maves [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 20, 2006 4:16 PM > > > To: user-java@ibatis.apache.org > > > Subject: Re: oracle and dbcp > > > > > > post your config info? > > > > > > On 9/20/06, Robert King <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > > > > I am having trouble configuring dbcp using oracle. Everything is > fine > > > using > > > > <dataSource type="SIMPLE">. When I change to use DBCP the oracle > > > driver is > > > > unable to load. Does anyone have a solution? > > > > > > > > > > > > > > > > Robert > > > > > > > > > > > > > > > > > > > > > >