Title: RE: Oracle database and connection pooling
Try using com.evermind.sql.DriverManagerDataSource as your datasource class and set your max-connections. Look it up using your ejb-location and setting it to the standard DataSource interface. Orion will pool the connection automatically
Try this:
DataSource dataSource = (DataSource)context.lookup("jdbc/OraclePooledDS");
Connection con = dataSource.getConnection();
orion will return a pooled connection to you.
James Birchfield
Ironmax
a better way to buy, sell and rent construction equipment
5 Corporate Center
9960 Corporate