fape

I have my test environment. It has absolutely no problems. It's without the http service, because it doesn't support trancastions. I receive the error "Property not supported" if I try to start a transaction. It's the english version with no FMServer.

chrisonmaui, I can show the java code ... I think it's ok ... but never completely sure!!! .... String cSQL = "INSERT INTO LW_astat auftragsnummer,astatnum,astatid,status) VALUES ('56923',10,0,1) Connection conn = getConnection(); try { Statement st = conn.createStatement(); LOTrace.SQL(cSQL); st.executeUpdate(cSQL); ///here the and "invalid cursor state" error is thrown st.close(); } catch(SQLException e){ LOTrace.error(e.getMessage()); throw e; } ...

I have made a Reply but I cannot understand where is gone!!! Let's try with a quick reply .... I'm not sure to understand your question, Anatoli ... I don't use scripts in the java side. They are executed only in FM side. On the java the sql commands can be descripted as follows: <START TRANSACTION> <SELECT * FROM XXX> <DELETE FROM XXX WHERE yyyy> <DELETE FROM XXX WHERE zzzz> <COMMIT TRANSACTION> or <START TRANSACTION> <INSERT INTO XXXX ...> <INSERT INTO XXXX ...> <COMMIT TRANSACTION> I think that the real java code contains no errors because other databases are involved in this java application, and all works perfectly. Only the java code that use the FM database gives all these problems.

Hi all, I have browsed the entire FAQ list, but I have not found a response to my problem. I must access FM from a java application that execute inserts and deletes. All is working perfectly but sometimes the java application hangs with the error "Invalid cursor state" and cannot reconnect to the FM unless it is restarted. Other times the java application breaks indefinitely when committing a transaction. May be it's due to the concurrent access to the FM files from java and FM scripts ?? For information I'm using German version of FM and FMServer. Anyone has never found a similar problem ??