AnsweredAssumed Answered

JDBC Connection Problem after faulty sql statement

Question asked by puschteblume on Mar 11, 2009


JDBC Connection Problem after faulty sql statement

Description of the issue

I connect via JDBC to FM10. This works quite well, but if I have a faulty sql statement the JDBC Server isn't reachable anymore. E.g. I generate an insert statement. I am in the development cycle and so I often have statements that can be incorrect:INSERT INTO resource ("elementId") VALUES ("id001", NULL)This statement leads to the following exception:java.sql.SQLException: [DataDirect][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed.If this exception occures, the database isn't furthermore reachable. The DB must be started often until it will be reachable again. Is this a normal behaviour?