topic Re: Insert xml into a record of an sql server table in Talend Studio

Insert xml into a record of an sql server table

Anonymous — Tue, 24 Jul 2012 12:44:30 GMT

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.

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

Anonymous — Wed, 25 Jul 2012 02:37:21 GMT

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

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

Anonymous — Wed, 25 Jul 2012 08:57:18 GMT

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.

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

Anonymous — Wed, 25 Jul 2012 09:03:49 GMT

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

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

Anonymous — Wed, 25 Jul 2012 09:54:11 GMT

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

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

Anonymous — Wed, 25 Jul 2012 09:59:09 GMT

Here the settings for txmlmap
Thankyou.

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

Anonymous — Wed, 25 Jul 2012 10:00:38 GMT

Sorry, my versione is TOS 5.1.1
Regards.
Francisco

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

Anonymous — Wed, 25 Jul 2012 10:01:56 GMT

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

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

Anonymous — Wed, 25 Jul 2012 10:38:19 GMT

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.

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

Anonymous — Tue, 23 Apr 2013 17:34:39 GMT

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