We have a Java Application, With back end databse as Oracle 9i.
In one of the modules, there is an option for the Client to upload multiple files at the same time.
But when Client tries to upload 3 files at a time, only 2 files are successfully processed. For the failed one we found the following SQL exception. Also we have closed all the connections properly and tested here in our enviroenment and it is working fine.
We have configuration settings as {connectionTimeout 1800} {maxConnections 50} {minConnections 0} {reapTime 180} {unusedTimeout 850} {agedTimeout 0} {purgePolicy EntirePool}}
Exception:
java.sql.SQLException: Io exception: Socket is not connectedDSRA0010E: SQL State = null, Error Code = 17,002DSRA0010E: SQL State = null, Error Code = 17,002
at sun.reflect.NativeConstruc
torAccesso
rImpl.newI
nstance0(N
ative Method)
at sun.reflect.NativeConstruc
torAccesso
rImpl.newI
nstance(Na
tiveConstr
uctorAcces
sorImpl.ja
va:39)
at sun.reflect.DelegatingCons
tructorAcc
essorImpl.
newInstanc
e(Delegati
ngConstruc
torAccesso
rImpl.java
:27)
at java.lang.reflect.Construc
tor.newIns
tance(Cons
tructor.ja
va:274)
at com.ibm.websphere.rsadapte
r.GenericD
ataStoreHe
lper.mapEx
ceptionHel
per(Generi
cDataStore
Helper.jav
a:501)
at com.ibm.websphere.rsadapte
r.GenericD
ataStoreHe
lper.mapEx
ception(Ge
nericDataS
toreHelper
.java:544)
at com.ibm.ws.rsadapter.spi.W
SRdbDataSo
urce.getPo
oledConnec
tion(WSRdb
DataSource
.java:1038
)
at com.ibm.ws.rsadapter.spi.W
SManagedCo
nnectionFa
ctoryImpl.
createMana
gedConnect
ion(WSMana
gedConnect
ionFactory
Impl.java:
958)
at com.ibm.ejs.j2c.poolmanage
r.FreePool
.createMan
agedConnec
tionWithMC
Wrapper(Fr
eePool.jav
a:1617)
at com.ibm.ejs.j2c.poolmanage
r.FreePool
.createOrW
aitForConn
ection(Fre
ePool.java
:1409)
at com.ibm.ejs.j2c.poolmanage
r.PoolMana
ger.reserv
e(PoolMana
ger.java:2
060)
at com.ibm.ejs.j2c.Connection
Manager.al
locateMCWr
apper(Conn
ectionMana
ger.java:8
07)
at com.ibm.ejs.j2c.Connection
Manager.al
locateConn
ection(Con
nectionMan
ager.java:
583)
at com.ibm.ws.rsadapter.jdbc.
WSJdbcData
Source.get
Connection
(WSJdbcDat
aSource.ja
va:333)
at com.ibm.ws.rsadapter.jdbc.
WSJdbcData
Source.get
Connection
(WSJdbcDat
aSource.ja
va:302)