Hi,

Try this in your file "repository_user_hsql.xml":

conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi
eldConversion "

in the <field-descriptor> block.


Laurent

-----Original Message-----
From: Stefan Schl�sser [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 10, 2003 16:21
To: oJB Users List
Subject: HSQL Timestamp sql exception illegal format

Hi,

when a try insert something into a HSQL DB with a timestamp I get a

java.sql.SQLException: Wrong data type: Timestamp format must be yyyy-
mm-dd hh:mm:ss.fffffffff

Swifting through the docs brought mew to the conclusion that my 
timestamp is declared as a java.util.date in the object to be stored 
and HSQL seems to expect a java.sql.Date object.

Is there a way to let ojb handle this, or do I need to write a 
specialised repository_user_hsql.xml to contain hsql specific 
conversion routines?

My coding works fine when connecting to a SAPDB.

What to do ?

Cheers,
  Stefan


---------------------------------------------------------------------
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]

Reply via email to