I've built and application that converts some data from a MS Sql database to a Oracle database (8i). I basically search against the sql server database and then take the resultant objects and copy fields over the Oracle representation of the data and then store it to the Oracle database. For the most part this seems to be working just fine, except that some dates are getting goofy. I've listed the dates in my log, both in the sql server objects and the Oracle object, both appear to be fine. However when I retreive the stored data from the Oracle database I'm getting a date that is clearly incorrect. The dates where something like '2005-05-03' but what's stored in the Oracle database is '1969-12-31'.
Is anyone aware of any behaviours with OJB, sql server or Oracle that would explain this? And which of the classes do I need to turn debugging up for in order to see the fields which are being set? I can see the sql, but I don't know what's being put into the prepared statement. I've managed to get debugging set to display fields for select statements, but inserts are eluding me at this point. --mikej -=----- mike jackson [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
