Hi everyone here:
I am testing built-in adaptor jdbc adaptor with Forms Builder 5.3 sp4. the following is my config:
<xs:complexType name="userList">
<xs:sequence>
<xs:element maxOccurs="unbounded" name="item">
<xs:complexType>
<xs:sequence>
<xs:element name="uname" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
<datasource description="User list" id="userList"
implementation="com.documentum.xforms.engine.adaptor.datasource.jdbc.JDBCDataSourceAdaptor" type="class">
<init-param>
<name><![CDATA[sql]]></name>
<value><![CDATA[select user_name as uname from dmadmin.dm_user_s]]></value>
</init-param>
<output type="jns:userList"/>
</datasource>
jdbc_userList.properties
url=jdbc:oracle:thin:@192.168.1.130:1521:ORACLE
driver=oracle.jdbc.driver.OracleDriver
user=dmadmin
password=123456
---------------------------------------------
I have done:
1. put jdbc_userList.properties under da\WEB-INF\classes
2. put oracle JDBC driver (class12.jar) under c:\Program Files\Documentum\Shared
I use this adaptor as a drop-down list box's external data source. When I create this form in DA, there is nothing in drop-down list box the following error message shows:
No value for xpath: /userList/item/unameNo value for xpath: /userList/item/uname
or
Exception trying to create xpath /userList/item; HIERARCHY_REQUEST_ERR: An attempt was made to insert a node where it is not permitted. Exception trying to create xpath /userList/user; HIERARCHY_REQUEST_ERR: An attempt was made to insert a node where it is not permitted.
screenshot:
The drop down list box's data model is a data item.
Do someone know what's the problem?
thanks in advanced.
