Does anyone have an example of doing an HQL Query that hits an Oracle DB using the Oracle to_date function? I'd rather NOT use native SQL. Or, if not, can someone suggest how to do this type of query?
If you want to use an Oracle specific function your only option is a SQL query. HQL does support the between keyword though so if you treat your date as, well, dates you don't need the function.
Ok, I can execute my native SQL Query and get my results as an array of "generic" objects . . . but now I want to convert them to an array of objects my specific type of bean . . . I'm working on this . . . can you suggest an approach?