[ 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)