I am trying to perform batch processing of SQL Insert to a SQL server 2008 database and for this I am using an adaptor object and a transformer. PFLOW goes like this:

Start >> SQL Object >> Transformer >> Adaptor >> End

SQL Object working fine and generating correct XML output. Transformer test run is also OK. But when all together in PFLOW I get the following error:

"
XD[FAIL] cause: 0 subcause: 0 message: getMessage(): Missing location int getError(): Server getAdapterCode(): null getVendorThrowable(): com.ibi.rdbms.exceptions.RDBMSException: Missing location
"

Transformer Configuration:


Can somebody guide me in getting this resolved

Thanks..

a) It appears based on teh error message that you are obtained is that you used the rdbms adapter not the sql object
b) What release of iWay are your running. I recommend that you look at the SQL iterator that will easily allow you to loop through an batch of records.

Naomi Klamen
iWay Product Management