Forums Register Login

sql exception

+Pie Number of slices to send: Send
Hi,
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(JdbcOdbc.java:6998)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7155)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataStringDate(JdbcOdbc.java:4075)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataStringDate(JdbcOdbcResultSet.java:5781)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDate(JdbcOdbcResultSet.java:984)
at xlIE.XlRdWr.getConnXl(XlRdWr.java:106)
at xlIE.XlRdWr.main(XlRdWr.java:29)

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?

Thanks,
samanth.
WARNING! Do not activate jet boots indoors or you will see a tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1268 times.
Similar Threads
Error in row
Newbie problem. JDBC Error
I am lost... Help me please
jdbc error: Invalid Descriptor Index
select works in db, but not across jdbc...
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 02:40:19.