ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Oracle v$session and iBatis
Date Wed, 29 Apr 2009 11:22:22 GMT
Heh, welcome to Open Source Software. We all have jobs, too.

Feel free to contact any of us for freelance work. I'll happily drop
all that I'm doing to help you with your app if the rate's high
enough.

 :-D

Larry


On Wed, Apr 29, 2009 at 5:18 AM, Leffingwell, Jonathan R CTR FRCSE,
JAX 7.2.2 <jonathan.leffingwell.ctr@navy.mil> wrote:
> Hey, thanks for the TONS of helpful replies I got to this question!  It's a
> good thing this wasn't to solve an enterprise question or anything.  Oh,
> wait...it was.
>
> Signing off...
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> Oracle v$session and iBatis
> Leffingwell, Jonathan R CTR FRCSE, JAX 7.2.2
> Tue, 14 Apr 2009 07:03:18 -0700
>
> We are monitoring our web app through, among other things, looking at the
> Oracle view v$session.  For testing purposes, we tested one user logging
> into the system, doing a couple of transactions, then logging out.  The
> number of "connections" (for lack of a better term) in v$session fluctuated
> greatly, and when the user logged out of the application, the number of
> "connections" went from 27...to 28!  Does it make sense for a user to log
> out and INCREASE the number of connections?
>
> Here's how my transaction manager is configured:
>
> <sqlMapConfig>
>  <settings
>    cacheModelsEnabled="false"
>    enhancementEnabled="false"
>        lazyLoadingEnabled="false"
>    maxSessions="64"
>    maxTransactions="32"
>    maxRequests="512"/>
>
>  <transactionManager type="JDBC">
>    <dataSource type="SIMPLE">
>                <property name="DataSource" value="${datasource}"/>
>                <property name="JDBC.Driver" value="${driver}"/>
>            <property name="JDBC.ConnectionURL" value="${url}"/>
>                <property name="JDBC.Username" value="${username}"/>
>                <property name="JDBC.Password" value="${password}"/>
>                <property name="JDBC.DefaultAutoCommit"
> value="$(autocommit)"/>
>                <property name="Pool.MaximumActiveConnections" value="10"/>
> <!-- Default = 10 -->
>                <property name="Pool.MaximumIdleConnections" value="5"/>
> <!-- Default = 5  -->
>                <property name="Pool.MaximumCheckoutTime" value="20000"/>
> <!-- Default = 20000 milliseconds  -->
>                <property name="Pool.TimeToWait" value="20000"/>
> <!-- Default = 20000 milliseconds  -->
>                <property name="Pool.PingEnabled" value="true"/>
> <!-- Default = false  -->
>                <property name="Pool.PingQuery" value="select 0 from dual"/>
> <!-- No Default Query  -->
>                <property name="Pool.PingConnectionsOlderThan"
> value="7200000"/>               <!-- Default = 0 milliseconds  -->
>                <property name="Pool.PingConnectionsNotUsedFor"
> value="7200000"/>               <!-- No Default  -->
>    </dataSource>
>  </transactionManager>
>
>  <sqlMap resource="folder/sql/ourSQL.xml"/>
>
> </sqlMapConfig>
>
> Can anyone tell me how connections are handled in a simple datasource in
> iBatis, with respect to the v$session view?  Is connection pooling not
> happening?  Any insight would be appreciated, and my apologies in advance if
> I'm not clear.
>
> Jonathan
>

Mime
View raw message