[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:50 PM
       Body:
Ok - found the problem, but not a solution (yet!) ;)

The problem is that our validation just counts ?'s and that don't work in your case.

If you are busy you can just go and disable postional parameters check in AbstractQueryImpl.java

The lines:

if ( positionalParameterCount!=values.size() || values.contains(null) ) {
			 throw new QueryException( "Not all positional parameters have been set", getQueryString() );
	
	}

Should just be commented out. That will allow you to continue.
---------------------------------------------------------------------
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:50 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