Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-137
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-137
Summary: SELECT SYSDATE FROM DUAL
Type: Bug
Status: Assigned
Priority: Minor
Project: Cayenne
Components:
Cayenne Core Library
Versions:
1.1 [DEV]
Assignee: Andrus Adamchik
Reporter: Diego Iñigo
Created: Mon, 7 Jun 2004 4:02 PM
Updated: Mon, 7 Jun 2004 4:02 PM
Environment: Linux
Oracle
Java
Description:
This query have a problem:
String sql = "SELECT SYSDATE AS NOW FROM DUAL";
SqlSelectQuery query = new SqlSelectQuery(Ttve010Cot.class,sql);
Your solution is:
String sql = "SELECT #result('SYSDATE', 'java.sql.Timestamp', 'NOW') FROM DUAL";
SQLTemplate query = new SQLTemplate(Ttve010Cot.class,sql,true);
List data = ctxt.performQuery(query);
but, the new query no much the results, beucase the query is current up to table DUAL.
I don´t know how to specify the type of result columns for the table DUAL
the exception is:
BaseAction - getTime: [v.1.1M6 April 25 2004] Query exception.
The SQLTemplate can work on the table DUAL (ORACLE)????????
Andrus, thank you for yuor previous response,
I waiting for the new solution
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Mon Jun 07 2004 - 16:03:47 EDT