JDBC reconnect problems with Teradata driver using Spring and Apache DataSource?

I'd look into the settings on Apache DBCP: commons.apache.org/dbcp/configuration.html SELECT 1 can be an efficient validation query. Test on return should be set I'd also ask that it remove and log abandoned connections so you can see what's going on.

I'd look into the settings on Apache DBCP: commons.apache.org/dbcp/configuration.html SELECT 1 can be an efficient validation query. Test on return should be set. I'd also ask that it remove and log abandoned connections so you can see what's going on.

We already use the commons connection pool (I've edited that in the question, Thanks) This runs on plain JVM under a Java Service Wrapper (wrapper.tanukisoftware. Com) to run it as a Windows service / Unix daemon. – Monis Iqbal Sep 1 '10 at 10:08 I checked them out.

There are settings for idle, wait but nothing for erroring out or reconnect – Monis Iqbal Sep 1 '10 at 10:54.

If you only see it on Linux, then I recommend checking out the Teradata JDBC Guide. When logging on, they use an algorithm which is slow on the Linux version of the JVM. Try adding the following line to teh start of your service command to see if you get any improvement -Djava.security.

Edg=file:/dev/. /urandom Note: this was taken from the troubleshooting portion of the Teradata JDBC Driver User Guide.

We have observed this problem on databases for both Linux and Windows. However the system where the JVM runs is Windows. – Monis Iqbal Sep 16 '10 at 10:45.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions