Forum Stats

  • 3,826,852 Users
  • 2,260,713 Discussions
  • 7,897,101 Comments

Discussions

File adapter Read operation not working.

1041453
1041453 Member Posts: 14
edited Nov 8, 2013 8:36AM in Integration - Adapters


Hi All,

I have a simple file adapter which will read from a csv file and insert into a table. I have deployed the application successfully, but the application is not reading from the specific location. I am not getting any error in the EM console. Below is the XSD that I used.

<?xml version="1.0" encoding="UTF-8" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
            xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd"
            xmlns:tns="http://TargetNamespace.com/InboundService"
            targetNamespace="http://TargetNamespace.com/InboundService"
            elementFormDefault="qualified"
            attributeFormDefault="unqualified"

            nxsd:version="NXSD"
            nxsd:stream="chars"
            nxsd:encoding="US-ASCII"
>

  <xsd:element name="Root-Element">
    <xsd:complexType>
      <xsd:choice minOccurs="1" maxOccurs="unbounded" nxsd:choiceCondition="terminated" nxsd:terminatedBy=",">
        <xsd:element name="Student" nxsd:conditionValue="R">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="Roll" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy="," nxsd:quotedBy="&quot;" />
              <xsd:element name="Name" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="," nxsd:quotedBy="&quot;" />
              <xsd:element name="Flag" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="&quot;" />
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:choice>
    </xsd:complexType>
  </xsd:element>

This is the file that I want to read:

5,Ram,N

6,Shyam,N

Please help friends.

Tagged:

Answers

This discussion has been closed.