android - error -305 on UPDATE

[Former Member]

My android app is using an udb file. My problem is on an UPDATE statement, when i execute it the first time everything works properly but when I do it the second time (I execute the prepared SQL statement and the query string is still clean), I get this error:

09-27 15:07:35.920: WARN/System.err(19311): com.ianywhere.ultralitejni12.implementation.JniException: UltraLiteJ Error[-305]: I/O error 200017 -- transaction rolled back

Any helping idea in what might be the reason? thank you in advance

[chris_keating]

A -305 error indicates that there was a problem during I/O operations. Are you seeing this issue only with UPDATEs i.e., SELECT, INSERT, DELETE statements all seem to work ok? Can you run a ulvalidate (on the desktop) against this db?

[Former Member]

yes, the other query are working and also an update query is working but only the first time. When i do that 2 times, the second time is not working...

[Former Member]

How are you connecting to the database? I think that the most likely causes for an I/O error are writing to an unmounted file system or attempting to write to a file locked by another thread or process.

[Former Member]

Thanks for your reply. What do you mean with "How are you connecting to the database?" You would like to know all the methods I use?

[Former Member]

furthermore, is there any documentation for android dev using afaria sybase in their application?

[Former Member]

this is what I do

*query="UPDATE ..."; try { statement=DB_conn.prepareStatement(query); result=statement.execute(); DB_conn.commit(); statement.close(); } catch(ULjException e) { e.printStackTrace(); }

    return result;*