Return-Path: 
 <user-java-return-16739-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 32516 invoked from network); 29 Apr 2009 11:18:56 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 29 Apr 2009 11:18:56 -0000
Received: (qmail 78031 invoked by uid 500); 29 Apr 2009 11:18:55 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 77984 invoked by uid 500); 29 Apr 2009 11:18:54 -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 77976 invoked by uid 99); 29 Apr 2009 11:18:54 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Apr 2009 11:18:54 +0000
X-ASF-Spam-Status: No, hits=-4.0 required=10.0
	tests=RCVD_IN_DNSWL_MED,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [138.163.0.42] (HELO gate2-sandiego.nmci.navy.mil)
 (138.163.0.42)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Apr 2009 11:18:46 +0000
Received: from nawesdnieg06.nadsuswe.nads.navy.mil ([10.0.0.161]) by
 gate2-sandiego.nmci.navy.mil with Microsoft SMTPSVC(5.0.2195.6872);
	 Wed, 29 Apr 2009 04:04:44 -0700
Received: from nawesdnieb13v.nadsuswe.nads.navy.mil ([10.0.10.79]) by
 nawesdnieg06.nadsuswe.nads.navy.mil with Microsoft SMTPSVC(6.0.3790.1830);
	 Wed, 29 Apr 2009 04:18:18 -0700
Received: from NAEAJAXSEB01.nadsusea.nads.navy.mil ([10.27.4.144]) by
 nawesdnieb13v.nadsuswe.nads.navy.mil with Microsoft SMTPSVC(6.0.3790.3959);
	 Wed, 29 Apr 2009 04:18:18 -0700
Received: from NAEAJAXSEZ07.nadsusea.nads.navy.mil ([10.27.4.166]) by
 NAEAJAXSEB01.nadsusea.nads.navy.mil with Microsoft SMTPSVC(5.0.2195.6713);
	 Wed, 29 Apr 2009 07:18:05 -0400
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: Re: Oracle v$session and iBatis
Date: Wed, 29 Apr 2009 07:18:03 -0400
Content-Type: multipart/signed;
	boundary="----=_NextPart_000_0000_01C9C89A.A0C4A350";
	micalg=SHA1;
	protocol="application/x-pkcs7-signature"
Message-ID: 
 <F9A636CE089E2F49850CD750D7B5C391073CACD5@naeajaxsez07.nadsusea.nads.navy.mil>
X-MS-Has-Attach: yes
X-MS-TNEF-Correlator: 
Thread-Topic: Re: Oracle v$session and iBatis
Thread-Index: AcnIvCbQ1wToZ7RTQF+iAifqi7afQA==
From: "Leffingwell, Jonathan R CTR FRCSE,
 JAX 7.2.2" <jonathan.leffingwell.ctr@navy.mil>
To: <user-java@ibatis.apache.org>
X-OriginalArrivalTime: 29 Apr 2009 11:18:05.0480 (UTC)
 FILETIME=[2AD55280:01C9C8BC]
X-Virus-Checked: Checked by ClamAV on apache.org

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C9C89A.A0C4A350
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_000_0000_01C9C89A.A0C4A350
Content-Type: application/x-pkcs7-signature;
	name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="smime.p7s"

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIQsTCCA3Aw
ggJYoAMCAQICAQUwDQYJKoZIhvcNAQEFBQAwWzELMAkGA1UEBhMCVVMxGDAWBgNVBAoTD1UuUy4g
R292ZXJubWVudDEMMAoGA1UECxMDRG9EMQwwCgYDVQQLEwNQS0kxFjAUBgNVBAMTDURvRCBSb290
IENBIDIwHhcNMDQxMjEzMTUwMDEwWhcNMjkxMjA1MTUwMDEwWjBbMQswCQYDVQQGEwJVUzEYMBYG
A1UEChMPVS5TLiBHb3Zlcm5tZW50MQwwCgYDVQQLEwNEb0QxDDAKBgNVBAsTA1BLSTEWMBQGA1UE
AxMNRG9EIFJvb3QgQ0EgMjCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAMAswfaNO6z/
PzzWcb64dCIH7HBBFfyrQOMHqsHD2J/+2kw6vz/I2Ch7SzYBwKxFJcPSDgqPhRhkED0aE3Aqb47X
3I2Ts0EPOCHNravCPSoF01cRNw3NjFH5k+PMRkkhjhS0zcsUPjjNcjHuqxLyZeo0LlZd/+5jdctt
upE0/J7z9C0cvlDEQt9ZiP9qs/qobD3LVnFxBZa7n4DlgEVZZ0Gw68OtYKSAdQYXnA70Q+CZDhv7
f/WzzLKBgrH9MsG4vkGkZLVgOlpRMIzO3kEsGUdcSRBkuXSph0GvfW66wbihv2UxOgRn+bW7jpKK
AGO4seaMOF+D/1DVO6Jda7IQzGMCAwEAAaM/MD0wHQYDVR0OBBYEFEl0uwxeunr+AlTve6DGlcYJ
gHCWMAsGA1UdDwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MA0GCSqGSIb3DQEBBQUAA4IBAQCYkY0/
ici79cBpcyk7Nay6swh2PXAJkumERCEBfRR2G+5RbB2NFTctezFp9JpEuK9GzDT6I8sDJxnSgyF1
K+fgG5km3IRAleio0sz2WFxm7z9KlxCCHboKot1bBiudp2RO6y4BNaS0PxOtVeTVc6hpmxHxmPIx
Hm9A1Ph4n46RoG9wBJBmqgYrzuF6krV94eDRluehOi3MsZ0fBUTth5nTTRpwOcEEDOV+2fGv1yAO
8SJ6JaRzmcw/pAcnlqiile2CuRbTnguHwsHyiPVi32jfx7xpUe2xXNxUVCkPCTmarAPB2wxNrm8K
ehZJ8b+R0jiU0/aVLLdsyUK2jcqQjYXZMIIEMjCCAxqgAwIBAgIBHTANBgkqhkiG9w0BAQUFADBb
MQswCQYDVQQGEwJVUzEYMBYGA1UEChMPVS5TLiBHb3Zlcm5tZW50MQwwCgYDVQQLEwNEb0QxDDAK
BgNVBAsTA1BLSTEWMBQGA1UEAxMNRG9EIFJvb3QgQ0EgMjAeFw0wNjA2MTQxNzA0MDNaFw0xMjA2
MTQxNjA0MDNaMF0xCzAJBgNVBAYTAlVTMRgwFgYDVQQKEw9VLlMuIEdvdmVybm1lbnQxDDAKBgNV
BAsTA0RvRDEMMAoGA1UECxMDUEtJMRgwFgYDVQQDEw9ET0QgRU1BSUwgQ0EtMTYwgZ8wDQYJKoZI
hvcNAQEBBQADgY0AMIGJAoGBAMOEvB2SOxvI5sDLXEVIg3nwV+7lS+3wW+d//aRbbumMaRKeSg4f
RjT/EkUlxLlsMNv/+TPd6iMOWGf3Tp9VxwG6hnuZYum3Jdw9Eh8UPN3KSitZx0efz4QpIPzTKVee
yPFU+kWbqqKj0a8cUrxx4xcZudcEOWsNkyIgJCWbziRPAgMBAAGjggGBMIIBfTAOBgNVHQ8BAf8E
BAMCAYYwHwYDVR0jBBgwFoAUSXS7DF66ev4CVO97oMaVxgmAcJYwHQYDVR0OBBYEFEeTx6MjPLQx
7sxCfN1oE8sBmo8tMAwGA1UdJAQFMAOAAQAwDwYDVR0TAQH/BAUwAwEB/zAwBgNVHSAEKTAnMAsG
CWCGSAFlAgELBTALBglghkgBZQIBCwkwCwYJYIZIAWUCAQsKMIHZBgNVHR8EgdEwgc4wOKA2oDSG
Mmh0dHA6Ly9jcmwuZ2RzLmRpc2EubWlsL2dldGNybD9Eb0QlMjBSb290JTIwQ0ElMjAyMIGRoIGO
oIGLhoGIbGRhcDovL2NybC5nZHMuZGlzYS5taWwvY24lM2REb0QlMjBSb290JTIwQ0ElMjAyJTJj
b3UlM2RQS0klMmNvdSUzZERvRCUyY28lM2RVLlMuJTIwR292ZXJubWVudCUyY2MlM2RVUz9jZXJ0
aWZpY2F0ZXJldm9jYXRpb25saXN0O2JpbmFyeTANBgkqhkiG9w0BAQUFAAOCAQEABmGErCgROvKu
ZsyImPpOvpfFp1sjjYItASeRMOrGIslXNDqH+fgGW/pmbbGJ7dObQ2KABKUqU2hY1GtWiMtqFKJO
fXQbZzqLB7Us5KAgJ79IZ+jz6clpn38BSGH7wSd3e4++rtJC0QwxJCad1xqR842s/m+TLeAeT8c5
BH9xHy6nyec/6HHeKrfQrBELbuqLNaN1lT2uZwgX3YYY+kiSGwAuYRepbFREaUkgFy1ZCpsB6kNE
oOdX0lSEFxPjTSQA2K56INfjSo83xH+8saGDIX5zcTdokdtF4v/YGu0QYFq5YczAADylbcy5nP7G
nccansBwTYLBOfiGysGgD9D56TCCBFowggPDoAMCAQICAzWabDANBgkqhkiG9w0BAQUFADBdMQsw
CQYDVQQGEwJVUzEYMBYGA1UEChMPVS5TLiBHb3Zlcm5tZW50MQwwCgYDVQQLEwNEb0QxDDAKBgNV
BAsTA1BLSTEYMBYGA1UEAxMPRE9EIEVNQUlMIENBLTE2MB4XDTA4MDcyMzAwMDAwMFoXDTA5MDYy
ODIzNTk1OVowgYQxCzAJBgNVBAYTAlVTMRgwFgYDVQQKEw9VLlMuIEdvdmVybm1lbnQxDDAKBgNV
BAsTA0RvRDEMMAoGA1UECxMDUEtJMRMwEQYDVQQLEwpDT05UUkFDVE9SMSowKAYDVQQDEyFMRUZG
SU5HV0VMTC5KT05BVEhBTi5SLjEyNTU5MDAxNDEwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGB
AInjXE5cTycRT7bhqf1gUXzLWSj73tOVd/XDqshAmGCIXGw5lOnzGi4rcvP5SdUM5DlIKKLbruKZ
X5X+nTTvureWs92/kXzYLR2wAd+o8JAKDpGO81jvLEu9IoB0z8pB+vuK2pJB7LU58y7G9HBdi4Cz
VJznT6rf5S6qJvsqjvxtAgMBAAGjggH+MIIB+jAfBgNVHSMEGDAWgBRHk8ejIzy0Me7MQnzdaBPL
AZqPLTCB1QYDVR0fBIHNMIHKMDSgMqAwhi5odHRwOi8vY3JsLmRpc2EubWlsL2dldGNybD9ET0Ql
MjBFTUFJTCUyMENBLTE2MIGRoIGOoIGLhoGIbGRhcDovL2NybC5nZHMuZGlzYS5taWwvY24lM2RE
b0QlMjBFTUFJTCUyMENBLTE2JTJjb3UlM2RQS0klMmNvdSUzZERvRCUyY28lM2RVLlMuJTIwR292
ZXJubWVudCUyY2MlM2RVUz9jZXJ0aWZpY2F0ZVJldm9jYXRpb25MaXN0O2JpbmFyeTAOBgNVHQ8B
Af8EBAMCBSAwFgYDVR0gBA8wDTALBglghkgBZQIBCwkwHQYDVR0OBBYEFIODdD6U49HA0AjCHyWJ
5zICGPmdMG0GCCsGAQUFBwEBBGEwXzA7BggrBgEFBQcwAoYvaHR0cDovL2NybC5kaXNhLm1pbC9n
ZXRzaWduP0RPRCUyMEVNQUlMJTIwQ0EtMTYwIAYIKwYBBQUHMAGGFGh0dHA6Ly9vY3NwLmRpc2Eu
bWlsMCwGA1UdEQQlMCOBIWpvbmF0aGFuLmxlZmZpbmd3ZWxsLmN0ckBuYXZ5Lm1pbDAbBgNVHQkE
FDASMBAGCCsGAQUFBwkEMQQTAlVTMA0GCSqGSIb3DQEBBQUAA4GBAI+vlMce3hXC8bzVqEOXoNUH
ucnsvuBs811v3faFPwI31EHGyrKGkl93Z5A4HzfnfA8kgow8rkzPi0xiOjaijqvTYaaA4JqVm8Ex
KF6EmUZEwrMsSjIAfB8rj02sm8sdW8Pa8kJDwF7AYv+X6j6Aa8JHBnZnyJt+6hH/v4qxnS0XMIIE
pTCCBA6gAwIBAgIDNZp3MA0GCSqGSIb3DQEBBQUAMF0xCzAJBgNVBAYTAlVTMRgwFgYDVQQKEw9V
LlMuIEdvdmVybm1lbnQxDDAKBgNVBAsTA0RvRDEMMAoGA1UECxMDUEtJMRgwFgYDVQQDEw9ET0Qg
RU1BSUwgQ0EtMTYwHhcNMDgwNzIzMDAwMDAwWhcNMDkwNjI4MjM1OTU5WjCBhDELMAkGA1UEBhMC
VVMxGDAWBgNVBAoTD1UuUy4gR292ZXJubWVudDEMMAoGA1UECxMDRG9EMQwwCgYDVQQLEwNQS0kx
EzARBgNVBAsTCkNPTlRSQUNUT1IxKjAoBgNVBAMTIUxFRkZJTkdXRUxMLkpPTkFUSEFOLlIuMTI1
NTkwMDE0MTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxlcJDNdTzuzKBqemvZX0cLhiMBoE
+SuERuxXBCF44Z1pvgsJ66Nx+cldSBIt5+nyWqr9Kvcatx7B5oaHhcTPMBRBfrL9j3gxtKysNzoW
9fdakogUB6+zEn4OD8VAkyT7+iKfbR7mB4AHTxsLyLIDpEoDHn+GwI3KdBrRYTn5o/8CAwEAAaOC
AkkwggJFMB8GA1UdIwQYMBaAFEeTx6MjPLQx7sxCfN1oE8sBmo8tMIHVBgNVHR8Egc0wgcowNKAy
oDCGLmh0dHA6Ly9jcmwuZGlzYS5taWwvZ2V0Y3JsP0RPRCUyMEVNQUlMJTIwQ0EtMTYwgZGggY6g
gYuGgYhsZGFwOi8vY3JsLmdkcy5kaXNhLm1pbC9jbiUzZERvRCUyMEVNQUlMJTIwQ0EtMTYlMmNv
dSUzZFBLSSUyY291JTNkRG9EJTJjbyUzZFUuUy4lMjBHb3Zlcm5tZW50JTJjYyUzZFVTP2NlcnRp
ZmljYXRlUmV2b2NhdGlvbkxpc3Q7YmluYXJ5MA4GA1UdDwEB/wQEAwIGwDAWBgNVHSAEDzANMAsG
CWCGSAFlAgELCTAdBgNVHQ4EFgQUvbN3eXmbWjD7m6aCsXH/puVkuD8wbQYIKwYBBQUHAQEEYTBf
MDsGCCsGAQUFBzAChi9odHRwOi8vY3JsLmRpc2EubWlsL2dldHNpZ24/RE9EJTIwRU1BSUwlMjBD
QS0xNjAgBggrBgEFBQcwAYYUaHR0cDovL29jc3AuZGlzYS5taWwwTAYDVR0RBEUwQ4Eham9uYXRo
YW4ubGVmZmluZ3dlbGwuY3RyQG5hdnkubWlsoB4GCisGAQQBgjcUAgOgEAwOMTI1NTkwMDE0MUBt
aWwwGwYDVR0JBBQwEjAQBggrBgEFBQcJBDEEEwJVUzApBgNVHSUEIjAgBgorBgEEAYI3FAICBggr
BgEFBQcDAgYIKwYBBQUHAwQwDQYJKoZIhvcNAQEFBQADgYEArJQ47TqpKshFB9/nnQbiq+ALl2f5
OFMCLyHaxwi1rduD0uCL+zz5eIhIDZ9UwOW4LDQ7VnbtbVsTIoHvE6Uguvd5gV3okTjl8BsDJrAj
C/XLF+IcpQKefluEyrucjIKyl9wRzufvMl5+tPGVDlYBOLXV+WxfCKJqZsVuDysOpgkxggKxMIIC
rQIBATBkMF0xCzAJBgNVBAYTAlVTMRgwFgYDVQQKEw9VLlMuIEdvdmVybm1lbnQxDDAKBgNVBAsT
A0RvRDEMMAoGA1UECxMDUEtJMRgwFgYDVQQDEw9ET0QgRU1BSUwgQ0EtMTYCAzWadzAJBgUrDgMC
GgUAoIIBozAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wOTA0Mjkx
MTE4MDBaMCMGCSqGSIb3DQEJBDEWBBR3ULIyBdpqzxMLendGGD5xa7NCNjBYBgkqhkiG9w0BCQ8x
SzBJMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDAH
BgUrDgMCGjAKBggqhkiG9w0CBTBzBgkrBgEEAYI3EAQxZjBkMF0xCzAJBgNVBAYTAlVTMRgwFgYD
VQQKEw9VLlMuIEdvdmVybm1lbnQxDDAKBgNVBAsTA0RvRDEMMAoGA1UECxMDUEtJMRgwFgYDVQQD
Ew9ET0QgRU1BSUwgQ0EtMTYCAzWabDB1BgsqhkiG9w0BCRACCzFmoGQwXTELMAkGA1UEBhMCVVMx
GDAWBgNVBAoTD1UuUy4gR292ZXJubWVudDEMMAoGA1UECxMDRG9EMQwwCgYDVQQLEwNQS0kxGDAW
BgNVBAMTD0RPRCBFTUFJTCBDQS0xNgIDNZpsMA0GCSqGSIb3DQEBAQUABIGAY54j+mbKP9B/daBt
dXtogKaYlh12oCFbtdu6rMxyTuHmfK9+LfNs1uZZgyxt9jbPTSG4rez4qxr1At359RvPVM7r9Msg
TOP8820QmWw2v6M0swDfuV7GiCwZpHHM084w4Wsha8Ti4JedFewgUu9lZ2XF7b5Ld3zLrfxwNmXs
J9cAAAAAAAA=

------=_NextPart_000_0000_01C9C89A.A0C4A350--