Re: Problem with Oracle10g

["JML (Brujula)" <jm...@brujulatelecom.com>]

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: ojb-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org