if you take the offending SQL, and wrap each NAME with square brackets ( i.e. [NAME] ) and run this directly to the JET engine (using ACCESS or raw ADO.NET) would it work?
On Wed, Dec 17, 2008 at 5:22 PM, severian <[email protected]> wrote: > > Hello, > > I have a quite simple HQL query > > Session.CreateQuery("select cdt from ChildDataTable as ct " + > "where cdt.Parent1.Name = :parent1Name and > cdt.Parent2.Name = :parent2Name"). > SetString("parent1Name", parent1Name). > SetString("parent2Name", parent2Name)); > > It worked correctly in NH 1.2.1 + JetDriver > > In 2.0 version return I get this error below (I have simplified and > reformatted it to make it more readable) > Does anyone know how to fix it or change the query or what has changed > on the way to NH 2.0? > > Regards, > Andrzej [severian] > > > -------------------------------------------------------------------------------------------------------------------------- > MyTestLibrary.TestAccess : NHibernate.ADOException : could not execute > query > > [ select cdt0_.RID as RID19_, cdt0_.PARENT1_RID as RM2_19_, > cdt0_.PARENT2_RID as RM3_19_, cdt0_.VALUE as VALUE19_ > from CHILD_DATA_TABLE cdt0_, PARENT1_TABLE parent1_, PARENT2_TABLE > parent2_ > where (parent1_.NAME=? and cdt0_.PARENT1_RID=parent1_.RID)and > (parent2_.NAME=? and cdt0_.PARENT2_RID=parent2_.RID) ] > > Name:parent1Name - Value:Test Parent 1 Name Name:parent2Name - > Value:Test Parent 2 Name > > [SQL: select cdt0_.RID as RID19_, cdt0_.PARENT1_RID as RM2_19_, > cdt0_.PARENT2_RID as RM3_19_, cdt0_.VALUE as VALUE19_ > from CHILD_DATA_TABLE cdt0_, PARENT1_TABLE parent1_, PARENT2_TABLE > parent2_ > where (parent1_.NAME=? and cdt0_.PARENT1_RID=parent1_.RID)and > (parent2_.NAME=? and cdt0_.PARENT2_RID=parent2_.RID)] > > ----> System.Data.OleDb.OleDbException : The SELECT statement > includes a reserved word or an argument name that is misspelled or > missing, or the punctuation is incorrect. > > > > -- Ken Egozi. http://www.kenegozi.com/blog http://www.delver.com http://www.musicglue.com http://www.castleproject.org http://www.gotfriends.co.il --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
