openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Andraschko (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OPENJPA-2774) Criteria + MSSQL: String value in where clause for a int column doesn't give a result
Date Mon, 04 Feb 2019 15:36:00 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-2774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16759942#comment-16759942
] 

Thomas Andraschko commented on OPENJPA-2774:
--------------------------------------------

ok, passing a string or int to a nativeQuery doesn't make any difference.
Even it works fine with MSSQL studio:
SELECT * FROM [Attribute] WHERE AttributeGroupId = '1'

just broken with criteria

> Criteria + MSSQL: String value in where clause for a int column doesn't give a result
> -------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2774
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2774
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: kernel
>    Affects Versions: 3.0.0
>            Reporter: Thomas Andraschko
>            Priority: Major
>
> If you add a where clause with string as value for a int column, something isn't resolved
correctly and no result is returned.
> When pass a int value, everything works.
> We should at least log a warning for such a case.
> will attach a sample later



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message