File to JDBC :Error when executing statement for table/stored proc.

Hi,

I am getting following error when i am trying to insert data into z-table using JDBC recr adapter.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'ZTEST' (structure 'STATEMENT'): java.sql.SQLException: <u>[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name '<b>ZTEST</b>'.</u>

But the database table name 'ZTEST' exists in the system.

XML structure:

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

<ns0:MT_RECR xmlns:ns0="http://urn:srini/FileToJDBC">

<STATEMENT>

<TEST action="INSERT">

<table>ZTEST</table>

<access>

<ROLLNO>123</ROLLNO>

<FIRSTNAME>ABC</FIRSTNAME>

<LASTNAME>XYZ</LASTNAME>

</access>

</TEST>

</STATEMENT>

</ns0:MT_RECR>

Regards,

Srinivas