JDBC Connection

[Former Member]

Hi All,

I m trying to connect to sap database but i m facing some error regarding XML ....

error:-Error while parsing or executing XML-SQL document: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

pls let me know what is the provlem..

Thanks

[Former Member]

Hi

I think there is problem in the structure of the XML.Kindly check it once

[Former Member]

Hi,

JDBC ADAPTER

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

Regards,

Phani

[nisarkhan_n]

you are trying to connect SAP & databse or SAP databse?

you are missing action attribuite in your strucutre

check this links:

check this for more:

http://help.sap.com/saphelp_nw70/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

But the structure for receiver JDBC data type must have a fixed schema i.e. we have to pass the table name in that otherwise it will trough an error

check this:

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

[Former Member]

clearly you have failed to specify value for the action attribute in the receiver message type in ID...

kind regards

krishna

[former_member240483]

In your rec structure check the attribute ..whether you want to insert update etc..

[Former Member]

Hi,

I think in your receiver JDBC structure you haven't defined any thing for Action field

Try to follow this structure

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Regards

Seshagiri