Friday, October 11, 2013

Unable to Edit Database/File Adapter in JDev - SOA 11G

Hi All,

There is one issue that lots of people faces while importing an existing SOA project into JDeveloper.For instance, you have a composite that is polling records from DB and writing it into some file. After importing when you try to edit DB or File adapter by double clicking the wizard simply wont open up. Strange isnt it.
Even if you reimport the same project it will still not open.What could be the issue here.

The simple solution or workaround you can say is add the below line in your respective WSDL file of File or DB or JMS adapter(any JCA adapter):
<?binding.jca readFile_file.jca?>

 

where readFile_file.jca is the jca file name of your file adapter. In case of DB Adapters, it would be filename_db.jca and in case of JMS adapter would be filename_jms.jca and hence so on for all other JCA adapters.



Save your WSDL file close it and now double click on your adapter. Bingo its opening now :) Nice isn'it.

Hope this post will help many of you frustrated facing such type of issues.

Happy Learning...

Cheers,
Karan

8 comments:

  1. Thanks for the post, this helps

    ReplyDelete
  2. I tried this and the wizard showed up again, but I'm getting the following error now:

    java.util.InvalidPropertiesFormatException: org.xml.sax.SAXParseException: : XML-20149: (Error) Element 'properties' used but not declared.
    at java.util.XMLUtils.load(XMLUtils.java:59)
    at java.util.Properties.loadFromXML(Properties.java:852)

    ReplyDelete
  3. I figured it out. I exported the composite from the em console and the xml files don't come out of that export with all the necessary dtd references. Had to add this to the polling adapter properties file:

    ReplyDelete
  4. This little thing saved my day , awesome !

    ReplyDelete
  5. I am getting the same error: java.util.InvalidPropertiesFormatException: org.xml.sax.SAXParseException: : XML-20149: (Error)

    Can any one please guide me how to get rid of this error

    ReplyDelete
  6. To avoid

    java.util.InvalidPropertiesFormatException: org.xml.sax.SAXParseException: : XML-20149: (Error) Element 'properties' used but not declared.
    at java.util.XMLUtils.load(XMLUtils.java:59)
    at java.util.Properties.loadFromXML(Properties.java:852)
    Error, do below additional steps

    In the corresponding *-properties.xml file add this

    after
    line

    ReplyDelete