You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by "JML (Brujula)" <jm...@brujulatelecom.com> on 2005/06/29 10:19:46 UTC
Problem with Oracle10g
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
Re: Problem with Oracle10g
Posted by "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
Re: Problem with Oracle10g
Posted by Ilkka Priha <im...@surfeu.fi>.
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