commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <rui.tor...@enabler.com>
Subject initialSize parameter of dbcp doesn't work
Date Tue, 03 Apr 2007 17:50:47 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message