[
https://issues.apache.org/jira/browse/OFBIZ-1001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David E. Jones reassigned OFBIZ-1001:
-------------------------------------
Assignee: David E. Jones
> Oracle Database Date Query Problems
> -----------------------------------
>
> Key: OFBIZ-1001
> URL: https://issues.apache.org/jira/browse/OFBIZ-1001
> Project: OFBiz (The Open for Business Project)
> Issue Type: Wish
> Components: framework
> Environment: SUSE Linux 10 & Oracle DB
> Reporter: Michael Imhof
> Assigned To: David E. Jones
> Priority: Minor
> Attachments: oraclePatch.txt
>
>
> Problem with the date conversion.
> The Following SQL Statement is not working on a Oracle Database
> SELECT .... WHERE RUN_TIME <= '2007-05-15 07:45:10.875' AND ....
> Using an Oracle database, this statement is wrong and generates the ORA-01861
> error.
> The statement should look like this:
> SELECT .... WHERE RUN_TIME <= TO_DATE('2007-05-15 07:45:10',
> 'YYYY-MM-DD HH:MI:SS') AND ....
> Solutions
> =======
> 1. Use Oracle Trigger: http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle
> 2. Set Oracle Date Format: ALTER SYSTEM set NLS_TIMESTAMP_FORMAT='RRRR-MM-DD
> HH24:MI:SS.FF'
> 3. This patch.
> The patch is a general solutions based on the design hibernate is using.
> (Every driver has a Dialect class).
> All databases are working like before because the default implementation is
> just returning the input string (only
> for oracle databases, a special string is returned).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
