Hi all,
 
 
I am trying to use a connection pool in Tomcat to make JDBC connections
to an Oracle Database.
The pool works fine, because I can get a connection from it.
 
The problem is that I want that Tomcat makes a set of connections at
startup, and for that I used the initialSize parameter, but when I
restart the tomcat any connection is established.
 
I configured the connections to the database in the context.xml file,
and his content is:
 
<Context>
  <Resource name="jdbc/myoracle" auth="Container"
            type="javax.sql.DataSource" username="pret" password="pret"
            driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@10.197.92.48:1522:SIMEIDT"
            initialSize="2" maxActive="8"/>
 
</context>
 
 
The version of Tomcat is 6.0.10
 
I test the number of connections established with the following select:
 
       select machine, status from v$session;
 
Can any body say me what is wrong. Is it necessary to configure another
thing?
 
 
Regards,
 
Rui Torres