[OS-JIRA] Created: (CAY-135) SELECT SYSDATE AS NOW FROM DUAL

From: jir..bjectstyle.org
Date: Mon Jun 07 2004 - 08:21:49 EDT

  • Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-136) Provide a way to map Boolean type to Oracle Integer"

    Message:

      A new issue has been created in JIRA.

    ---------------------------------------------------------------------
    View the issue:

      http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-135

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-135
        Summary: SELECT SYSDATE AS NOW FROM DUAL
           Type: Bug

         Status: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Versions:
                 1.1 [DEV]

       Assignee: Andrus Adamchik
       Reporter: Diego IƱigo

        Created: Mon, 7 Jun 2004 8:19 AM
        Updated: Mon, 7 Jun 2004 8:19 AM
    Environment: OS: Linux
    Lenguage: Java

    Description:
    Hi, the problem is, when

    String sql = "SELECT SYSDATE AS NOW FROM DUAL";
    SqlSelectQuery query = new SqlSelectQuery(Ttve010Cot.class,sql);
    List data = ctxt.performQuery(query);
    Iterator i = data.iterator();
    if(i.hasNext()){
         HashMap hash = (HashMap)i.next();
         logger.debug("fecha: "+ hash.get("NOW"));
    }

    the date is: fecha: Tue Nov 27 00:00:00 ART 2001

    the problem is no mantain de hours, minutes and seconds (response 00:00:00) in the last version 1.1.
    In the version 1.0 no contain this error.
    Please, can you report when solution this problem
    thank you

    ---------------------------------------------------------------------
    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 - 08:21:51 EDT