topic Re: java.sql.SQLException: You can't operate on a closed Connection! Error in Installing and Upgrading

java.sql.SQLException: You can't operate on a closed Connection! Error

Anonymous — Sat, 16 Nov 2024 14:20:52 GMT

I keep getting the below error in different places when I run Talend from my home computer (that I connect through a VPN) to a remote repository. When I'm Remote desktop to a server on the LAN, and use talend, I don't get these errors.
The below error happened on the context window when I opened a new job. Usually I get these types of errors when I open a job.
java.sql.SQLException: You can't operate on a closed Connection!!!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
at com.mchange.v2.c3p0.impl.NewProxyConnection.getAutoCommit(NewProxyConnection.java:991)
at org.hibernate.jdbc.ConnectionManager.isAutoCommit(ConnectionManager.java:185)
at org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:239)
at org.hibernate.impl.SessionImpl.afterOperation(SessionImpl.java:417)
at org.hibernate.impl.SessionImpl.load(SessionImpl.java:803)
at org.talend.repository.databaseprovider.DatabaseRepositoryFactory.getItemFromResource(Unknown Source)
at org.talend.repository.databaseprovider.DatabaseRepositoryFactory.getStatus(Unknown Source)
at org.talend.repository.model.AbstractRepositoryFactory.getContextItem(Unknown Source)
at org.talend.repository.model.ProxyRepositoryFactory.getContextItem(Unknown Source)
at org.talend.core.ui.context.ContextManagerHelper.initHelper(Unknown Source)
at org.talend.core.ui.context.ContextManagerHelper.<init>(Unknown Source)
at org.talend.core.ui.context.ConextTemplateComposite.<init>(Unknown Source)
at org.talend.core.ui.context.ContextComposite.creatTemplate(Unknown Source)

Re: java.sql.SQLException: You can't operate on a closed Connection! Error

Anonymous — Fri, 06 Jun 2008 07:36:15 GMT

Hello
Are you using TIS or TOS? can you upload a screenshot of your context window ?
Best regards

shong

Re: java.sql.SQLException: You can't operate on a closed Connection! Error

Anonymous — Thu, 19 Jun 2008 17:39:56 GMT

Sorry it has taken me a while to get time to try Talend remotely again.
Attachedi s a screen shot of the error.
This is also why in another post I asked about Tweaking MYSQL server.

Re: java.sql.SQLException: You can't operate on a closed Connection! Error

_AnonymousUser — Tue, 29 Dec 2009 11:31:22 GMT

Hi shong,
Im using TOS
i want to connect to remote server database from localhost using talend.
im using MySql i can not able to connect the DB connection while Check connection.
can u guide me the right way.
thanks.
joe

Re: java.sql.SQLException: You can't operate on a closed Connection! Error

Anonymous — Wed, 30 Dec 2009 02:27:11 GMT

Hello Joe

im using MySql i can not able to connect the DB connection while Check connection.

What's the error message? Try to ping the remote IP from cmd if it is successful and check if you can connecte to remote database with other mysql client tool.
Best regards

shong