ICriterion is a simple interface, after all.
AbstractCriterion is a little more complex but not really a challange.
The real challange is getting a real way to translate between the xml query funky syntax that SQL uses.
On 6/26/06, Dan Bunea <
[EMAIL PROTECTED]> wrote:
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
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
