oracle connection pool issue

Helge Weissig <[email protected]>
Newsgroups gmane.comp.jakarta.turbine.torque.user
Message-ID <[email protected]>
Hi all,

	the following configuration and pseudo code cause my web application  
to hang if the value of numObjects is larger than the value of  
torque.dsfactory.oracle.pool.maxActive

Torque.properties:

torque.database.oracle.adapter=oracle
torque 
.dsfactory 
.oracle.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque 
.dsfactory.oracle.connection.driver=oracle.jdbc.driver.OracleDriver
torque.dsfactory.oracle.pool.maxActive=40

java pseudo code:

for (int n = 0; n < numObjects; n++) {
	TestTable o = new TestTable();
	o.setRowValue(n);
	o.save();
}

I have (without success) tried several other ways, including the re- 
use of one single connection:

Connection con = Torque.getConnection("oracle");
for (int n = 0; n < numObjects; n++) {
	TestTable o = new TestTable();
	o.setRowValue(n);
	TestTablePeer.doInsert(o, con);
}
con.close();

Any idea what would allow me to not have to use some ridiculously high  
value for the number of maximum active connections in the connection  
pool?

I am using Torque 3.3 and Oracle 8i (OK, yes, that may be a problem,  
but I would still love to hear the *reason*). The table in question  
uses a native ID method via a simple sequence.

thanks so much!
h.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.