ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Leffingwell, Jonathan R CTR FRCSE, JAX 7.2.2" <jonathan.leffingwell....@navy.mil>
Subject Oracle v$session and iBatis
Date Tue, 14 Apr 2009 14:02:32 GMT
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