One Star

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

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)
4 REPLIES
Community Manager

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

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

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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.
One Star

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

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
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business