but you do need to update the data on these non-mapped tables?
On Mon, Sep 8, 2008 at 5:54 PM, erikash <[EMAIL PROTECTED]> wrote: > > ok, i have an app (a different one in production) which uses an oracle > database, i'm currently writing on another app, used to monitor the > previous one, parts of the monitoring involves querying the database, > therefore i don't need to map all the tables, only the tables that are > relevant for the monitoring... > > for example i need to map the "users" table, to later disconnect them > if i wish from the monitoring app, but i don't need to map other 10 > tables that have foreign keys to the users table... (i use a sql query > and projection to get that data) > > any suggestions? > > On Sep 8, 5:45 pm, "Ken Egozi" <[EMAIL PROTECTED]> wrote: > > I don't get it. > > is your classes not mapped to the db tables? how (or rather why) are you > > using NH/AR at all then? > > > > > > > > On Mon, Sep 8, 2008 at 5:39 PM, erikash <[EMAIL PROTECTED]> wrote: > > > > > Thanks, i agree that it is important, but i can't change my scheme, > > > i'm working on a monitoring app, and the database is being used by the > > > real app... > > > > > i wish that using hql (and thus mapping all the tables to classes), > > > would be sufficient to persist the projection... (i wish i could > > > implement that feature!!!) > > > > > Erik. > > > > > On Sep 8, 4:35 pm, "Ken Egozi" <[EMAIL PROTECTED]> wrote: > > > > > is there a benefit for using HqlBasedQuery instead > "CreateSQLQuery"? > > > > > > well HQL is working on the object driven domain model, while SQL is > > > working > > > > on the E/R model > > > > > > I'd try and use NamedQueries anyway, as they give you the nice effect > of > > > the > > > > ability to switch from hql to sql without affecting the calling call > at > > > all > > > > > > On Mon, Sep 8, 2008 at 4:26 PM, erikash <[EMAIL PROTECTED]> wrote: > > > > > > > Thank you very much Ken, that's exactly the case... > > > > > in my code i'm using the instance method "CreateSQLQuery()", in > your > > > > > blog post: > > > > > > > > http://www.kenegozi.com/Blog/2006/10/08/projection-using-activerecord. > > > .. > > > > > > > you used "HqlBasedQuery", i didn't use it because i didn't map all > the > > > > > tables used in the my sql query to objects. (there are too many of > > > > > them) > > > > > is there a benefit for using HqlBasedQuery instead > "CreateSQLQuery"? > > > > > AFAIK they both return typed objects... > > > > > > > On Sep 8, 2:05 pm, "Ken Egozi" <[EMAIL PROTECTED]> wrote: > > > > > > my two pence: > > > > > > > > should i use projection to bind the grid to the data? > > > > > > > > yes. > > > > > > Unless your persistable domain objects fits perfectly within the > > > view, > > > > > which > > > > > > is not likely as you describe it as a complex thing, it's > advisable > > > to > > > > > have > > > > > > a single query building up the necessary projection for the view. > > > > > > > > > if so then how will i unbind the data, update my models and > save > > > the > > > > > > > changes to the db? > > > > > > > > manually. That is - you load, populate and save the domain > objects > > > > > according > > > > > > to the given DTO received from the view > > > > > > > > On Mon, Sep 8, 2008 at 9:39 AM, erikash <[EMAIL PROTECTED]> > wrote: > > > > > > > > > Hi, I've asked this question on the activerecord forums, but i > fill > > > > > > > that this question may be more relevant here... > > > > > > > i'm working on a new project that accesses a legacy database, > which > > > i > > > > > > > cannot change/refactor. > > > > > > > anyway, i have a view which contains a grid that has many > columns > > > > > > > coming from different tables in th db (and mapped to different > > > objects > > > > > > > in my domain layer), and that grid is open for modifications... > > > should > > > > > > > i use projection to bind the grid to the data? if so then how > will > > > i > > > > > > > unbind the data, update my models and save the changes to the > db? > > > > > > > > > Thanks in advance, > > > > > > > Erik. > > > > > > > > -- > > > > > > Ken Egozi. > > > > > > http://www.kenegozi.com/bloghttp://www.musicglue.comhttp://www.castle. > > > .. > > > > > > -- > > > > Ken Egozi. > > >http://www.kenegozi.com/bloghttp://www.musicglue.comhttp://www.castle. > .. > > > > -- > > Ken Egozi. > http://www.kenegozi.com/bloghttp://www.musicglue.comhttp://www.castleproject.orghttp://www.gotfriends.co.il > > > -- Ken Egozi. http://www.kenegozi.com/blog 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 -~----------~----~----~----~------~----~------~--~---
