topic Re: Insert data with jdbc Phoenix Query server in Talend Studio

Insert data with jdbc Phoenix Query server

NiSaumande — Sat, 16 Nov 2024 01:01:03 GMT

Hello,

Has anybody succeded in inserting data with a tDBOutput using the jdbc driver of Phoenix Query Server ?

I can select data with a tDBInput, but I always get this error when using the tDBOutput :

org.talend.components.api.exception.ComponentException: UNEXPECTED_EXCEPTION:{message=Error -1 (00000) : while preparing SQL: INSERT INTO WEB_STAT (Host,Domain,Feature,Date,Core,DB,Active_visitor) VALUES (?,?,?,?,?,?,?)}

at org.talend.components.jdbc.CommonUtils.newComponentException(CommonUtils.java:583)

at org.talend.components.jdbc.runtime.writer.JDBCOutputInsertWriter.open(JDBCOutputInsertWriter.java:49)

at esb_demo.testphoenix_0_1.testPhoenix.tFileInputDelimited_2Process(testPhoenix.java:917)

at esb_demo.testphoenix_0_1.testPhoenix.runJobInTOS(testPhoenix.java:3103)

at esb_demo.testphoenix_0_1.testPhoenix.main(testPhoenix.java:2939)

I'm using this driver : phoenix-queryserver-client-5.0.0.7.2.0.2-2.jar

Thank you,

Nicolas

Re: Insert data with jdbc Phoenix Query server

Anonymous — Fri, 04 Dec 2020 07:04:26 GMT

Hello,

Could you please clarify in which Talend version/edition you are?

Best regards

Sabrina

Re: Insert data with jdbc Phoenix Query server

NiSaumande — Fri, 04 Dec 2020 07:10:55 GMT

Hello,

I'm using TOS ESB 7.3.1

Thank you,

Nicolas

Re: Insert data with jdbc Phoenix Query server

Anonymous — Mon, 07 Dec 2020 07:18:56 GMT

Hello,

Could you please create a workitem jira issue on talend bug tracker?

Our developers will check this issue to see if it is possible to insert data with a tDBOutput using the jdbc driver of Phoenix Query Server.

Best regards

Sabrina