Re: ResultSet getDate(TIME_STAMP) returns java.lang.NumberFormatException: For input string:
- From: Lothar Kimmeringer <news200709@xxxxxxxxxxxxxx>
- Date: Tue, 5 Feb 2008 19:38:48 +0100
jaja wrote:
I am working with Oracle 9 , and using the oracle jdbc driver.
There are different JDBC-drivers for Oracle. Make sure that the
driver you're using works with the corresponding database. This
is especially important when using the OCI-driver (but problems
there usually end up with a crash of the process).
Just to be clearer, I need to format the date into my format, and of
course SimpleDateFormat don't recognize the monthe written in
hebrew...
It would if you specify the correct Locale. But before you try
something like that, check if the column is really of type
timestamp/date. You can check the type with
resultset.getMetaData().getColumnType(colIndex).
It should return 91 (java.sql.Types.DATE) or 93
(java.sql.Types.TIMESTAMP). If it's 1, 12, or something
else, likelyhood is big that the value is already stored
in a wrong way inside the database.
Best would be try that out and report back.
Regards, Lothar
--
Lothar Kimmeringer E-Mail: spamfang@xxxxxxxxxxxxxx
PGP-encrypted mails preferred (Key-ID: 0x8BC3CD81)
Always remember: The answer is forty-two, there can only be wrong
questions!
.
- Prev by Date: core java format
- Next by Date: Re: How to insert a string that contains ' or ,
- Previous by thread: core java format
- Next by thread: Re: ResultSet getDate(TIME_STAMP) returns java.lang.NumberFormatException: For input string:
- Index(es):
Relevant Pages
|
|
