ResultSetType Settings in Openoffice Base

Asli Oezal <[email protected]> Mon, 6 Sep 2010 10:11:00 +0200
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <OF3F14464A.765FA16D-ONC1257796.002CE42C-C1257796.002D0111@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