Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 327225

Summary: MaxDB: JPQL date/time functions current_date, current_time are not mapped properly
Product: z_Archived Reporter: Adrian Goerler <adrian.goerler>
Component: EclipselinkAssignee: Adrian Goerler <adrian.goerler>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: andreas.fischbach, eclipselink.incubator-inbox, krum.tsvetkov, sabine.heider
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard: maxdb
Bug Depends on:    
Bug Blocks: 284657    
Attachments:
Description Flags
fix for maxdb
none
improve documentation of ExpressionOperators; Mix test to use currentDateDate method as attribute compared has type java.sql.Date none

Description Adrian Goerler CLA 2010-10-07 08:59:31 EDT
On maxDB, the JPQL date/time functions 
current_date, current_time and current_timestamp need to be mapped to DATE, TIME and TIMESTAMP respectively.
Comment 1 Adrian Goerler CLA 2010-10-07 12:40:46 EDT
Created attachment 180437 [details]
fix for maxdb
Comment 2 Adrian Goerler CLA 2010-10-07 12:42:14 EDT
Created attachment 180438 [details]
improve documentation of ExpressionOperators; Mix test to use currentDateDate method as attribute compared has type java.sql.Date
Comment 3 Adrian Goerler CLA 2010-10-07 12:50:50 EDT
Comment on attachment 180438 [details]
improve documentation of ExpressionOperators; Mix test to use currentDateDate method as attribute compared has type java.sql.Date

tested on MaxDB, MySQL
Comment 4 Adrian Goerler CLA 2010-10-11 02:36:37 EDT
Fix for MaxDB checked in at #8342.

Fix for core checked in at #8342.

Reviewed by Tom.
Tested on MaxDB, MySQL.
Comment 5 Eclipse Webmaster CLA 2022-06-09 10:07:40 EDT
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink