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)
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.
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
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
