Five Stars

Error in inserting data into Database from CSV




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(
at com.exasol.jdbc.ExceptionFactory.createSQLException(
at com.exasol.jdbc.AbstractEXAPreparedStatement.<init>(
at com.exasol.jdbc.AbstractEXAPreparedStatement_14.<init>(
at com.exasol.jdbc.EXAPreparedStatement.<init>(
at com.exasol.jdbc.DialectGeneric.createPreparedStatement(
at com.exasol.jdbc.AbstractEXAConnection.prepareStatement(


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...>

Five Stars

Re: Error in inserting data into Database from CSV

Any Suggestion please...?


Re: Error in inserting data into Database from CSV


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


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.