File to JDBC

[Former Member]

Hi,

I am doing File to jdbc . i am getting a error message like --> Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TEST_EMP' (structure 'STATEMENTNAME'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ')'.

How can i fix this proble. where i made a mistake. please let me know.

Thank you

Regards

Sundher sam

[Former Member · Accepted solution]

Is the stored procedure that you are trying to invoke a working one ? without any syntax errors ?

Thanks,

Renjith

[Former Member · Accepted solution]

Hi Ranjit,

This is not stored procedure. i am loading data in to Table TEST_EMP is table name.

source structure is :

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

<ns0:MT_SOURCE_JDBC xmlns:ns0="http://test8.com">

<EMPNO>4</EMPNO>

<EMPNAME>sam</EMPNAME>

<SALERY>6000</SALERY>

<DEPT>hr</DEPT>

<FLAG>y</FLAG>

</ns0:MT_SOURCE_JDBC>

Target structure is-->

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

<ns0:MT_TARGET_JDBC xmlns:ns0="http://test8.com">

<STATEMENTNAME>

<TEST ACTION="INSERT">

<TABLE>TEST_EMP</TABLE>

</TEST>

<ACCESS>

<EMPNO>4</EMPNO>

<EMPNAME>sam</EMPNAME>

<SALERY>6000</SALERY>

<DEPT>hr</DEPT>

<FLAG>y</FLAG>

</ACCESS>

</STATEMENTNAME>

</ns0:MT_TARGET_JDBC>

please help me where i made mistake.

Advanced thanks

Regards

Sundher

[Former Member · Accepted solution]

Your target xml should be like this...

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

<ns0:MT_TARGET_JDBC xmlns:ns0="http://test8.com">

<STATEMENTNAME>

<TEST ACTION="INSERT">

<TABLE>TEST_EMP</TABLE>

-

---

moved down

<ACCESS>

<EMPNO>4</EMPNO>

<EMPNAME>sam</EMPNAME>

<SALERY>6000</SALERY>

<DEPT>hr</DEPT>

<FLAG>y</FLAG>

</ACCESS>

--- </TEST> --- see the change

</STATEMENTNAME>

</ns0:MT_TARGET_JDBC>

The access node should be a child node of the node where "ACTION" attribute is specified...

Thanks,

Renjith

Message was edited by:

Renjith Andrews

[Former Member · Accepted solution]

Hi Renjith,

Thank you

Regards

Sundher

[Former Member · Accepted solution]

No Problem...Hope the Issue was solved...

If yes, please mark the thread as closed.

Thanks,

Renjith

Message was edited by:

Renjith Andrews