Mailing-List: contact commits-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cayenne.apache.org
Message-ID: <30065913.178191281005535920.JavaMail.jira@thor>
Date: Thu, 5 Aug 2010 06:52:15 -0400 (EDT)
From: "Andrus Adamchik (JIRA)" <jira@apache.org>
To: commits@cayenne.apache.org
Subject: [jira] Commented: (CAY-1470) Oracle: Problem with bind CHAR in
 select
In-Reply-To: <20649992.157711280930776006.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CAY-1470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12895644#action_12895644 ] 

Andrus Adamchik commented on CAY-1470:
--------------------------------------

> SET_FIXED_CHAR_METHOD.getClass().equals(value.getClass())

This seems wrong. SET_FIXED_CHAR_METHOD.getClass() is "java.lang.refelect.Method"  

> Oracle: Problem with bind CHAR in select
> ----------------------------------------
>
>                 Key: CAY-1470
>                 URL: https://issues.apache.org/jira/browse/CAY-1470
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Core Library
>    Affects Versions: 2.0 branch, 3.0
>            Reporter: Evgeny Ryabitskiy
>            Assignee: Evgeny Ryabitskiy
>            Priority: Critical
>             Fix For: 2.0.5, 3.1M1
>
>         Attachments: CAY-1470.patch, CAY-1470.patch
>
>
> I have Table tUser
> desc tUser
> Name                           Null                Type                                                                                                                                                                                          
> ------------------------------ -------- 
> USERID                         NOT NULL NUMBER(15)                                                                                                                                                                                    
> BRIEF                             NOT NULL CHAR(30)   
> And wish to find user with BRIEF 'credit' :
> INFO  QueryLogger: Detected and installed adapter: org.apache.cayenne.dba.oracle.OracleAdapter
> INFO  QueryLogger: SELECT * FROM tUser WHERE Brief = ? [bind: 'credit']
> INFO  QueryLogger: === returned 0 rows. - took 125 ms.
> But if I try whitespaces at the end I would get:
> INFO  QueryLogger: SELECT * FROM tUser WHERE Brief = ? [bind: 'credit                        ']
> INFO  QueryLogger: === returned 1 row. - took 109 ms.
> It's absolutely not CROSS DB behavior!

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.