0 Replies Latest reply on Mar 11, 2009 2:26 AM by puschteblume

    JDBC Connection Problem after faulty sql statement

    puschteblume

      Summary

      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?