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

An object relational-mapping (ORM) library for Java

Brought to you by: davidedalto, dreab8, epbernard, gsmet, and 5 others

hibernate-issues

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

From: <leg...@at...> - 2003-11-24 22:30:24

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

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

From: <leg...@at...> - 2003-11-24 22:51:24

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

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

From: <leg...@at...> - 2003-11-25 07:39:24

The following comment has been added to this issue:

     Author: Max Rydahl Andersen
    Created: Tue, 25 Nov 2003 1:38 AM
       Body:
i'll try to look at it.

But have it really been this way since the begining of time ? ;)
I expect that the hql parser does this correctly when executing the stuff - or is also somethin that needs fixing ?


---------------------------------------------------------------------
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: Open
   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: Max Rydahl Andersen
   Reporter: Irakli Nadareishvili

    Created: Mon, 24 Nov 2003 3:38 PM
    Updated: Tue, 25 Nov 2003 1:38 AM
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

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

From: <leg...@at...> - 2003-11-25 20:30:25

The following comment has been added to this issue:

     Author: Irakli Nadareishvili
    Created: Tue, 25 Nov 2003 2:30 PM
       Body:
The temporary solution of commenting out the lines, worked fine and it was a big help for us.

Thank you very much.
---------------------------------------------------------------------
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: Open
   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: Max Rydahl Andersen
   Reporter: Irakli Nadareishvili

    Created: Mon, 24 Nov 2003 3:38 PM
    Updated: Tue, 25 Nov 2003 2: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

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

From: <leg...@at...> - 2003-11-27 21:25:16

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