IIRC, where 1=0 is a placeholder in NHibernate that or-ed with the actual search criteria. This would mean that your lucene query has no results.
-Markus 2010/7/26 Jason Sznol <[email protected]>: > Can anyone help me get the NHibernate.Search functionality working in > my project. I have been scouring the internet for days looking for > answers but I cannot seem to find out what the problem is with my > code. I read through the using page on the castle website on how to > setup search. I have my program creating the index but when I try to > query it through NHibernate, it generates SQL that ends with the > clause "Where 1=0" resulting in no entities being pulled from the DB. > > I am using this piece of code to query using NHibernate.Search: > > Part[] entities = Part.FindAll(new LuceneQueryExpression(new > TermQuery(new Term("ID",@"OPL\-6BA*")))); > > I've tried actually creating a full text session but when I try to > create a similar query, the query object throws a bunch of exceptions > internally and results in no objects being found as well. > > I believe I have the web.config setup properly. Here is a log of what > it is doing. > > 00:18:00 [7] DEBUG NHibernate.Impl.SessionFactoryObjectFactory - > initializing class SessionFactoryObjectFactory > 00:18:00 [7] DEBUG NHibernate.Impl.SessionFactoryObjectFactory - > registered: 23509b5478d147bc9f98bf1fccbf8254(unnamed) > 00:18:00 [7] INFO NHibernate.Impl.SessionFactoryObjectFactory - no > name configured > 00:18:00 [7] DEBUG NHibernate.Impl.SessionFactoryImpl - Instantiated > session factory > 00:18:00 [7] DEBUG NHibernate.Impl.SessionFactoryImpl - Checking 0 > named HQL queries > 00:18:00 [7] DEBUG NHibernate.Impl.SessionFactoryImpl - Checking 0 > named SQL queries > 00:18:00 [7] DEBUG NHibernate.Impl.SessionImpl - [session- > id=7a073d33-3d0c-4050-aa52-149a61be9ccf] opened session at timestamp: > 634157002805, for session factory: [/23509b5478d147bc9f98bf1fccbf8254] > 00:18:00 [7] DEBUG NHibernate.Transaction.AdoTransaction - Begin > (Unspecified) > 00:18:00 [7] DEBUG NHibernate.Connection.DriverConnectionProvider - > Obtaining IDbConnection from Driver > 00:18:00 [7] DEBUG NHibernate.Loader.Criteria.CriteriaQueryTranslator > - put criteria=id in () alias=this0_ > 00:18:00 [7] INFO NHibernate.Search.Reader.SharedReaderProvider - > Opening IndexReader for directoryProviders: 2 > 00:18:00 [7] INFO NHibernate.Search.Reader.SharedReaderProvider - > Opening IndexReader from lucene.net.store.fsdirect...@c:\Work\Opel > \trunk\design\software\OpelWeb\Index\Part.0 > 00:18:00 [7] INFO NHibernate.Search.Reader.SharedReaderProvider - No > shared IndexReader, opening a new one: lucene.net.store.fsdirect...@c: > \Work\Opel\trunk\design\software\OpelWeb\Index\Part.0 > 00:18:00 [7] INFO NHibernate.Search.Reader.SharedReaderProvider - > Semaphore: 1 for Lucene.Net.Index.MultiSegmentReader > 00:18:00 [7] INFO NHibernate.Search.Reader.SharedReaderProvider - > Opening IndexReader from lucene.net.store.fsdirect...@c:\Work\Opel > \trunk\design\software\OpelWeb\Index\Part.1 > 00:18:00 [7] INFO NHibernate.Search.Reader.SharedReaderProvider - No > shared IndexReader, opening a new one: lucene.net.store.fsdirect...@c: > \Work\Opel\trunk\design\software\OpelWeb\Index\Part.1 > 00:18:00 [7] INFO NHibernate.Search.Reader.SharedReaderProvider - > Semaphore: 1 for Lucene.Net.Index.MultiSegmentReader > 00:18:01 [7] DEBUG NHibernate.Loader.Criteria.CriteriaQueryTranslator > - getCriteria for path=RequestedBy crit= > 00:18:01 [7] DEBUG NHibernate.Loader.Criteria.CriteriaQueryTranslator > - getCriteria for path=ApprovedBy crit= > 00:18:01 [7] DEBUG NHibernate.Loader.Criteria.CriteriaQueryTranslator > - getCriteria for path=Manufacturer crit= > 00:18:01 [7] DEBUG NHibernate.Loader.Criteria.CriteriaQueryTranslator > - getCriteria for path=PartCategory crit= > 00:18:01 [7] DEBUG NHibernate.Loader.Criteria.CriteriaQueryTranslator > - getCriteria for path=PartCategory.Department crit= > 00:18:01 [7] DEBUG NHibernate.Loader.Criteria.CriteriaQueryTranslator > - getCriteria for path=M2MPart crit= > 00:18:01 [7] DEBUG NHibernate.AdoNet.AbstractBatcher - Opened new > IDbCommand, open IDbCommands: 1 > 00:18:01 [7] DEBUG NHibernate.AdoNet.AbstractBatcher - Building an > IDbCommand object for the SqlString: SELECT this_.ID as ID7_6_, > this_.DateRequested as DateRequ2_7_6_, this_.DateApproved as > DateAppr3_7_6_, this_.Status as Status7_6_, this_.DateDeleted as > DateDele5_7_6_, this_.RequestDescription as RequestD6_7_6_, > this_.PartDescription as PartDesc7_7_6_, this_.RoHS as RoHS7_6_, > this_.SpecialNotes as SpecialN9_7_6_, this_.ManufacturerPartNumber as > Manufac10_7_6_, this_.requestedby as request11_7_6_, this_.approvedby > as approvedby7_6_, this_.Manufacturer as Manufac13_7_6_, > this_.PartCategory as PartCat14_7_6_, opeluser2_.id as id5_0_, > opeluser2_.username as username5_0_, opeluser2_.email as email5_0_, > opeluser2_.ktusername as ktusername5_0_, opeluser2_.ktpassword as > ktpassword5_0_, opeluser3_.id as id5_1_, opeluser3_.username as > username5_1_, opeluser3_.email as email5_1_, opeluser3_.ktusername as > ktusername5_1_, opeluser3_.ktpassword as ktpassword5_1_, > manufactur4_.ID as ID3_2_, manufactur4_.Name as Name3_2_, > manufactur4_.Website as Website3_2_, partcatego5_.ID as ID2_3_, > partcatego5_.CategoryID as CategoryID2_3_, partcatego5_.Name as > Name2_3_, partcatego5_.NumberFormat as NumberFo4_2_3_, > partcatego5_.Department as Department2_3_, department6_.ID as ID0_4_, > department6_.Name as Name0_4_, made2manag7_.ID as ID4_5_, > made2manag7_.PartNumber as PartNumber4_5_, made2manag7_.Revision as > Revision4_5_, made2manag7_.Description as Descript4_4_5_, > made2manag7_.ProductClass as ProductC5_4_5_, made2manag7_.GroupCode as > GroupCode4_5_, made2manag7_.UnitsForInventory as UnitsFor7_4_5_, > made2manag7_.UnitsForVendors as UnitsFor8_4_5_, > made2manag7_.CostPerInventoryUnit as CostPerI9_4_5_, > made2manag7_.Source as Source4_5_, made2manag7_.ABCCode as > ABCCode4_5_, made2manag7_.LeadTime as LeadTime4_5_, > made2manag7_.Location as Location4_5_, made2manag7_.Facility as > Facility4_5_ FROM Parts this_ inner join OpelUsers opeluser2_ on > this_.requestedby=opeluser2_.id left outer join OpelUsers opeluser3_ > on this_.approvedby=opeluser3_.id left outer join Manufacturers > manufactur4_ on this_.Manufacturer=manufactur4_.ID left outer join > PartCategories partcatego5_ on this_.PartCategory=partcatego5_.ID left > outer join Departments department6_ on > partcatego5_.Department=department6_.ID left outer join > Made2ManagePart made2manag7_ on this_.ID=made2manag7_.ID WHERE 1=0 > 00:18:01 [7] INFO NHibernate.Loader.Loader - SELECT this_.ID as > ID7_6_, this_.DateRequested as DateRequ2_7_6_, this_.DateApproved as > DateAppr3_7_6_, this_.Status as Status7_6_, this_.DateDeleted as > DateDele5_7_6_, this_.RequestDescription as RequestD6_7_6_, > this_.PartDescription as PartDesc7_7_6_, this_.RoHS as RoHS7_6_, > this_.SpecialNotes as SpecialN9_7_6_, this_.ManufacturerPartNumber as > Manufac10_7_6_, this_.requestedby as request11_7_6_, this_.approvedby > as approvedby7_6_, this_.Manufacturer as Manufac13_7_6_, > this_.PartCategory as PartCat14_7_6_, opeluser2_.id as id5_0_, > opeluser2_.username as username5_0_, opeluser2_.email as email5_0_, > opeluser2_.ktusername as ktusername5_0_, opeluser2_.ktpassword as > ktpassword5_0_, opeluser3_.id as id5_1_, opeluser3_.username as > username5_1_, opeluser3_.email as email5_1_, opeluser3_.ktusername as > ktusername5_1_, opeluser3_.ktpassword as ktpassword5_1_, > manufactur4_.ID as ID3_2_, manufactur4_.Name as Name3_2_, > manufactur4_.Website as Website3_2_, partcatego5_.ID as ID2_3_, > partcatego5_.CategoryID as CategoryID2_3_, partcatego5_.Name as > Name2_3_, partcatego5_.NumberFormat as NumberFo4_2_3_, > partcatego5_.Department as Department2_3_, department6_.ID as ID0_4_, > department6_.Name as Name0_4_, made2manag7_.ID as ID4_5_, > made2manag7_.PartNumber as PartNumber4_5_, made2manag7_.Revision as > Revision4_5_, made2manag7_.Description as Descript4_4_5_, > made2manag7_.ProductClass as ProductC5_4_5_, made2manag7_.GroupCode as > GroupCode4_5_, made2manag7_.UnitsForInventory as UnitsFor7_4_5_, > made2manag7_.UnitsForVendors as UnitsFor8_4_5_, > made2manag7_.CostPerInventoryUnit as CostPerI9_4_5_, > made2manag7_.Source as Source4_5_, made2manag7_.ABCCode as > ABCCode4_5_, made2manag7_.LeadTime as LeadTime4_5_, > made2manag7_.Location as Location4_5_, made2manag7_.Facility as > Facility4_5_ FROM Parts this_ inner join OpelUsers opeluser2_ on > this_.requestedby=opeluser2_.id left outer join OpelUsers opeluser3_ > on this_.approvedby=opeluser3_.id left outer join Manufacturers > manufactur4_ on this_.Manufacturer=manufactur4_.ID left outer join > PartCategories partcatego5_ on this_.PartCategory=partcatego5_.ID left > outer join Departments department6_ on > partcatego5_.Department=department6_.ID left outer join > Made2ManagePart made2manag7_ on this_.ID=made2manag7_.ID WHERE 1=0 > 00:18:01 [7] DEBUG NHibernate.SQL - SELECT this_.ID as ID7_6_, > this_.DateRequested as DateRequ2_7_6_, this_.DateApproved as > DateAppr3_7_6_, this_.Status as Status7_6_, this_.DateDeleted as > DateDele5_7_6_, this_.RequestDescription as RequestD6_7_6_, > this_.PartDescription as PartDesc7_7_6_, this_.RoHS as RoHS7_6_, > this_.SpecialNotes as SpecialN9_7_6_, this_.ManufacturerPartNumber as > Manufac10_7_6_, this_.requestedby as request11_7_6_, this_.approvedby > as approvedby7_6_, this_.Manufacturer as Manufac13_7_6_, > this_.PartCategory as PartCat14_7_6_, opeluser2_.id as id5_0_, > opeluser2_.username as username5_0_, opeluser2_.email as email5_0_, > opeluser2_.ktusername as ktusername5_0_, opeluser2_.ktpassword as > ktpassword5_0_, opeluser3_.id as id5_1_, opeluser3_.username as > username5_1_, opeluser3_.email as email5_1_, opeluser3_.ktusername as > ktusername5_1_, opeluser3_.ktpassword as ktpassword5_1_, > manufactur4_.ID as ID3_2_, manufactur4_.Name as Name3_2_, > manufactur4_.Website as Website3_2_, partcatego5_.ID as ID2_3_, > partcatego5_.CategoryID as CategoryID2_3_, partcatego5_.Name as > Name2_3_, partcatego5_.NumberFormat as NumberFo4_2_3_, > partcatego5_.Department as Department2_3_, department6_.ID as ID0_4_, > department6_.Name as Name0_4_, made2manag7_.ID as ID4_5_, > made2manag7_.PartNumber as PartNumber4_5_, made2manag7_.Revision as > Revision4_5_, made2manag7_.Description as Descript4_4_5_, > made2manag7_.ProductClass as ProductC5_4_5_, made2manag7_.GroupCode as > GroupCode4_5_, made2manag7_.UnitsForInventory as UnitsFor7_4_5_, > made2manag7_.UnitsForVendors as UnitsFor8_4_5_, > made2manag7_.CostPerInventoryUnit as CostPerI9_4_5_, > made2manag7_.Source as Source4_5_, made2manag7_.ABCCode as > ABCCode4_5_, made2manag7_.LeadTime as LeadTime4_5_, > made2manag7_.Location as Location4_5_, made2manag7_.Facility as > Facility4_5_ FROM Parts this_ inner join OpelUsers opeluser2_ on > this_.requestedby=opeluser2_.id left outer join OpelUsers opeluser3_ > on this_.approvedby=opeluser3_.id left outer join Manufacturers > manufactur4_ on this_.Manufacturer=manufactur4_.ID left outer join > PartCategories partcatego5_ on this_.PartCategory=partcatego5_.ID left > outer join Departments department6_ on > partcatego5_.Department=department6_.ID left outer join > Made2ManagePart made2manag7_ on this_.ID=made2manag7_.ID WHERE 1=0 > 00:18:01 [7] DEBUG NHibernate.Transaction.AdoTransaction - Enlist > Command > 00:18:01 [7] DEBUG NHibernate.AdoNet.AbstractBatcher - ExecuteReader > took 74 ms > 00:18:01 [7] DEBUG NHibernate.AdoNet.AbstractBatcher - Opened > IDataReader, open IDataReaders: 1 > 00:18:01 [7] DEBUG NHibernate.Loader.Loader - processing result set > 00:18:01 [7] DEBUG NHibernate.Loader.Loader - done processing result > set (0 rows) > 00:18:01 [7] DEBUG NHibernate.Driver.NHybridDataReader - running > NHybridDataReader.Dispose() > 00:18:01 [7] DEBUG NHibernate.AdoNet.AbstractBatcher - Closed > IDataReader, open IDataReaders :0 > 00:18:01 [7] DEBUG NHibernate.AdoNet.AbstractBatcher - DataReader was > closed after 86 ms > 00:18:01 [7] DEBUG NHibernate.AdoNet.AbstractBatcher - Closed > IDbCommand, open IDbCommands: 0 > 00:18:01 [7] DEBUG NHibernate.Loader.Loader - total objects hydrated: > 0 > 00:18:01 [7] DEBUG NHibernate.Engine.StatefulPersistenceContext - > initializing non-lazy collections > 00:18:03 [7] DEBUG NHibernate.Transaction.AdoTransaction - Start > Commit > 00:18:03 [7] DEBUG NHibernate.Impl.SessionImpl - before transaction > completion > 00:18:03 [7] DEBUG NHibernate.Transaction.AdoTransaction - > IDbTransaction Committed > 00:18:03 [7] DEBUG NHibernate.Impl.SessionImpl - transaction > completion > 00:18:03 [7] DEBUG NHibernate.AdoNet.ConnectionManager - aggressively > releasing database connection > 00:18:03 [7] DEBUG NHibernate.Connection.ConnectionProvider - Closing > connection > 00:18:03 [7] DEBUG NHibernate.Transaction.AdoTransaction - > IDbTransaction disposed. > 00:18:03 [7] DEBUG NHibernate.Impl.SessionImpl - [session- > id=7a073d33-3d0c-4050-aa52-149a61be9ccf] running ISession.Dispose() > 00:18:03 [7] DEBUG NHibernate.Impl.SessionImpl - [session- > id=7a073d33-3d0c-4050-aa52-149a61be9ccf] executing real Dispose(True) > 00:18:03 [7] DEBUG NHibernate.Impl.SessionImpl - closing session > 00:18:03 [7] DEBUG NHibernate.AdoNet.AbstractBatcher - running > BatcherImpl.Dispose(true) > > -- > You received this message because you are subscribed to the Google Groups > "Castle Project Users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/castle-project-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
