Insert data with jdbc Phoenix Query server

[NiSaumande]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[NiSaumande]

Hello,

I'm using TOS ESB 7.3.1

Thank you,

Nicolas

[Anonymous]

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