Yes, but not all of them...
Thank you very much for your help Ken! =)
On Sep 8, 4:56 pm, "Ken Egozi" <[EMAIL PROTECTED]> wrote:
> 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.castle...
>
> --
> Ken
> Egozi.http://www.kenegozi.com/bloghttp://www.musicglue.comhttp://www.castleproject.orghttp://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
-~----------~----~----~----~------~----~------~--~---
