Hi,
Never mind this question. I was able to fix the problem.
Apparently, the driver being used in the code was HSQL instead of the Oracle
driver, that is why it was not producing the correct query. Sorry for the
trouble.
Thanks,
Brent
From: DEVELA Brent
Sent: Tuesday, September 14, 2010 3:43 PM
To: '[email protected]'
Cc: DEVELA Brent
Subject: Problem with Date DataType format in Oracle
Hi All,
Nice to be here! I am having an issue executing a BaseRecord#.update() method
whenever a DBTable has a DataType.DateTime DBTableColumn in Oracle. The Oracle
database I use only accepts the string format 'dd-MMM-yy hh:mm:ss a' (e.g.
'08-SEP-10 01:55:45 PM') and recognizes it properly. However, the update method
of empire db generates a date format 'yyyy-MM-dd HH:mm:ss.SSS' (e.g. 2010-09-08
13:55:45.0) and this throws an exception. I have no problem reading from the
database but insert/updates currently doesn't work.
Question: How do I change the format of the SQL query generated by empire-db so
that it will match to what is accepted by the Oracle database? I tried changing
the regional settings of my machine (Windows 7) and it still generates the same
format.
Thanks,
Brent
