What are the Operations in MQ Adapter?

Below are the operations in MQ Adapters.
1. Put Message into MQ
  Operation Name: Enqueue
2. Get Message from MQ
  Operation Name: Dequeue
3. Send Message to MQ and Get Reply/Reports
     Send Operation Name: Enqueue
     Get Operation Name: Dequeue
4. Get Message from MQ and Send Reply/Reports
        Asynchronous:
          Send Operation Name: Enqueue
          Get Operation Name: Dequeue
        Synchronous:
          Operation Name: DequeueEnqueue

What are the Operation Types in AQ Adapter?

Operation Types in AQ Adapter:
 1) Dequeue
 2) Enqueue

What are the file types and operation types in FTP Adapter?

File Types in FTP Adapter Configurations:
 1) Ascii
 2) Binary
Operation Types in FTP Adapter Configurations:
1) Get File
2) Put File
3) Synchronous Get File

What are the operation types in File Adapter Configuration?

Operation Types in File Adapter:
1) Read File
2) Write File
3) Synchronous Read File

What are the operations in DB Adapter Configuration?

Operation Types in DB Adapter:
1. Call a Stored Procedure or Function
2. Perform an Operation on a Table
       i) Insert or Update (Merge)
      ii) Insert Only
      iii) Update Only
      iv)  Delete
     v) Select
3. Poll for New or Changed Records in a Table
4. Execute Custom SQL

Basic and important Questions on SOA Deployment.

1). How to deploy your composite into your SOA server?

2). How many ways we can deploy your composite into soa server?

3). How to deploy your composite one environment to another environment?

4). what is ANT Scripts. What it’s contains?

: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 [Caused by: ORA-01403: no data found issue in Database Adapter

ERROR:
file:/u01/app/oracle/product/10.1.3/bpel/domains/xl/tmp/.bpel_CreateManifest_1.0_b4e96c3ac640a4edb6c0fd2ca0c8156a.tmp/CreateManifestDetailsInODS.wsdl [ CreateManifestDetailsInODS_ptt::CreateManifestDetailsInODS(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'CreateManifestDetailsInODS' failed due to: Error while converting to a Java struct object.Unable to convert the XSD element PI_MANIFEST_REC whose user defined type is ODS.XX_ODS_MANIFEST_REC. Cause: java.sql.SQLException: ORA-01403: no data foundORA-06512: at line 1
[Caused by: ORA-01403: no data found

ORA-06512: at line 1

]

; nested exception is: 

                    ORABPEL-11802

Error while converting to a Java struct object.

Unable to convert the XSD element PI_MANIFEST_REC whose user defined type is 

ODS.XX_ODS_MANIFEST_REC. Cause: java.sql.SQLException: ORA-01403:

 no data found ORA-06512: at line 1

 [Caused by: ORA-01403: no data found

ORA-06512: at line 1

]

 Solution:

 I have I tried below to resolve the issue.

 1. One thing surprised me that the same code working in other environments 

     but not working only one environment i.e SIT.

 2. Initially I thought some thing going wrong in package..Record structure…

    that may be different from other environments but …I have verified package …

    after analyzing code I found that is not the reason for this error…

    package looks fine..

3. I have created one DB adapter against SIT DB and deployed it works fine…

   But this is not my final goal my old code should work in SIT also because this 

   is working in all environments and I should not develop code 

   for each environment one version.

4. Later I compared XSDs of both SIT and others I found DB user is the problem…

 For example XX_ODS_MANIFEST_REC is the record type in DB.

 ODS.XX_ODS_MANIFEST_REC àin BPEL XSD

 But the SIT user ID is some thing like SITODS so XSD should have 

SITODS.XX_ODS_MANIFEST_REC but current XSD have only 

ODS.XX_ODS_MANIFEST_REC due to that we are facing above error.

5. I have changed XSD and deployed it works fine …J