Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

sql exception

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?

What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!