Issues
- Unable to load entities with composite id using HSQLDBHSEARCH-1011Resolved issue: HSEARCH-1011
- NPE using two fulltext filters, one of them matching nothing (some filters only)HSEARCH-741Resolved issue: HSEARCH-741Sanne Grinovero
- Backport MassIndexer to 3.1.XHSEARCH-728Resolved issue: HSEARCH-728
- Limit graph traversal by @ContainedIn to the minimum required pathHSEARCH-638Resolved issue: HSEARCH-638Davide D'Alto
- FileNotFoundException during slave synchronization with sourceHSEARCH-614Resolved issue: HSEARCH-614
- FSSlaveDirectoryProvider could retry several times when the current marker file is not foundHSEARCH-532Resolved issue: HSEARCH-532
- Application hangs, main thread returns but some other thread spawned keeps application from endingHSEARCH-525Resolved issue: HSEARCH-525
- ThreadLocal in ContextHolder causes memory leak when deployed in a web containerHSEARCH-517Resolved issue: HSEARCH-517
- Lucene Directories might be closed before the backend finished all tasks on shutdownHSEARCH-516Resolved issue: HSEARCH-516
- Lucene AlreadyClosedExceptions During Batch Processing With ASYNC WorkersHSEARCH-515Resolved issue: HSEARCH-515
- FSMasterDirectoryProvider and FSSlaveDirectoryProvider don't shutdown the ExecutorHSEARCH-492Resolved issue: HSEARCH-492Sanne Grinovero
- Nested use of @ContainedIn: changes not propagated to Lucene indexHSEARCH-488Resolved issue: HSEARCH-488Emmanuel Bernard
- Some add/delete operations have null primary keysHSEARCH-480Resolved issue: HSEARCH-480
- Entities with composite PK lead to query exceptions on MySQLHSEARCH-478Resolved issue: HSEARCH-478Emmanuel Bernard
- Work queue contains the same operation multiple times and some add/delete operations have null primary keysHSEARCH-476Resolved issue: HSEARCH-476Emmanuel Bernard
- Ensure IndexWriter is closed on errors in backendHSEARCH-474Resolved issue: HSEARCH-474Sanne Grinovero
- Fields for _hibernate_class and the document ID are hard-coded to be analyzed and have "norms" enabled (Dobes Vandermeer)HSEARCH-473Resolved issue: HSEARCH-473Sanne Grinovero
- Separate indexes by field (foreign key)HSEARCH-470Resolved issue: HSEARCH-470
- Filter caching using causes excessive memory useHSEARCH-469Resolved issue: HSEARCH-469Yoann Rodière
- separating annotations from core as own jarHSEARCH-466Resolved issue: HSEARCH-466
- Indexes are not getting updated when entity gets updated via hql.HSEARCH-462Resolved issue: HSEARCH-462Emmanuel Bernard
- LazyInitializationException while removing entity with @ContainedIn annotationHSEARCH-460Resolved issue: HSEARCH-460
- FSSlaveDirectoryProvider: initial refreshHSEARCH-453Resolved issue: HSEARCH-453
- FSMasterDirectoryProvider: typo in marker file name (Stephan Bublava)HSEARCH-452Resolved issue: HSEARCH-452Sanne Grinovero
- how to install hibernate-search.zip in my projectHSEARCH-446Resolved issue: HSEARCH-446
- Support runtime polymorphism on associations (instead of defining the indexed properties based on the returned type)HSEARCH-438
- Update archetype sourcesHSEARCH-426Resolved issue: HSEARCH-426Hardy Ferentschik
- Provide a callback on indexing exception (Amin Mohammed-Coleman)HSEARCH-421Resolved issue: HSEARCH-421Sanne Grinovero
- Hibernate Search does not work with Lucene 3.0.0HSEARCH-420Resolved issue: HSEARCH-420
- Create a proper @ProvidedId testHSEARCH-419Resolved issue: HSEARCH-419
- SearchFactoryImpl close method is not called on application undeployment, leaving file handles open to indexesHSEARCH-417Resolved issue: HSEARCH-417
- Removing cyclic reference between JMSBackendProcessor and JMSBackendProcessorFactoryHSEARCH-406Resolved issue: HSEARCH-406
- NPE in org.hibernate.search.backend.WorkQueue.clear()HSEARCH-399Resolved issue: HSEARCH-399Emmanuel Bernard
- NPE when named FullTextFilter is disabled without being enabled firstHSEARCH-398Resolved issue: HSEARCH-398Sanne Grinovero
- disableFullTextFilter(String name) in FullTextQueryImpl does not disable the filter.HSEARCH-396Resolved issue: HSEARCH-396
- Master/Slave configuration as outlined in Hibernate Search in Action does not work when shared location is on NFSHSEARCH-395Resolved issue: HSEARCH-395
- @ProvidedId gets ignoredHSEARCH-394Resolved issue: HSEARCH-394Hardy Ferentschik
- Two-Level embedded objects don't get an index updateHSEARCH-391Resolved issue: HSEARCH-391Hardy Ferentschik
- Allow customization of the charset used by analyzer componentsHSEARCH-390Resolved issue: HSEARCH-390
- Filtering using criteria API is unreliableHSEARCH-389Resolved issue: HSEARCH-389Emmanuel Bernard
- Indexes are not created for @IndexedEmbedded fields that return an interface-type collection where you specify the implementation in targetEntityHSEARCH-388Resolved issue: HSEARCH-388
- Disable the automatic indexing as per session basisHSEARCH-387Resolved issue: HSEARCH-387Emmanuel Bernard
- In a Transaction, Delete on unindexed entities referenced by indexed entities with ContainedIn throw LazyInitializationExceptionHSEARCH-386Resolved issue: HSEARCH-386Emmanuel Bernard
- Lazy ManyToOne association with @containedIn annotation cause HSearch create entity index with documentId = 0HSEARCH-385Resolved issue: HSEARCH-385
- Hibernate Search does not respect the @AccessType annotation in respect to @Id fields.HSEARCH-383Resolved issue: HSEARCH-383Yoann Rodière
- Indexing fails silently in case the file based index is mounted read onlyHSEARCH-382Resolved issue: HSEARCH-382Sanne Grinovero
- Duplicate classes from Maven transitive dependencies (incompatible version of solr-lucene-core)HSEARCH-380Resolved issue: HSEARCH-380Sanne Grinovero
- When building the dist, the documentation is not addedHSEARCH-378Resolved issue: HSEARCH-378Hardy Ferentschik
- MANIFEST.MF does not contains the vendor and the version as it used to in the ant daysHSEARCH-377Resolved issue: HSEARCH-377Hardy Ferentschik
49 of 49
Unable to load entities with composite id using HSQLDB
Rejected
Description
Details
Assignee
UnassignedUnassignedReporter
Baptiste MathusBaptiste Mathus(Deactivated)Affects versions
Priority
Major
Details
Details
Assignee
Unassigned
UnassignedReporter
Baptiste Mathus
Baptiste Mathus(Deactivated)
Affects versions
Priority
MajorCreated December 21, 2011 at 12:40 PM
Updated January 11, 2012 at 5:13 PM
Resolved January 11, 2012 at 5:12 PM
Activity
Show:
Hardy FerentschikJanuary 11, 2012 at 5:13 PM
Thanks
Sanne GrinoveroJanuary 11, 2012 at 5:12 PM
Thanks Baptiste, closing the issue.
Baptiste MathusJanuary 11, 2012 at 4:54 PM
Hi Hardy,
I tried upgrading to 2.2.6, and it actually both went smoothly and fixed the issue.
So please consider this bug not an issue anymore. I don't think it's worth backporting any fix.
Thanks for your help.
Hardy FerentschikDecember 21, 2011 at 2:00 PM
it seems to me you are using a very old version of HSQLDB. This for example seems to work just fine:
If not, have you tried switching to H2?
Baptiste MathusDecember 21, 2011 at 1:21 PM
Ok, repo created: https://github.com/Batmat/HSEARCH-1011-testcase
The branch showing that very issue with Hsearch 3.1.1.GA: https://github.com/Batmat/HSEARCH-1011-testcase/tree/hsearch-3.1.1.GA-cannot-load-composite-id-with-HSQLDB
The (almost) same code, using hsearch 4.0.0.Final, showing it's working with this version: (base branch) hsearch-4.0.0.Final-ok-with-composite-id-with-HSQLDB
Cheers
Hi,
Hibernate Search actually manages to find entries in the lucene index, but then it fails trying to load them.
In fact, this issue seems to boil down to HSQLDB not supporting a query of this kind "...where (a,b) in (('x','y'))".
Caused by: java.sql.SQLException: Unexpected token: , in statementThis issue doesn't appear with Oracle, which is our production database. But it prevents us from unit/integration testing our code (using Arquillian/hsqldb/dbunit), which is in fact not very cool.
After that discussion on the forum, I've taken some time to create a test project (I'll host in a dedicated github repository, actually).
As explained on the forum, I guess I'm stuck using 3.1.1.GA, since we're using JBoss EAP 5.x.
Do you think that could be fixed?
If you give me pointers so that I can see if I can propose a patch, would it even be possible to release a 3.x version of hsearch?
Thanks for your answers.