[dba-dev] Changes to DB are not persistent

2010-12-21 Thread listsandstuff
Hello, I am new to this list, hello everybody! I already posted the following problem to d...@api.openoffice.org, but here it is probably more appropiate. Sorry! I've a problem with a Base-Application (Basic). See below for a codesample. The code is adding a row to a database (Base-Document

Re: [dba-dev] Changes to DB are not persistent

2010-12-21 Thread Frank Schönheit
Hi Daniel, The code is adding a row to a database (Base-Document with embedded HSQL-DB) every time it gets called. However the changes are lost after closing OOO. To make them permanent it's necessary to flush() the DataSource. First question: This is not exspected bahaviour, is it?

Re: [dba-dev] Changes to DB are not persistent

2010-12-21 Thread Alex Thurgood
Hi Daniel, How about using commit() or setting up the connection instance as autoCommit ? http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XConnection.html#commit http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XConnection.html#setAutoCommit Alex