Formula in Discriminator is only to give support to legacy not ORM DB. The best way is refactorize the DB instead fight with it.
-- Fabio Maulo El 22/03/2011, a las 22:50, Suman <[email protected]> escribió: > Hi GGeurts and Fabio, > > Thanks heaps. Yeah, I resorted to property with private setter and a > protected method on the base class, which is called from sub class > constructor with appropriate discriminator. > It's not the exact way I wanted but it works now. > > Thanks heaps. > > > On Mar 23, 9:19 am, Fabio Maulo <[email protected]> wrote: >> The example in our tests is 1632 days old (more than 4 years). >> Have a look in NHibernate.Test.NHSpecificTest.NH335 >> >> >> >> On Tue, Mar 22, 2011 at 5:20 AM, Suman <[email protected]> wrote: >>> My problem is exactly same as described in following post but it >>> hasn't been answered and it's 4 years old post!!! >> >>> https://forum.hibernate.org/viewtopic.php?f=1&t=976655 >> >>> In summary, I have table per class hierarchy inheritance and I am >>> using formula in discriminator column. When I try to insert new record >>> (Entity) the insert fails because the generated sql doesn't include >>> the discriminator column. >> >>> Alternatively I could define another property that maps to the column >>> and make discriminator's "insert" attribute to false. However I don't >>> like this approach as it will force me to almost rewrite what formula >>> was there for in the domain object. >> >>> I would really appreciate if anyone else has fixed this problem some >>> better way. >> >>> <class name="Account" table="ACCOUNT" abstract ="true"> >> >>> <discriminator column ="ACCOUNT_TY" type ="string" formula="(case when >>> ACCOUNT_TY in ('CASHCARD','ORPHAN','BLACK','EXTERNAL', 'INTERNAL') >>> then 'OTHER' else ACCOUNT_TY end)" /> >> >>> <subclass name ="CreditCardAccount" extends ="Account" discriminator- >>> value="PREPAY" dynamic-update="true" > >>> <subclass name ="OtherAccount" extends ="Account" discriminator- >>> value="OTHER" dynamic-update="true"> >>> <subclass name ="PostpayAccount" extends ="Account" discriminator- >>> value="POSTPAY"> >> >>> -- >>> 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. >> >> -- >> Fabio Maulo > > -- > 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. > -- 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.
