KevinKruseMn
Programmer
by "krusek" <krusek@[EMAIL PROTECTED] > Jan 15, 2004 at 05:56 PM
I have a problem with tomcat 4.x DataSource connection pooling connecting to an iSeries (AS400) database using jtopen drivers. The problem is that it seems to like throwing connections away. Unless you go to the pool very soon after a connedtion has been returned, you will get the error "The connection does not exist."
If you access pages without much time elapsing it works perfectly. In fact it is very fast.
My setup is base on the examples at "Tomcat Datasource HOW-TO at
I have another jndi DataSource to the same iseries that works without losing connections but it is much slower.
2 seconds to return query results vs 9 using same sql.
I accomplished this from the post at:
But I would like to get the faster tomcat pool to work!
Is anyone sucessfully using tomcat4.x DataSource connection pooling using AS400 data from jt400 without the lost connections?
I have a problem with tomcat 4.x DataSource connection pooling connecting to an iSeries (AS400) database using jtopen drivers. The problem is that it seems to like throwing connections away. Unless you go to the pool very soon after a connedtion has been returned, you will get the error "The connection does not exist."
If you access pages without much time elapsing it works perfectly. In fact it is very fast.
My setup is base on the examples at "Tomcat Datasource HOW-TO at
I have another jndi DataSource to the same iseries that works without losing connections but it is much slower.
2 seconds to return query results vs 9 using same sql.
I accomplished this from the post at:
But I would like to get the faster tomcat pool to work!
Is anyone sucessfully using tomcat4.x DataSource connection pooling using AS400 data from jt400 without the lost connections?
