One Star

Insert xml into a record of an sql server table

Hello,
I would like to now how to introduce an xml into a record of one table in one db based on SQL Server.
I made the job I've attached, but it doesn't work. I don't know what I am doing wrong.
Could you help me?
Thank you.
9 REPLIES
One Star

Re: Insert xml into a record of an sql server table

Hi
Please show us the error log you got.
Regards,
Pedro
One Star

Re: Insert xml into a record of an sql server table

Sure. I'l send you some images:
- txmlmap configuration
- compilation error
The execution log says:
Inizio job tXmlMap_multipleLoop: 09:59 25/07/2012.
Exception in thread "main" java.lang.Error: Problema di compilazione non risolto:
Il metodo setDocument(int, Document) non è definito per il tipo PreparedStatement
at primoprogetto.txmlmap_multipleloop_0_1.tXmlMap_multipleLoop.tFixedFlowInput_1Process(tXmlMap_multipleLoop.java:1467)
at primoprogetto.txmlmap_multipleloop_0_1.tXmlMap_multipleLoop.runJobInTOS(tXmlMap_multipleLoop.java:2300)
at primoprogetto.txmlmap_multipleloop_0_1.tXmlMap_multipleLoop.main(tXmlMap_multipleLoop.java:2168)
connecting to socket on port 3504
connected
Regards.
Francisco.
One Star

Re: Insert xml into a record of an sql server table

Hi Francisco
What's the setting of tMSSQLOutput?
Which version of TOS?
Where do you use setDocument(int, Document) method?
Regards,
Pedro
One Star

Re: Insert xml into a record of an sql server table

Sorry the two images were not uploaded. I am sending then again.
Regards.
One Star

Re: Insert xml into a record of an sql server table

Here the settings for txmlmap
Thankyou.
One Star

Re: Insert xml into a record of an sql server table

Sorry, my versione is TOS 5.1.1
Regards.
Francisco
One Star

Re: Insert xml into a record of an sql server table

Hi
Could you send me an email and attach your export job?
I cannot find the root reason in these images.
Sorry.
Regards,
Pedro
One Star

Re: Insert xml into a record of an sql server table

Hi
I have sent you an email to xhuo@talend.com
I deactivated the two last component (the job doesn't compile) to complete the export job.
Regards.
Francisco.
One Star

Re: Insert xml into a record of an sql server table

Were you able to resolve this - I'm having the same problem.