[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: Thu, 27 Nov 2003 3:24 PM
       Body:
Great!

Just discovered that the previous unittests was really bad!
Passed on wrong assumptions, wrong hql syntax and more ;(

I've fixed all that plus added test for the fix Steve made (and yes - it passes ;)

While doing that I came to the thought that maybe we should introduce a InvalidParameterQueryException or something - now that we have
started adding other more specific exceptions stuff....what'da'ya say ?
---------------------------------------------------------------------
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: Closed
   Priority: Major
 Resolution: FIXED

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

   Assignee: Steve Ebersole
   Reporter: Irakli Nadareishvili

    Created: Mon, 24 Nov 2003 3:38 PM
    Updated: Thu, 27 Nov 2003 3:24 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