I'm trying to insert or update elements in an existing firebird database using JDBC. I access to the database with the default credentials (SYSDBA and masterkey).
The request are done successfully according JDBC but database are not modified (when I execute a select my data does not appear). I also tried to modify the database content using a software as RazorSQL, the result is the same (the database are modified during the session but if I disconnect and reconnect to the database my modifications are lost).
I anybody has an idea how to solve this problem?
Thanks in advance
Most likely you are running with autoCommit
disabled. In that case you need to explicitly call commit()
on the Connection
. Also be aware that a transaction can only see changes from transactions that were committed before it started.
See also the Jaybird JDBC Driver Java Programmer's Manual, chapter "Using transactions".
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
コメントを追加