[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-495) Intermedia search problems begining 2.1 version

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Max Rydahl Andersen
    Created: Mon, 24 Nov 2003 4:30 PM
       Body:
ah -craps!

This is because in the newer version we are actually validating this stuff before executing the query.

What happens if you actually do have positonal parameters with the intermedia stuff does it work correct then ? (in the earlier versions i mean)
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-495


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-495
    Summary: Intermedia search problems begining 2.1 version
       Type: Bug

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.1 beta 2
             2.1 beta 3
             2.1 beta 4
             2.1 beta 5
             2.1 beta 6

   Assignee: 
   Reporter: Irakli Nadareishvili

    Created: Mon, 24 Nov 2003 3:38 PM
    Updated: Mon, 24 Nov 2003 4:30 PM
Environment: Hibernate 2.1 beta4 and beta6. Oracle 9i

Description:
Hi, 

Oracle Intermedia queries that have a "?" fails with Hibernate 2.1.  
The following OQL fails with a message : net.sf.hibernate.QueryException: Not all positional parameters have been set

select  cpv.id , message.message , cpv.indent from cpv in class org.digijava.module.eproc.dbentity.CPV , from message in class  org.digijava.kernel.entity.Message  where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8       and message.locale = 'en'      )  order by cpv.id

Hibernate 2.0 was ignoring the '?' within the contains clause, while 2.1 thinks it is a replacement parameter. We experience this problem on 2.1 beta4, 2.1 beta6. No such issues with 2.0 or 2.1beta1

Please, advise.

Stack Trace:
net.sf.hibernate.QueryException: Not all positional parameters have been set [se
lect  cpv.id , message.message , cpv.indent from cpv in class org.digijava.modul
e.eproc.dbentity.CPV , from message in class  org.digijava.kernel.entity.Message
  where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8
       and message.locale = 'en'      )  order by cpv.id]
        at net.sf.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQuer
yImpl.java:88)
        at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:43)
        at app.HBTest.main(HBTest.java:280)


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira