Error in inserting data into Database from CSV

Anonymous — Wed, 28 Mar 2018 12:59:23 GMT

Hi,

I'm trying to load data from csv to database. But its showing below error.

java.sql.SQLException: syntax error, unexpected STYLE_, expecting identifier_chain2 or OFFSET_ [line 1, column 303] (Session: 1596182455914086215)
at com.exasol.jdbc.ExceptionFactory.createSQLException(ExceptionFactory.java:164)
at com.exasol.jdbc.ExceptionFactory.createSQLException(ExceptionFactory.java:21)
at com.exasol.jdbc.AbstractEXAPreparedStatement.<init>(AbstractEXAPreparedStatement.java:62)
at com.exasol.jdbc.AbstractEXAPreparedStatement_14.<init>(AbstractEXAPreparedStatement_14.java:14)
at com.exasol.jdbc.EXAPreparedStatement.<init>(EXAPreparedStatement.java:12)
at com.exasol.jdbc.DialectGeneric.createPreparedStatement(DialectGeneric.java:10)
at com.exasol.jdbc.AbstractEXAConnection.prepareStatement(AbstractEXAConnection.java:578)

According to error, I have removed all "," from data as well, still same error. Even If I remove all data except metadata it shows same error.

May I know what could be the reason...>

Re: Error in inserting data into Database from CSV

Anonymous — Thu, 29 Mar 2018 03:49:17 GMT

Any Suggestion please...?

Re: Error in inserting data into Database from CSV

Anonymous — Fri, 30 Mar 2018 08:41:34 GMT

Hello,

What's your DB version you are using? Is DB connection OK with you? Could you please post your trouble screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

topic Re: Error in inserting data into Database from CSV in Talend Studio

Error in inserting data into Database from CSV

Re: Error in inserting data into Database from CSV

Re: Error in inserting data into Database from CSV