Q

Problem getting disconnected from server after one hour

I am getting this error:

java.sql.SQLException: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154:at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) 

The connection is disconnected in one hour's time. It connects the first time, but after one hour it automatically disconnects. What is the problem that causes this error?


I'm going to guess that you may be connecting your application to the database through a firewall and the firewall is timing out your network connection. You should try to run SQL*Plus on the Windows application server host and see if it is able to remain connected for more than one hour. That test will eliminate the ODBC and ODBC-to-JDBC bridge from the list of possible suspects. If your SQL*Plus session is terminated (and you get a ORA-12154 or similar), then it is likely a network configuration problem on one of the hosts or a firewall in between them.
This was first published in October 2004

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close