Thank you! I have read this document, and I think that the best solution
is to change the sql type from DATE to TIMESTAMP. But, I would like to
find another posible solution that it isn't to change the sql type.
Another idea?
Thank you very much Ilkka for your help!
Ilkka Priha wrote:
See this:
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#08_01
-- Ilkka
JML (Brujula) wrote:
Hi!
I have encountered with a problem when I have changed from Oracle9i
to Oracle10g.
This code work correctly with 9i:
Timestamp tmp = (Timestamp)row[7];
row[7] is a field of a ReportQueryByCriteria from a table with DATE
database type. In repository.xml, I have mapped this field as TIMESTAMP
<field-descriptor id="7" name="dateCreated" column="DATE_CREATED"
jdbc-type="TIMESTAMP"/>
But with Oracle10g, I have obtain a ClassCastException, because
row[7] is a java.sql.Date.
When I execute:
System.out.println("CLASS: " +row[7].getClass());
I obtain,
CLASS: java.sql.Date
Thanks for any ideas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
