From: NHibernate J. <mik...@us...> - 2006-11-13 18:10:28
|
[ http://jira.nhibernate.org/browse/NH-503?page=all ] Sergey Koshcheyev updated NH-503: --------------------------------- Fix Version: LATER > Unable to use HQL expression with subtype > ----------------------------------------- > > Key: NH-503 > URL: http://jira.nhibernate.org/browse/NH-503 > Project: NHibernate > Type: Improvement > Components: Core > Versions: 1.0.1 > Reporter: Jerry Haltom > Fix For: LATER > > query = session.CreateQuery( > "select person\n" + > "from ISIS.Data.Core.PaymentInstruction payment\n" + > "inner join payment.Participant participant\n" + > "inner join participant.Program program\n" + > "inner join program.Contract contract\n" + > "inner join participant.Person person\n" + > "where payment.LastDate is null null\n" + > " and payment.Account.class = ISIS.Data.Core.BankAccount\n" + > " and payment.Account.Number like '%' + :accountNumber + '%'\n" + > " and contract.Client = :client\n" > ); > The error I am receiving is that the property Account cannot be found in type ISIS.Data.Core.Account. BankAccount is a subclass of Account. I am trying to apply an expression only against BankAccounts in the database. It looks like it doesn't know this. If there was some way to case payment.Account in HQL, that would fix it. What is the solution? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.nhibernate.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |
From: NHibernate J. <nh...@gm...> - 2008-06-15 17:41:09
|
[ http://jira.nhibernate.org/browse/NH-503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Fabio Maulo updated NH-503: --------------------------- Fix Version/s: (was: 2.0.0.Alpha2) 2.0.0.Beta1 > Unable to use HQL expression with subtype > ----------------------------------------- > > Key: NH-503 > URL: http://jira.nhibernate.org/browse/NH-503 > Project: NHibernate > Issue Type: Improvement > Components: Core > Affects Versions: 1.0.1 > Reporter: Jerry Haltom > Priority: Major > Fix For: 2.0.0.Beta1 > > > query = session.CreateQuery( > "select person\n" + > "from ISIS.Data.Core.PaymentInstruction payment\n" + > "inner join payment.Participant participant\n" + > "inner join participant.Program program\n" + > "inner join program.Contract contract\n" + > "inner join participant.Person person\n" + > "where payment.LastDate is null null\n" + > " and payment.Account.class = ISIS.Data.Core.BankAccount\n" + > " and payment.Account.Number like '%' + :accountNumber + '%'\n" + > " and contract.Client = :client\n" > ); > The error I am receiving is that the property Account cannot be found in type ISIS.Data.Core.Account. BankAccount is a subclass of Account. I am trying to apply an expression only against BankAccounts in the database. It looks like it doesn't know this. If there was some way to case payment.Account in HQL, that would fix it. What is the solution? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.nhibernate.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |
From: NHibernate J. <nh...@gm...> - 2008-06-29 20:59:04
|
[ http://jira.nhibernate.org/browse/NH-503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Fabio Maulo updated NH-503: --------------------------- Fix Version/s: (was: 2.0.0.Beta1) 2.0.0.Beta2 > Unable to use HQL expression with subtype > ----------------------------------------- > > Key: NH-503 > URL: http://jira.nhibernate.org/browse/NH-503 > Project: NHibernate > Issue Type: Improvement > Components: Core > Affects Versions: 1.0.1 > Reporter: Jerry Haltom > Priority: Major > Fix For: 2.0.0.Beta2 > > > query = session.CreateQuery( > "select person\n" + > "from ISIS.Data.Core.PaymentInstruction payment\n" + > "inner join payment.Participant participant\n" + > "inner join participant.Program program\n" + > "inner join program.Contract contract\n" + > "inner join participant.Person person\n" + > "where payment.LastDate is null null\n" + > " and payment.Account.class = ISIS.Data.Core.BankAccount\n" + > " and payment.Account.Number like '%' + :accountNumber + '%'\n" + > " and contract.Client = :client\n" > ); > The error I am receiving is that the property Account cannot be found in type ISIS.Data.Core.Account. BankAccount is a subclass of Account. I am trying to apply an expression only against BankAccounts in the database. It looks like it doesn't know this. If there was some way to case payment.Account in HQL, that would fix it. What is the solution? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.nhibernate.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |
From: NHibernate J. <nh...@gm...> - 2008-09-30 12:29:31
|
[ http://jira.nhibernate.org/browse/NH-503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Fabio Maulo updated NH-503: --------------------------- Fix Version/s: (was: 2.1.0.Alpha1) > Unable to use HQL expression with subtype > ----------------------------------------- > > Key: NH-503 > URL: http://jira.nhibernate.org/browse/NH-503 > Project: NHibernate > Issue Type: Improvement > Components: Core > Affects Versions: 1.0.1 > Reporter: Jerome Haltom > Priority: Major > > query = session.CreateQuery( > "select person\n" + > "from ISIS.Data.Core.PaymentInstruction payment\n" + > "inner join payment.Participant participant\n" + > "inner join participant.Program program\n" + > "inner join program.Contract contract\n" + > "inner join participant.Person person\n" + > "where payment.LastDate is null null\n" + > " and payment.Account.class = ISIS.Data.Core.BankAccount\n" + > " and payment.Account.Number like '%' + :accountNumber + '%'\n" + > " and contract.Client = :client\n" > ); > The error I am receiving is that the property Account cannot be found in type ISIS.Data.Core.Account. BankAccount is a subclass of Account. I am trying to apply an expression only against BankAccounts in the database. It looks like it doesn't know this. If there was some way to case payment.Account in HQL, that would fix it. What is the solution? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.nhibernate.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |