Hi!
I am pretty new to applicationservers and thus trying the grasp the nuts and bolts.
I have just finished a sessionbean (via a servlet) which connects to a database and
reads a specified table.
Everything works fine the first time a run my servlet. But the second time, I get no
connection,
either of the pool or a new one. I run my example, as recommended, by
ejb-location="jdbc/DefaultEJBDS"
and I am using classes111.zip from Oracle.
Can anyone help with this problem and also explain the principals behind what is
happening below.
C:\orion>java -Ddatasource.verbose=true -jar orion.jar
DataSource logwriter activated...
jdbc:oracle:thin:@myserver:1521:myInstance: Started
jdbc:oracle:thin:@myserver:1521:myInstance: Started
Orion Pooled jdbc:oracle:thin:@myserver:1521:myInstance: Started
Orion/1.3.8 initialized
Created new physical connection: XA XA Orion Pooled jdbc:oracle:thin:@myserver:1521
:SATT
null: Connection XA XA Orion Pooled jdbc:oracle:thin:@myserver:1521:myInstance
allocated
(Pool size: 0)
jdbc:oracle:thin:@myserver:1521:myInstance: Opened connection
Created new physical connection: Pooled oracle.jdbc.driver.OracleConnection@c24c
0
Pooled jdbc:oracle:thin:@myserver:1521:SATT: Connection Pooled oracle.jdbc.driver.O
racleConnection@c24c0 allocated (Pool size: 0)
Pooled jdbc:oracle:thin:@myserver:1521:SATT: Releasing connection Pooled oracle.jdb
c.driver.OracleConnection@c24c0 to pool (Pool size: [Ljavax.sql.PooledConnection
;@5f8172)
null: Releasing connection XA XA Orion Pooled
jdbc:oracle:thin:@myserver:1521:myInstance
to pool (Pool size: [Ljavax.sql.PooledConnection;@2ba11b)
Orion Pooled jdbc:oracle:thin:@myserver:1521:myinstance: Cache timeout, closing
connectio
n (Pool size: 0)
jdbc/DefaultEJBDS: Cache timeout, closing connection (Pool size: 0)
Best regards
/Theis