One option might be to put this in, but commented out so it is just an example
in a comment. There is at least one other comment with example code for Oracle
in the entity engine, though I can't remember where it is right now.
-David
On Dec 6, 2009, at 5:04 AM, Jacopo Cappellato wrote:
> For the record, I have finally fixed it by adding the following two
> converters:
>
> public static class OracleTIMESTAMPToTimestamp extends
> AbstractConverter<oracle.sql.TIMESTAMP, java.sql.Timestamp> {
> public OracleTIMESTAMPToTimestamp() {
> super(oracle.sql.TIMESTAMP.class, java.sql.Timestamp.class);
> }
> public java.sql.Timestamp convert(oracle.sql.TIMESTAMP obj) throws
> ConversionException {
> try {
> return obj.timestampValue();
> } catch (Exception e) {
> throw new ConversionException(e);
> }
> }
> }
>
> public static class SqlDateToTime extends AbstractConverter<java.sql.Date,
> java.sql.Time> {
> public SqlDateToTime() {
> super(java.sql.Date.class, java.sql.Time.class);
> }
> public java.sql.Time convert(java.sql.Date obj) throws
> ConversionException {
> return new java.sql.Time(obj.getTime());
> }
> }
>
> However it is a bit annoying since it was working before... also I don't know
> if (and how) this code can be contributed back: the first converter needs the
> oracle driver in the classpath to compile.
>
> Jacopo
>
>
> On Dec 5, 2009, at 9:26 PM, Ruth Hoffman wrote:
>
>> Hi Jacopo:
>> Don't know about the converter framework...I seem to remember that Oracle
>> changed the name of the SQL TIMESTAMP object for more recent versions (9x or
>> 10i or something like that). So maybe the OFBiz converter is looking for the
>> TIMESTAMP object in the wrong place or calling it by a name that doesn't
>> exist anymore. I may have had to change the converter as well. Or maybe I'm
>> just confusing all this with the Oracle CLOB modifications I had to make...
>>
>> It was a while ago when I ran into this. Anyhow, I do seem to recall there
>> was some discussion about this on the Oracle developer's forum at the time.
>>
>> Regards,
>> Ruth
>> Jacopo Cappellato wrote:
>>> Thank you Ruth, I will investigate more but... but my guess is that this
>>> error is related to the recent changes for the Converter framework... in
>>> fact this error is happening after the OFBiz upgrade to the trunk.
>>>
>>> Jacopo
>>>
>>> On Dec 5, 2009, at 7:59 PM, Ruth Hoffman wrote:
>>>
>>>
>>>> Hey Jacopo:
>>>> I had a similar problem about 9 months ago...depends on the version of
>>>> Oracle. But if I remember correctly, you may need to find an Oracle jar
>>>> file that supports the TIMESTAMP object and add it to the classpath.
>>>>
>>>> I don't have access to that OFBiz instance anymore so I can't verify what
>>>> I did...but I think that was the solution. FYI - there was a similar
>>>> problem with ORACLE CLOBs.
>>>>
>>>> Anyhow, hope that helps.
>>>> Ruth
>>>>
>>>> Jacopo Cappellato wrote:
>>>>
>>>>> I am getting the following error trying to load seed data in the trunk
>>>>> using an Oracle DB.
>>>>>
>>>>> ------------
>>>>> [java] Exception: java.lang.ClassNotFoundException
>>>>> [java] Message: No converter found for
>>>>> oracle.sql.TIMESTAMP->java.sql.Timestamp
>>>>>
>>>>>
>>>>> Any hints on how to fix this?
>>>>>
>>>>> Jacopo
>>>>>
>>>>>
>>>>>
>>>
>>>
>>>
>
