-
1. Re: Oracle Date and JDBC Timestamp
tpearsall Nov 3, 2003 9:07 AM (in response to tpearsall)One correction to the above post:
The OCI drivers throws:
ORA-00932: inconsistent datatypes
during the save while the thing driver throws:
ORA-03115: unsupported network datatype or representation -
2. Re: Oracle Date and JDBC Timestamp
tpearsall Nov 3, 2003 9:07 AM (in response to tpearsall)If only I could type..
One correction to the above post:
The OCI drivers throws:
ORA-00932: inconsistent datatypes
during the save while the THIN driver throws:
ORA-03115: unsupported network datatype or representation -
3. Re: Oracle Date and JDBC Timestamp
tpearsall Nov 4, 2003 7:44 AM (in response to tpearsall)Here is a snippet from my jbosscmp-jdbc.xml that is generated by Xdoclet:
<ejb-name>EventEntity</ejb-name>
<table-name>EVENT</table-name>
<cmp-field>
<field-name>eventId</field-name>
<column-name>EVENT_ID</column-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR</sql-type>
</cmp-field>
.......
<cmp-field>
<field-name>eventEffDateTime</field-name> <column-name>EVENT_EFF_DATE_TIME</column-name>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>
</cmp-field>
...... -
4. Re: Oracle Date and JDBC Timestamp
tpearsall Nov 6, 2003 12:56 PM (in response to tpearsall)With some help form others in different forums, apparently the classes12.zip for Oracle 8.1.7 maps the Oracle DATE time to java.sql.Timestamp, but the ojdbc14.jar and classes12.zip from 9i map Oracle Date to java.sql.Date.
I assume the change is due to Oracle adding the TIMESTAMP data type in 9i, but I'm not sure. It have just been really nice if Oracle renamed the file instead of having at least 2 classes12.zip that have different implemenations.
- Todd -
5. Re: Oracle Date and JDBC Timestamp
lenisha Nov 12, 2003 8:42 PM (in response to tpearsall)Hi guys,
What is the solution for DATE field in Oracle
with OCI8 driver ?
I have this setting in
In jbosscmp-jdbc.xml setting jdbc-type to TIMESTAMP and sql-type=DATE
and error like that
The OCI drivers throws:
ORA-00932: inconsistent datatypes
Does anybody knows how to make it work ?
Thanks a lot -
6. Re: Oracle Date and JDBC Timestamp
hans.noemmer Nov 13, 2003 6:08 AM (in response to tpearsall)I had the same problem, that only the data protion was stored.
It worked, when I defined the abstract getter/setter with the type java.util.Date instead of java.sql.Date.
I am using the default datasource mapping for Oracle8 in jbosscmp-jdbc.xml -
7. Re: Oracle Date and JDBC Timestamp
lenisha Nov 14, 2003 9:27 PM (in response to tpearsall)Hi,
I have this abstract getter/setters and it does not help. What version of JBoss you are using ?
And what classes12.jar ?
Thanks alot.