I am using a pooled connection in my web application using jboss specific configuration file oracle-ds.xml the entries of the file is :
<local-tx-datasource>
<jndi-name>OracleDS-QA</jn
di-name>
<connection-url>jdbc:oracl
e:thin:@op
i049.nod.c
omp.com:15
51:prodqa<
/connectio
n-url>
<driver-class>oracle.jdbc.
driver.Ora
cleDriver<
/driver-cl
ass>
<user-name>xxx</user-name>
<password>123</password>
<exception-sorter-class-na
me>org.jbo
ss.resourc
e.adapter.
jdbc.vendo
r.OracleEx
ceptionSor
ter</excep
tion-sorte
r-class-na
me>
<valid-connection-checker-
class-name
>org.jboss
.resource.
adapter.jd
bc.vendor.
OracleVali
dConnectio
nChecker</
valid-conn
ection-che
cker-class
-name>
<new-connection-sql>select
1 from dual</new-connection-sql>
<check-valid-connection-sq
l>select 1 from dual</check-valid-connecti
on-sql>
<min-pool-size>10</min-poo
l-size>
<max-pool-size>100</max-po
ol-size>
<idle-timeout-minutes>1</i
dle-timeou
t-minutes>
<metadata>
<type-mapping>Oracle8i</ty
pe-mapping
>
</metadata>
</local-tx-datasource>
In my application I am getting the connection by datasource as :
Context ctx=new InitialContext();
ds = (DataSource) ctx.lookup(jndiName);
..
ds.getConnection();
When I complete load testing with 50 users I found 50 inactive connections at oracle side
[ SELECT COUNT(*) FROM v$session WHERE osuser='tsering' AND status='INACTIVE' ]
and when i complete single transation after that my inactive conn incremented by 1.
I am not aware why the inactive connections are there at oracle side. Is there any mechanism to remove these inactive connections from oracle side.
I know that when we call con.close() method in a pooled connection the connection is returned back to pool but I didn't know why it is not using the inactive connection for a new connection request it is creating a new one.
