If you don't mind..can you help explain to me how you even got this far? I
just installed Oracle Personal Edition, and I would like to get Orion to
pool connections, use a DataSource, and so on. I don't know about using
entity beans yet..I don't think EJB 1.1 entity is powerful enough yet..but
2.0 should be. Until then, I only have 5 tables to work with, which I will
use SQL for in the EJB session bean.
So if you could possibly explain what JDBC type 4 driver you are using
(where you got it from.URL?), how you got Orion to use it as a DataSource
instead of the Hypersonic SQL one it defaults to, and so on...I would be
much appreciated.
Thanks.
> 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
>
