Hi,
I have this problem: i haw a servlet application that is connected with an
oracle database:
my jboss.jcml configuration is:
oracle.jdbc.driver.OracleDriver
tradePool
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:oracle:thin:@10.78.0.13:1521:dtrade
1200000
xxx
xxx
false
false
false
true
120000
1800000
false
true
1.0
0
ibankPool
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:oracle:thin:@10.78.0.13:1521:dibank
1200000
xxx
xxx
false
false
false
true
120000
1800000
false
false
1.0
0
my Servlet init() method:
ic = new InitialContext();
dsibank = (DataSource)ic.lookup("java:/ibankPool");
dstrade = (DataSource)ic.lookup("java:/tradePool");
Connection conDATA = dsibank.getConnection();
Connection conTITO = dsibank.getConnection();
...
this section work fine
if the connection shutdown I restore it in the service() method:
if (conDATA == null )
conDATA = dsibank.getConnection();
...
if (conTITO == null )
conTITO = dstrade.getConnection();
...
when I create a Statement on the conDATA all work ok;
when I create a Statement on the conTITO I receive an
SQLExcepion connection reset by peer.
The only difference between the conDATA and conTITO is that conTITO have
a setAutoCommit(true).
Can anybody help me??
Walter.