Return-Path: 
 <user-java-return-16743-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 71328 invoked from network); 29 Apr 2009 13:07:34 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 29 Apr 2009 13:07:34 -0000
Received: (qmail 18648 invoked by uid 500); 29 Apr 2009 13:07:33 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 18610 invoked by uid 500); 29 Apr 2009 13:07:33 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 18602 invoked by uid 99); 29 Apr 2009 13:07:33 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Apr 2009 13:07:33 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of delgurth@gmail.com designates
 209.85.218.177 as permitted sender)
Received: from [209.85.218.177] (HELO mail-bw0-f177.google.com)
 (209.85.218.177)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Apr 2009 13:07:26 +0000
Received: by bwz25 with SMTP id 25so1222190bwz.0
        for <user-java@ibatis.apache.org>;
 Wed, 29 Apr 2009 06:07:04 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:in-reply-to:references
         :date:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        bh=FA32MFpMleQOu37b8YbO25sDCQz9Lw3E7dX9/hTyPv0=;
        b=hdt/yocEK7UGp2ikS3pNHFBWg4cN76JODVohbze0HHsErR3GvEum5xCX+oe/e82Gs0
         FnAhEKZKZKHToJlyuAN0/kOkUaylkzR+EMbSffoRJAIBGDSU+s+pNH3ug9IdrN4OXHPr
         LUAqUw1Jth0wfKgjhkR5csDtS2p4Neg8QzT5g=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=Ral4yosw9sXkdbJgI2Ld/SvLz1ZeBPjwZ+5sJzoBKiPaJqPixBWmQaY7K9xgmb6nQ6
         zsKkdlgYd2l7Xf7nDq/rypf6bXq8DqQPca7SQoiHL6pBJPMsL78rBedPzPEn7djmpSkz
         /MoJYAPSGfH6d28Qr4D2t4ABKA5b4ZyPiaYfo=
MIME-Version: 1.0
Received: by 10.223.115.80 with SMTP id h16mr191822faq.94.1241010424722; Wed,
	29 Apr 2009 06:07:04 -0700 (PDT)
In-Reply-To: 
 <F9A636CE089E2F49850CD750D7B5C391073CACD5@naeajaxsez07.nadsusea.nads.navy.mil>
References: 
 <F9A636CE089E2F49850CD750D7B5C391073CACD5@naeajaxsez07.nadsusea.nads.navy.mil>
Date: Wed, 29 Apr 2009 15:07:04 +0200
Message-ID: <10268b3e0904290607l33a97361x8c965d2199f5e49b@mail.gmail.com>
Subject: Re: Oracle v$session and iBatis
From: DelGurth <delgurth@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Checked: Checked by ClamAV on apache.org

I'm just wondering, how exactly are are monitoring the connections
using v$session? Since 27/28 sessions already seems to be way more
then what you configured: <property
name=3D"Pool.MaximumActiveConnections" value=3D"10"/>

Do you filter for the user that you configured and checking the
active/inactive status of the session?

Wessel

On Wed, Apr 29, 2009 at 1:18 PM, 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! =A0It=
's a
> good thing this wasn't to solve an enterprise question or anything. =A0Oh=
,
> 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. =A0For testing purposes, we tested one user loggin=
g
> into the system, doing a couple of transactions, then logging out. =A0The
> number of "connections" (for lack of a better term) in v$session fluctuat=
ed
> greatly, and when the user logged out of the application, the number of
> "connections" went from 27...to 28! =A0Does it make sense for a user to l=
og
> out and INCREASE the number of connections?
>
> Here's how my transaction manager is configured:
>
> <sqlMapConfig>
> =A0<settings
> =A0 =A0cacheModelsEnabled=3D"false"
> =A0 =A0enhancementEnabled=3D"false"
> =A0 =A0 =A0 =A0lazyLoadingEnabled=3D"false"
> =A0 =A0maxSessions=3D"64"
> =A0 =A0maxTransactions=3D"32"
> =A0 =A0maxRequests=3D"512"/>
>
> =A0<transactionManager type=3D"JDBC">
> =A0 =A0<dataSource type=3D"SIMPLE">
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"DataSource" value=3D"${d=
atasource}"/>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"JDBC.Driver" value=3D"${=
driver}"/>
> =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"JDBC.ConnectionURL" value=3D"${u=
rl}"/>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"JDBC.Username" value=3D"=
${username}"/>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"JDBC.Password" value=3D"=
${password}"/>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"JDBC.DefaultAutoCommit"
> value=3D"$(autocommit)"/>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"Pool.MaximumActiveConnec=
tions" value=3D"10"/>
> <!-- Default =3D 10 -->
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"Pool.MaximumIdleConnecti=
ons" value=3D"5"/>
> <!-- Default =3D 5 =A0-->
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"Pool.MaximumCheckoutTime=
" value=3D"20000"/>
> <!-- Default =3D 20000 milliseconds =A0-->
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"Pool.TimeToWait" value=
=3D"20000"/>
> <!-- Default =3D 20000 milliseconds =A0-->
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"Pool.PingEnabled" value=
=3D"true"/>
> <!-- Default =3D false =A0-->
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"Pool.PingQuery" value=3D=
"select 0 from dual"/>
> <!-- No Default Query =A0-->
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"Pool.PingConnectionsOlde=
rThan"
> value=3D"7200000"/> =A0 =A0 =A0 =A0 =A0 =A0 =A0 <!-- Default =3D 0 millis=
econds =A0-->
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"Pool.PingConnectionsNotU=
sedFor"
> value=3D"7200000"/> =A0 =A0 =A0 =A0 =A0 =A0 =A0 <!-- No Default =A0-->
> =A0 =A0</dataSource>
> =A0</transactionManager>
>
> =A0<sqlMap resource=3D"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? =A0Is connection pooling not
> happening? =A0Any insight would be appreciated, and my apologies in advan=
ce if
> I'm not clear.
>
> Jonathan
>