ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Maves" <nathan.ma...@gmail.com>
Subject Re: oracle and dbcp
Date Thu, 21 Sep 2006 02:32:08 GMT
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 <robert.king@authoria.com> 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:nathan.maves@gmail.com]
> 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 <nathan.maves@gmail.com> 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 <robert.king@authoria.com> 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:nathan.maves@gmail.com]
> > > 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 <robert.king@authoria.com> 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
> > > >
> > > >
> > > >
> > > >
> > >
> >
>

Mime
View raw message