ResultSetType Settings in Openoffice Base
Asli Oezal <[email protected]> Fri, 17 Sep 2010 11:30:40 +0200
| Newsgroups | gmane.comp.openoffice.dba.devel |
|---|---|
| Message-ID | <OF8AAAC3C6.76F1154A-ONC12577A1.00343AF9-C12577A1.00344C4D@ch.ibm.com> |
Hello, I am currently developing a DB project and I have implemented a database with IBM DB2 and connected it with jcc driver to Openoffice base. I had problems with "join queries of several tables". I searched in the source code of oo and in the internet, and I realized that the error arises from ResultSet settings, which are set to TYPE_SCROLL_SENSITIVE, default by openoffice. In order to display the results for a join query, resultSetType should be TYPE_SCROLL_INSENSITIVE. I have found a log at : http://www.mail-archive.com/[email protected]/msg00858.html From what I understand, it is possible to update content.xml file, < db:data-source> part to set the result set type. Is it correct? If so, which xml element can be set to update resultsettype of the statement? I would be glad if you could help me. Thank you for all your help in advance. Regards, Asli