java.sql.SQLException: Closed Connection java JDBC

Question

I am getting the Error in Production as per below. Can any one give some input to eliminate this error.

java.sql.SQLException: Closed Connection
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209)
    at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:3550)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3396)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460)
    at com.IBS.trade.order.netPortfolio.getClientPortfolioDetails(netPortfolio.java:556)
    at core.ClientThreadInteractive.getNetPortFolioData(ClientThreadInteractive.java:14403)
    at core.ClientThreadInteractive.netPortfolioSingle(ClientThreadInteractive.java:14370)
    at core.ClientThreadInteractive.run(ClientThreadInteractive.java:1895)

The JDBCConnection is closed when you try to execute an SQL statement. Can you show the code? — Jens
– Jens, Commented Jun 30, 2014 at 9:18
Provide your way of using connection, some code then I can provide better solution — Ankit Katiyar
– Ankit Katiyar, Commented Jun 30, 2014 at 10:48

James Meade · Accepted Answer · 2017-08-22 10:55:57Z

3

Track shows that your connection has been closed when you are trying to use. There are few possibilities depending on your connection management.

1- Your invoked close().

2- You exceed the maximum idle timeout so database has closed your connection.

Basically it depends how you manage your connections if using per thread then may be possible that somewhere it closed during your thread that wasn't working.

-- Some details about your connection management can explain it better

edited Aug 22, 2017 at 10:55

James Meade

1,1695 gold badges26 silver badges48 bronze badges

answered Jun 30, 2014 at 10:21

Ankit Katiyar

3,0612 gold badges23 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ninad Pingale · Accepted Answer · 2014-06-30 09:17:33Z

2

Somewhere you are closing connection.

con.close();

And after that trying to access the database.

answered Jun 30, 2014 at 9:17

Ninad Pingale

7,0995 gold badges36 silver badges58 bronze badges

7 Comments

Ninad Pingale Over a year ago

Then it seem it is a connection timeout issue..Are you using any connection pooling ?

Ajay Singh Rathore Over a year ago

For real time system Response of Any query need to be fast. If taking high time for connection Timeout can paralyzed the system. It can have cascade effect.

Ninad Pingale Over a year ago

By connection Timeout,I mean if the connection remains idle for more than specified timeout time, connection gets closed. It is handled by connection pulling mechanism.So if you are already using pooling problem can be something different.

Ajay Singh Rathore Over a year ago

Can it raised due to database side Connection Restriction!! Oracle Database level there is parameter which define the no of connection can be opened at database. But at database alert log there is nothing found for the said error.

Ninad Pingale Over a year ago

Is it possible to you to restart the Oracle database..If after restart problems goes away..It is related to connection pooling..

|

sunil karki · Accepted Answer · 2020-06-08 08:08:26Z

0

Simply restarting the Application worked for me. This error is due to unavailability of resources or unable to connect to DB for some reason in JDBC.

answered Jun 8, 2020 at 8:08

sunil karki

4176 silver badges4 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLException: Closed Connection java JDBC

3 Answers 3

Comments

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related