Number of connections opened

[Rick Bos]

I am creating an application that uses both CMP and BMP entity beans to
connect to 
a database.  There is only one database in the application.

The development version of the Ingres database only allows five connections
to be open.

I am always running out of connections in Orion.

Is there a way to set the number of connections being opened ?

Also, what is the proper way get a Connection inside CMP entity bean ?

I have been using:

  ds = (DataSource ) jndiContext.lookup("java:comp/env/jdbc/apsdev"); 

where I have 

 <resource-ref>
         <description>Data source for WebEOL</description>
         <res-ref-name>jdbc/apsdev</res-ref-name>
         <res-type>javax.sql.DataSource</res-type>
         <res-auth>Container</res-auth>
 </resource-ref>

in my ejb-jar.xml.

Thanks.