jdbc - JDBCRowSet Not working as expected with DB2 -

i've stumbled (over hair pulled out in trying figure out) onto don't know if bug or me not doing things correctly.

i've installed latest version of extension library (v9) onto domino 8.5.3fp2 server via updatesite db , installed osgi db2 driver via same updatesite db.

after this, configured xpagesjdbc.nsf database point db2 express-c database (db2.jdbc file) , started testing. works great when use data in 2 tables (users, states) created setup functions on home page.

i modified xpages.dbutil java class have different schema name , xpages.datainitializer java class create same 2 tables, schema name part of sql statements. (e.g. "create table users (..." "create table myschema.users (.." )

i reran setup functions on homepage , tables created , populated correct data. meta data functions (left hand navigation) works 100% showing tables , schemas correctly.

the jdbc_rowsetdatasource page falls pieces. changing datasource sqltable "users" "myschema.users" works great , on page works

    <xp:this.data>        <xe:jdbcrowset connectionname="db2" var="jdbcdata1" sqltable="users" showdeleted="true">        </xe:jdbcrowset>     </xp:this.data> 

to

    <xp:this.data>        <xe:jdbcrowset connectionname="db2" var="jdbcdata1" sqltable="myschema.users" showdeleted="true">        </xe:jdbcrowset>     </xp:this.data> 

except .acceptchanges() method call.

    <xp:button value="save changes" id="button1">        <xp:eventhandler event="onclick" submit="true" refreshmode="complete">           <xp:this.action><![cdata[#{javascript:jdbcdata1.acceptchanges()}]]></xp:this.action>        </xp:eventhandler>     </xp:button> 

when want commit changes db, sql exception (see below)

the sqlcode -108 says: [sql0108n name "" has wrong number of qualifiers].

am doing wrong, or defect needs logged? looks there problem when using custom schemas? , sorry long message :)

sql stack-trace

    http jvm: com.ibm.db2.jcc.am.mo: db2 sql error: sqlcode=-108, sqlstate=42601, sqlerrmc=users, driver=4.7.85     http jvm:  @ com.ibm.db2.jcc.am.dd.a(dd.java:676)     http jvm:  @ com.ibm.db2.jcc.am.dd.a(dd.java:60)     http jvm:  @ com.ibm.db2.jcc.am.dd.a(dd.java:127)     http jvm:  @ com.ibm.db2.jcc.am.nm.c(nm.java:2493)     http jvm:  @ com.ibm.db2.jcc.am.nm.d(nm.java:2470)     http jvm:  @ com.ibm.db2.jcc.am.nm.a(nm.java:1950)     http jvm:  @ com.ibm.db2.jcc.t4.db.g(db.java:139)     http jvm:  @ com.ibm.db2.jcc.t4.db.a(db.java:39)     http jvm:  @ com.ibm.db2.jcc.t4.t.a(t.java:32)     http jvm:  @ com.ibm.db2.jcc.t4.sb.h(sb.java:135)     http jvm:  @ com.ibm.db2.jcc.am.nm.gb(nm.java:1921)     http jvm:  @ com.ibm.db2.jcc.am.om.kc(om.java:2806)     http jvm:  @ com.ibm.db2.jcc.am.om.qc(om.java:2921)     http jvm:  @ com.ibm.db2.jcc.am.om.setobject(om.java:1738)     http jvm:  @ com.ibm.xsp.extlib.jdbc.datasource.xpages.jdbcpoolconnection$poolpreparedstatement.setobject(jdbcpoolconnection.java:1006)     http jvm:  @ com.sun.rowset.internal.cachedrowsetwriter.updateoriginalrow(cachedrowsetwriter.java:495)     http jvm:  @ com.sun.rowset.internal.cachedrowsetwriter.writedata(cachedrowsetwriter.java:355)     http jvm:  @ com.sun.rowset.cachedrowsetimpl.acceptchanges(cachedrowsetimpl.java:875)     http jvm:  @ com.sun.rowset.cachedrowsetimpl.acceptchanges(cachedrowsetimpl.java:934)     http jvm:  @ com.ibm.xsp.extlib.jdbc.model.jdbcrowsetaccessor.acceptchanges(jdbcrowsetaccessor.java:425)     http jvm:  @ sun.reflect.nativemethodaccessorimpl.invoke0(native method)     http jvm:  @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:60)     http jvm:  @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:37)     http jvm:  @ java.lang.reflect.method.invoke(method.java:611)     http jvm:  @ com.ibm.jscript.types.javaaccessobject.call(javaaccessobject.java:321)     http jvm:  @ com.ibm.jscript.types.fbsobject.call(fbsobject.java:161)     http jvm:  @ com.ibm.jscript.asttree.astcall.interpret(astcall.java:175)     http jvm:  @ com.ibm.jscript.asttree.astprogram.interpret(astprogram.java:119)     http jvm:  @ com.ibm.jscript.asttree.astprogram.interpretex(astprogram.java:139)     http jvm:  @ com.ibm.jscript.jsexpression._interpretexpression(jsexpression.java:435)     http jvm:  @ com.ibm.jscript.jsexpression.access$1(jsexpression.java:424)     http jvm:  @ com.ibm.jscript.jsexpression$2.run(jsexpression.java:414)     http jvm:  @ java.security.accesscontroller.doprivileged(accesscontroller.java:284)     http jvm:  @ com.ibm.jscript.jsexpression.interpretexpression(jsexpression.java:410)     http jvm:  @ com.ibm.jscript.jsexpression.evaluatevalue(jsexpression.java:251)     http jvm:  @ com.ibm.jscript.jsexpression.evaluatevalue(jsexpression.java:234)     http jvm:  @ com.ibm.xsp.javascript.javascriptinterpreter.interpret(javascriptinterpreter.java:221)     http jvm:  @ com.ibm.xsp.binding.javascript.javascriptmethodbinding.invoke(javascriptmethodbinding.java:111)     http jvm:  @ com.ibm.xsp.application.actionlistenerimpl.processaction(actionlistenerimpl.java:60)     http jvm:  @ javax.faces.component.uicommand.broadcast(uicommand.java:324)     http jvm:  @ com.ibm.xsp.component.uieventhandler.broadcast(uieventhandler.java:366)     http jvm:  @ com.ibm.xsp.component.uidatapanelbase.broadcast(uidatapanelbase.java:400)     http jvm:  @ com.ibm.xsp.extlib.component.layout.uivarpublisherbase.broadcast(uivarpublisherbase.java:183)     http jvm:  @ com.ibm.xsp.component.uidatapanelbase.broadcast(uidatapanelbase.java:400)     http jvm:  @ com.ibm.xsp.component.uiviewrootex.broadcast(uiviewrootex.java:1535)     http jvm:  @ javax.faces.component.uiviewroot.broadcastevents(uiviewroot.java:307)     http jvm:  @ javax.faces.component.uiviewroot.processapplication(uiviewroot.java:428)     http jvm:  @ com.sun.faces.lifecycle.invokeapplicationphase.execute(invokeapplicationphase.java:94)     http jvm:  @ com.sun.faces.lifecycle.lifecycleimpl.phase(lifecycleimpl.java:210)     http jvm:  @ com.sun.faces.lifecycle.lifecycleimpl.execute(lifecycleimpl.java:96)     http jvm:  @ com.ibm.xsp.controller.facescontrollerimpl.execute(facescontrollerimpl.java:250)     http jvm:  @ com.ibm.xsp.webapp.facesservlet.serviceview(facesservlet.java:223)     http jvm:  @ com.ibm.xsp.webapp.facesservletex.serviceview(facesservletex.java:204)     http jvm:  @ com.ibm.xsp.webapp.facesservlet.service(facesservlet.java:160)     http jvm:  @ com.ibm.xsp.webapp.facesservletex.service(facesservletex.java:138)     http jvm:  @ com.ibm.xsp.webapp.designerfacesservlet.service(designerfacesservlet.java:103)     http jvm:  @ com.ibm.designer.runtime.domino.adapter.componentmodule.invokeservlet(componentmodule.java:583)     http jvm:  @ com.ibm.domino.xsp.module.nsf.nsfcomponentmodule.invokeservlet(nsfcomponentmodule.java:1281)     http jvm:  @ com.ibm.designer.runtime.domino.adapter.componentmodule$adapterinvoker.invokeservlet(componentmodule.java:854)     http jvm:  @ com.ibm.designer.runtime.domino.adapter.componentmodule$servletinvoker.doservice(componentmodule.java:803)     http jvm:  @ com.ibm.designer.runtime.domino.adapter.componentmodule.doservice(componentmodule.java:572)     http jvm:  @ com.ibm.domino.xsp.module.nsf.nsfcomponentmodule.doservice(nsfcomponentmodule.java:1265)     http jvm:  @ com.ibm.domino.xsp.module.nsf.nsfservice.doserviceinternal(nsfservice.java:658)     http jvm:  @ com.ibm.domino.xsp.module.nsf.nsfservice.doservice(nsfservice.java:481)     http jvm:  @ com.ibm.designer.runtime.domino.adapter.lcdenvironment.doservice(lcdenvironment.java:341)     http jvm:  @ com.ibm.designer.runtime.domino.adapter.lcdenvironment.service(lcdenvironment.java:297)     http jvm:  @ com.ibm.domino.xsp.bridge.             http.engine.xspcmdmanager.service(xspcmdmanager.java:272)