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