ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert King" <robert.k...@authoria.com>
Subject RE: oracle and dbcp
Date Thu, 21 Sep 2006 00:41:29 GMT
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