136 words

Help: After upgrading from 2.2.8_02 to 2.2.8_04, can't perform LIKE query

#1
2011-07-15 20:59

Hi,

  AFter the upgrade from 2.2.8_02 (not sure if it was build 03/04 as I skipped 03) - my LIKE queries have stopped working during a regression test. As an example output:



Query: SELECT $1 FROM Company $1 WHERE ((($1.companyId LIKE :p1) AND ($1.conditionOne=true)) AND ((($1.conditionTwo=false) OR ($1.conditionThree=false))))


Exception in thread "main"
[ObjectDB 2.2.8_04] Unexpected exception (Error 990)
  Generated by Java HotSpot(TM) 64-Bit Server VM 1.6.0_26 (on Mac OS X 10.6.8).
Please report this error on http://www.objectdb.com/database/issue/new
com.objectdb.o.InternalException: null
com.objectdb.o.InternalException
at com.objectdb.o.InternalException.f(InternalException.java:236)
at com.objectdb.o.QNF.k(QNF.java:309)
at com.objectdb.o.QNF.I(QNF.java:1250)
at com.objectdb.o.QNF.s(QNF.java:568)
at com.objectdb.o.QNF.k(QNF.java:200)
at com.objectdb.o.QNF.t(QNF.java:596)
at com.objectdb.o.QNF.t(QNF.java:588)
...........snip........

Attached is the test I am using to expose the situation a bit clearer. The field 'companyId' is a string.

 

Thanks

Willks
Willks's picture
Joined on 2011-04-04
User Post #27
#2
2011-07-17 02:11

The criteria query AND/OR fix in 2.2.8_04 caused this new problem.

Please try build 2.2.8_05 that should fix it.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #448
#3
2011-07-17 08:47

   This release carries out the grouping and likes correctly.

 

Thanks!

 

Willks
Willks's picture
Joined on 2011-04-04
User Post #28

Post Reply

Please read carefully the posting instructions - before posting to the ObjectDB website.

  • You may have to disable pop up blocking in order to use the toolbar (e.g. in Chrome).
  • Use ctrl + right click to open the browser context menu in the editing area (e.g. for using a browser spell checker).
  • To insert formatted lines (e.g. Java code, stack trace) - select a style in the toolbar and then insert the text in the new created block.
  • Avoid overflow of published source code examples by breaking long lines.
  • You may mark in paragraph code words (e.g. class names) with the code style (can be applied by ctrl + D).
  • Long stack traces (> 50 lines) and complex source examples (> 100 lines) should be posted as attachments.
Attachments:
Maximum file size: 32 MB
Cancel