Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

sql exception  RSS feed

Sam Venkata
Ranch Hand
Posts: 68
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have the following exception

java.sql.SQLException: [Microsoft][ODBC Excel Driver]Invalid character value for cast specification on column number 61 (NXT_PAR_CALL_DT)
at sun.jdbc.odbc.JdbcOdbc.createSQLException(
at sun.jdbc.odbc.JdbcOdbc.standardError(
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataStringDate(
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataStringDate(
at sun.jdbc.odbc.JdbcOdbcResultSet.getDate(
at xlIE.XlRdWr.getConnXl(
at xlIE.XlRdWr.main(

I am sure the data type of the column NXT_PAR_CALL_DT in the excel sheet is DATE.
Can any body explain me why this error is caused?

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!