Hi, your idea seems very good. I am just wondering if you can suggest a way of query-ing the Document in the xml column type from NHibernate/AR (Hql/Straight sql/Criteria)?
Thanks, Dan On Sun, 25 Jun 2006 00:02:46 +0400, Ayende Rahien <[EMAIL PROTECTED]> wrote: > I posted about it here: > http://www.ayende.com/Blog/2006/05/30/NHibernateAndXMLColumnTypes.aspx > > Let me know if you need any help > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Mircea Jivoin > Sent: Saturday, June 24, 2006 3:42 PM > To: [email protected] > Subject: Re: [Castle-users] Use AR to dynamicaly create new table column > > > Yes that's realy something to think about. > Thanks a lot. > Mircea > > On 6/24/06, Ayende Rahien <[EMAIL PROTECTED] > wrote: > > Just something that occurred to me, you can use XML column and map that > to > an XML document, and get all the attributes of the document in one go. > > > > From: [EMAIL PROTECTED] [mailto: > <mailto:[EMAIL PROTECTED]> > [EMAIL PROTECTED] On Behalf Of Mircea > Jivoin > Sent: Monday, June 19, 2006 12:49 AM > > > To: [email protected] > Subject: Re: [Castle-users] Use AR to dynamicaly create new table column > > > Thanks Richard > > On 6/18/06, G. Richard Bellamy <[EMAIL PROTECTED]> wrote: > > +1 Solution 1. J > > > - Richard > > > _____ > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Mircea Jivoin > Sent: Sunday, June 18, 2006 2:33 PM > > > To: [email protected] > Subject: Re: [Castle-users] Use AR to dynamicaly create new table column > > > Ayende, thanks for the response. > > I didn't exactly understand which suggestion did you refer? > I've attached two diagrams of my solutions, first is using AR and > many-to-many with value and second is one from which I've migrated to AR > that used stored procedure that created new property column when a new > property was added. > > Can you tell me which one is better to use? > I think to proceed with first one, and if you think that there is no > performance problem then is no problem. > > Many thanks and I'm waiting for your replays > > On 6/18/06, Ayende Rahien <[EMAIL PROTECTED]> wrote: > > A table with 63 columns is not pretty. I'm going to assume that it is > mostly > nullable ones, which is even less pretty. Use your first suggestion, you > will be happy. > > Check NHiberntae caching. There is some info about that. There is a short > guide here: > > http://www.castleproject.org/index.php/ActiveRecord:How_to:Enable_second_lev > el_cache > > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] ] On Behalf Of > Mircea Jivoin > Sent: Sunday, June 18, 2006 9:26 PM > > > To: [email protected] > <mailto:[email protected]> > Subject: Re: [Castle-users] Use AR to dynamicaly create new table column > > > That's good to hear, I have a set of 63 properties for each document. > The propertis can change or add in the future so I could't come with > other > designe to store values for each document property then having a > intermediate table for that with many-to-many relation and value. > > Can you send me some links for caching the AR results? > Thank you for the resplay. > Mircea > > On 6/17/06, Ayende Rahien < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > wrote: > > This shouldn't have much effect. I'm using similar methods in several > places, and I have not seen any perf problems. > > In general, the DB should handle this easily, it is a join and a select, > simple stuff mostly. > > Throw some caching into the deal, and you will have smooth sailing. > > > How often are you adding a new property, anyway? Does it make sense to > have > dynamic properties? > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] ] On Behalf Of > Mircea Jivoin > Sent: Saturday, June 17, 2006 2:39 PM > > > To: [email protected] > <mailto:[email protected]> > Subject: Re: [Castle-users] Use AR to dynamicaly create new table column > > > Yes is a nasty thing to do. > But my scenario is next: > I have a table of documents, a table of properties and a table of > property > values. > The initial approach to this was using a stored procedure that created a > new > column for each new property added in property table. > But when I transferred to the AR I simply mapped as many-to-many with > value > table. > > Now my concern is the table size and it's performance. > Can I go like this with AR map? > The values table will grow like hell, what is your experience with this > approach? > Thanks for any comments. > Mircea > > On 6/17/06, Ayende Rahien <[EMAIL PROTECTED]> wrote: > > I can think of several ways to make it happen, but I can't think of a > scenario where this is a good thing. > Self modifying schema is a near contester to self modifying code in by > list > of things that I don't want to work with. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto: [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> ] On Behalf Of > hammett > Sent: Saturday, June 17, 2006 4:33 AM > To: [email protected] > Subject: Re: [Castle-users] Use AR to dynamicaly create new table column > > Hmm, I think this goes beyond what AR (and I dare to say, NHibernate) > has to > offer. > > On 6/16/06, Mircea Jivoin < <mailto:[EMAIL PROTECTED]> > [EMAIL PROTECTED]> > wrote: >> Hy everyone, >> >> Does anyone know if it is possible to dynamically or somehow in >> run-time create new table column using AR or NHibernate? > > > -- > Cheers, > hammett > http://hammett.castleproject.org/ > > > _______________________________________________ > CastleProject-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/castleproject-users > > > > _______________________________________________ > CastleProject-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/castleproject-users > > > > > > _______________________________________________ > CastleProject-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/castleproject-users > > > > > > _______________________________________________ > CastleProject-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/castleproject-users > > > > > > _______________________________________________ > CastleProject-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/castleproject-users > > > > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk > <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642> > &kid=120709&bid=263057&dat=121642 > > > _______________________________________________ > CastleProject-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/castleproject-users > > > > -- Dan Bunea http://danbunea.blogspot.com Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ CastleProject-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/castleproject-users
