Hi,
hmmm strange, this is what we do, too - and it works.
We use something like this:
- ojb rc3
- jdbc driver: oracle.jdbc.driver.OracleDriver with THIN driver option
- Oracle 8.1.6/8.1.7
- <field-descriptor
name="runDate"
column="JHI_RUN_DATE"
jdbc-type="DATE"
/>
- java.sql.Date in the class
Is the table created correctly, do the column lists of the class and the table match
correctly?
Maybe a p6spy output of your sql statement gives more information of what is really
happening.
Sorry, if my reply may not be very helpful.
Regards
Max
> -----Urspr�ngliche Nachricht-----
> Von: Durham David Contr 805 CSS/SCBE
> [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 31. Juli 2003 17:36
> An: [EMAIL PROTECTED]
> Betreff: Oracle and Date field
>
>
>
> I'm trying to store a java.sql.Date field into an Oracle Date column.
>
> I receive the following error:
> java.sql.SQLException: ORA-00932: inconsistent datatypes
>
>
> It seems strange to have to create a FieldConversion for a Date.
>
> Can someone that has worked through this give me some info about this?
>
> Thanks,
>
> Dave
>
>
>
>
>
>
>
>
> David Durham
> NCI Information Systems
> Scott AFB, AMC SCBE
> 618.256.5264
>
> ---------------------------------------------------------------------
> 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]
