Random "Protocol Adapter" Error

Hello,

I am working on a java program which connects to database and update some rows periodically.

The program starts 5 threads and each thread use one database connection. So at max only 5 database connection will be open. Also after the job is done the database connection is closed.

Now the problem is I get "Protocol Adapter" error randomly. There is no specific reason for it to appear. It appears is any of the 5 threads randomly. Also some times I dont get the error!!

Can some one explain why this error occurs and how to get rid of this.

I use jre1.4 and Oracle 9.0.2's Classes12.jar to connect to database which is also of 9.0.2 version.

Thanks,

Prasanna.

[718 byte] By [prasanna_ma] at [2007-11-27 9:08:18]
# 1
Are you keeping the connections open, particularly for long periods of time?
jschella at 2007-7-12 21:46:13 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
Yes, some times one of the 5 threads take a long time to complete and it keeps the connection open for a long time.Regards,Prasanna.
prasanna_ma at 2007-7-12 21:46:13 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

> Yes, some times one of the 5 threads take a long time

> to complete and it keeps the connection open for a

> long time.

That isn't what I meant but it could be relevant

Do you open a connection and then not use it for an hour? If so what do you think happens if the database server gets bounced?

Same thing if you have a connection open for an hour and the database server gets bounced during that time.

jschella at 2007-7-12 21:46:13 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...