Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

FMForums.com

JDBC Connection Problem after faulty sql statement

March 10, 200916 yr

Newbies

Hi, 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. The integration isn't finished 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?

Anybody here who experienced the same problem?

If I restart the database only once I got this error:

java.sql.SQLException: [DataDirect][sequeLink JDBC Driver]TCP/IP error, connection refused.

Thanks for your hints ..

Heiko