BatchInsertSQL Exception

, ,
1

Hi,

Is it possible to insert only one record with BatchInsertSQL adapter service? When we tried got the below exception. Any suggestions please?

[ART.114.505] Error while invoking adapter service com.wm.adapter.wmjdbc.services.BatchInsert. com.wm.adk.cci.record.WmRecord cannot be cast to [Lcom.wm.adk.cci.record.WmRecord;

2

Even if it is one record, it should go as a array list, where array[0] holds the first record… I have not tried, but it should work… Are you trying to insert by passing document instead of document list?

Senthil

3

Thanks for the reply senthil. BatchInsertSQL adapter service is working successfully for single record insert. I want to handle both single and Multiple records with one BatchInsertSQL adapter service. For that I am passing document list as input to the adapter service.Its working fine for multiple records insert. When I pass single record as input to this adapter service, got the below BatchInsertSQL exception and it says, document cannot be cast to documentlist. Any inputs?

[ART.114.505] Error while invoking adapter service com.wm.adapter.wmjdbc.services.BatchInsert.
com.wm.adk.cci.record.WmRecord cannot be cast to [Lcom.wm.adk.cci.record.WmRecord;

4

As Senthil noted, you cannot pass a document to the service. You need to pass a list, which can consist of just one entry.

5

If you have single record in input which is supposed to be a list, & if you dont provide a schema or doc type name while using documentToXMLString service, the output will be a single document

If you have single record in input, and if you provide schema or doc type name, the output of will be a document list with array[0]

You have to consider the second way of coding in your case…

HTH
Senthil