com.mysql.jdbc.exceptions.MySQLNonTransientConnectionExcepti on: No operations allowed after statement closed.
Posted by: Kai Maschke
Date: June 02, 2008 12:43PM

Hi,

i'm using a MySQL 5.0.45 Server and JDBC (mysql-connector-java-5.1.6).
the program is running on a apache tomcat server.

while the development i'm using netbeans ide, so the tomcat is started locally on my machine while the mysql server is a remote server.
if i try to run the program on a tomcat on the same remote server, i get this exception:
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after statement closed.

i really can not reproduce this problem.
it cant be a connection problem because the init of the connection is working right.

here some further information:
- using PreparedStatements
- using InnoDB

some more of the log file:
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
at com.mysql.jdbc.Statement.checkClosed(Statement.java:380)
at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:3436)


i would be very glad if someone can help me.

if you need more information... just ask :)


please excuse my english but its not my home language ;)

Options: ReplyQuote


Subject
Written By
Posted
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionExcepti on: No operations allowed after statement closed.
June 02, 2008 12:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.