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