XSLT Transformation file Design View not opening in Jdeveloper

Problem :

                 Design View XSLT transformation file(.xsl) not showing/opening.

Cause :
              Probably,It happens when you export Project from em console and import it in Jdeveloper.
               which removes oracle-xsl-mapper tag which contains mapSources and mapTargets.

Solution :
             Try to add manually  <?oracle-xsl-mapper>  tag after xml start tag and above stylshhet tag with                                   corresponding mapSources and mapTargets.

Sample Oracle-xsl-mapper :  which generates in xsl file when you create first time in jdev.

<?oracle-xsl-mapper

   <mapSources>

    <source type="WSDL">

      <schema location="../sourceWsdlName.wsdl"/>

      <rootElement name="sourceRootElement" namespace="sourceWsdlNamespace"/>

    </source>

  </mapSources>

  <mapTargets>

    <target type="WSDL">

      <schema location="targetWsdlLocation"/>

      <rootElement name="targetRootElement" namespace="targetNamespace/"/>

    </target>

  </mapTargets>

 ?>

               

Add the above code to your xsl file above stylesheet tag and do changes accordingly to your source and target as mentioned in Bold.

Please refer below screens shots  :

Unable to edit DB/File Adapter in JDeveloper

Problem :
                Unable to Edit DB/File Adapter in JDEV

Cause :
             It happens when you export Project from em console and import it in Jdeveloper .

Solution :

• For File Adapter : 

                             Add  <?binding.jca jcafilename_file.jca?>  in corresponding wsdl below

                            <?xml version= '1.0' encoding= 'UTF-8' ?> tag generated when creating file adapter.

• For DB Adapter :

                            Add  <?binding.jca jcafilename_db.jca?>  in corresponding wsdl below

                          <?xml version= '1.0' encoding= 'UTF-8' ?> tag  generated when creating DB adapter.

In case of DB Adapter Polling(Inbound), if you add <?binding.jca jcafilename_db.jca?>  tag and edit the db adapter then it is editable but with some error like below :

This error gives when you use Polling db records, in this case db adapter creates mapping and property files.

To overcome this issue you need to add below line in your properties.xml file above properties tag.

<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">