Thursday, August 23, 2012

OSB import DB JCA: "Invalid Toplink Mapping XML, DB sequence..."

while importing JCA DB adapter into OSB, I got this error:


Multiple annotations found at this line:
- Invalid Toplink Mapping XML. Error Message: Attribute not allowed (no wildcards allowed): table in element sequence-
field@http://www.eclipse.org/eclipselink/xsds/persistence Location of invalid XML: <xml-fragment table="CIS_REQUEST_Q_TBL"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:eclipselink="http://www.eclipse.org/eclipselink/xsds/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
- Start tag of element <adapter-config>

After googling around, I found this post https://forums.oracle.com/forums/thread.jspa?threadID=2311913

So removing the "table" attribute from <sequence-field> took care of the problem:

<sequence-field name="REQ_ID"/>

2 comments:

  1. This happens to me when using the Jdeveloper to create the JCA adapter. The OSB fails to parse the mapping file (maybe for versions issues). Removing the "table" attibute works! Thanks.

    ReplyDelete