JDBC data source adaptor not working

yamangoyal
edited November 16, 2012 in Documentum #1

HI All,


 


I am using JDBC data source adaptor to populate the listbox values based on another textbox


 


I am suing below sql query in initial parameter



select doc_type as label, doc_description as value from indus_dms_document_doc_type where doc_description like '%$%'</P>
<P> </P>
<P>Input: vender_name</P>
<P> </P>
<P>This adaptor execute when input value changes.I am getting below error while putting value:</P>
<P> </P>
<P>*****************************************************************</P>
<P>13:17:09,294 ERROR [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] com.documentum.xforms.adaptor -</P>
<P>[Adaptor Error.]</P>
<P>    ID: E&lt;1352274429294&gt;</P>
<P>    Error Message: Cannot find node &lt;instance('instanceOfmodel2')/./ListBox1&gt; in the output document.</P>
<P>    Suggested Action: Contact your administrator to verify the adaptor setup.</P>
<P>    Form Template Name: Testing_ERP</P>
<P>    Form Instance ID: 090030398014c143</P>
<P>    Control: ListBox1</P>
<P>    Adaptor Info:</P>
<P>     - ID: TestingList</P>
<P>     - Implementation: com.documentum.xforms.engine.adaptor.datasource.jdbc.JDBCDataSourceAdaptor</P>
<P>     - Implementation Type: class</P>
<P>     - Init Params: [sql=select doc_type as label, doc_description as value from indus_dms_document_doc_type where doc_description like '%$
%'     - Adaptor Type: datasource


     - Execution Type: onChange


     - Input: [vender_name:type=string,required=true,values=[AOP]]


     - Output Schema:


            <?xml version="1.0" encoding="UTF-8"?>


            &lt;schema xmlns="<A href="http://www.w3.org/2001/XMLSchema%22/" mcehref='http://www.w3.org/2001/XMLSchema"/'>http://www.w3.org/2001/XMLSchema"/>


    Exception: com.documentum.tools.adaptor.AdaptorException: org.chiba.xml.xforms.exception.XFormsComputeException: invalid value expression at [xforms:setvalue


    Stack Trace:


        at com.documentum.xforms.engine.chiba.DynamicModel.buildAdaptorLogging(DynamicModel.java:412)


        at com.documentum.xforms.engine.chiba.action.ExecuteAdaptorAction.perform(ExecuteAdaptorAction.java:165)


        at org.chiba.xml.xforms.action.ActionAction.perform(ActionAction.java:171)

Comments

  • DCTM_Guru
    edited November 16, 2012 #2

    Sounds like your input mapping to your adaptor is incorrect:

    Cannot find node &lt;instance('instanceOfmodel2')/./ListBox1&gt;