JDBC data source adaptor not working
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<1352274429294></P>
<P> Error Message: Cannot find node <instance('instanceOfmodel2')/./ListBox1> 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"?>
<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
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 105 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management