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