Joe, I haven't posted this to the list because I'm not sure it's entirely relevant to your specific need. What I found I had to do with Oracle TIMESTAMPs to get them to correctly deal with min, hours, secs, etc. was to: A. write my own converter and B. extend the PlatformOracle9iImpl class to make sure I was calling setTIMESTAMP on a OraclePreparedStatement (in setObjectForStatement).
All this was with the vanilla rc5 release. If you think this would help, I can post you the code. I had a post on the OJB-DEV list about this and Armin (I think) suggested I post tests and a fix. Unfortunately I haven't had time to do this. Hoping this may help, Brendan ----- Original Message ----- From: "Joe Germuska" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Cc: "Brad Matlack" <[EMAIL PROTECTED]> Sent: Friday, February 20, 2004 10:41 AM Subject: Re: Oracle date tip > At 6:02 PM -0500 2/19/04, Andy Malakov wrote: > >Brad, > > > >I do not think it is OJB/JDBC problem. > > > >What is strange about your mail is the fact that NLS_DATE_FORMAT > >fixed the problem - instead of NLS_TIMESTAMP_FORMAT. Since you > >applied JavaDate2SqlTimes converter - all your dates at JDBC level > >should have been converted to java.sql.Timestamp. > > > >Please do not be confused by the way P6SPY displays generated JDBC > >query (it may be approximate). > > Oracle doesn't have a TIMESTAMP type; its "DATE" encompasses SQL > TIME, TIMESTAMP, and DATE. > > Joe > -- > Joe Germuska > [EMAIL PROTECTED] > http://blog.germuska.com > "Imagine if every Thursday your shoes exploded if you tied them > the usual way. This happens to us all the time with computers, and > nobody thinks of complaining." > -- Jef Raskin > > --------------------------------------------------------------------- > 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]
