cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Evgeny Ryabitskiy (JIRA)" <j...@apache.org>
Subject [jira] Commented: (CAY-1470) Oracle: Problem with bind CHAR in select
Date Thu, 05 Aug 2010 18:00:17 GMT

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

Evgeny Ryabitskiy commented on CAY-1470:
----------------------------------------

It's very good question. I will examine it.
Behavior tests + performance tests

While I ma studding this problem... could you say.. if it's possible to use Oracle Driver
class in Cayenne?

We could set scope "provided" for this dependency
http://maven.apache.org/guides/introduction/introduction-to-dependency-mechanism.html#Dependency_Scope
so it will be not transitive.

One little problem is with not Oracle JDBC driver for Oracle... not sure if it's exists....?

This question is because using native Java code is faster then Reflection....


> 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, 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.


Mime
View raw message