From: <leg...@at...> - 2003-11-25 01:51:25
|
Message: The following issue has been re-assigned. Assignee: Max Rydahl Andersen (mailto:xa...@xa...) Assigner: Gavin King (mailto:ga...@hi...) Date: Mon, 24 Nov 2003 7:50 PM Comment: OK, so the code that counts "?" has to be aware of quoting. Silly us :) Are you taking care of this Max? We better get it fixed before the next release which will be this w/e. --------------------------------------------------------------------- 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: Mon, 24 Nov 2003 7: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 |
From: <leg...@at...> - 2003-11-26 16:02:48
|
Message: The following issue has been re-assigned. Assignee: Steve Ebersole (mailto:ste...@vi...) Assigner: Gavin King (mailto:ga...@hi...) Date: Wed, 26 Nov 2003 10:02 AM Comment: Max, I'm reassigning this to steve, since you are sick. Steve, we added some code to scan the query string and validate parameters to AbstractQueryImpl in 2.1. It is this code that is broken, not the actual query parser I imagine. It just needs to handle quoted identifiers. But hopefully it can do this in a reasonably performant way. --------------------------------------------------------------------- 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: Steve Ebersole Reporter: Irakli Nadareishvili Created: Mon, 24 Nov 2003 3:38 PM Updated: Wed, 26 Nov 2003 10:02 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 |