[nhusers] Re: DB comments and description in NHibernate

2009-03-26 Thread Utopico
re Oracle8iDialect on forward. > > > > On Thu, Mar 26, 2009 at 6:47 AM, Utopico wrote: > > > I am working on a project where the database should be documented. I > > am looking for a way to use hibernate to define this in hibernate. I

[nhusers] DB comments and description in NHibernate

2009-03-26 Thread Utopico
I am working on a project where the database should be documented. I am looking for a way to use hibernate to define this in hibernate. I am using attributes on my classes to define my database (an example can be seen below). [NHibernate.Mapping.Attributes.Class(Table = "LINK")] public pa

[nhusers] Re: Performance slow down

2009-03-18 Thread Utopico
ou can do ("on-the-fly analysis") is open > one session per persistence iteration. > Mean: > - start iteration > - open session for db1 and db2 > - read from db1 > - write to db2 > - commit db2 / rollback db1 > - dispose session of db1 and db2

[nhusers] Re: Performance slow down

2009-03-17 Thread Utopico
refere to here is the second one * They will mostly run without user interaction On 17 Mar, 14:39, Fabio Maulo wrote: > Where is the description of the use case? > > 2009/3/17 Utopico > > > > > > > How would you suggest to have the session management pattern? &g

[nhusers] Re: Performance slow down

2009-03-17 Thread Utopico
How would you suggest to have the session management pattern? On 17 Mar, 14:23, Fabio Maulo wrote: > 2009/3/17 Utopico > > > > > Ok. Thank you very much. > > > I guess the second-level cache will not be cleared during this > > process? > > No man not

[nhusers] Re: Performance slow down

2009-03-17 Thread Utopico
; /Oskar > > 2009/3/17 Fabio Maulo > > > open and close the nh-session for each message/operation. > > > 2009/3/17 Utopico > > >> In a real application there would be many datasources reporting data > >> (at less frequent intervals). So how would yo

[nhusers] Re: Performance slow down

2009-03-17 Thread Utopico
Every 10 mintes. On 17 Mar, 13:21, Utopico wrote: > In a real application there would be many datasources reporting data > (at less frequent intervals). So how would you suggest to handle the > session in this case? A realistic scenario would about 30 datasources > reporting d

[nhusers] Re: Performance slow down

2009-03-17 Thread Utopico
is not really meant to be long running. Try creating a new session > for each "run" or at least clear the sessions cache. > > /Oskar > > 2009/3/17 Utopico > > > > > Using same session (at least th. I have now done a bit more > > monitoring. And it

[nhusers] Re: Performance slow down

2009-03-17 Thread Utopico
application is running. On 17 Mar, 11:07, Ayende Rahien wrote: > Are you using the same session? Or creating a session every time? > > On Tue, Mar 17, 2009 at 11:31 AM, Utopico wrote: > > > I have used hibernate for about half a year, but not with very high > > load. Yester

[nhusers] Performance slow down

2009-03-17 Thread Utopico
I have used hibernate for about half a year, but not with very high load. Yesterday I had an application running that slowed down significantly after running through the night (from fraction of a second to 10-15 seconds). I am pretty sure that there is somthing can be done to improve this, or a wa

[nhusers] Adding comments to the database with NHibernate.Mapping.Attributes

2009-02-02 Thread Utopico
Hi I would like to populate the database and include comments for fields and tables in the database. Is this possible to do with the NHibernate.Mapping.Attributes. If so, how is this done? I am usnig FireBird database. --~--~-~--~~~---~--~~ You received this mess

[nhusers] Re: Cross tab query

2009-01-08 Thread Utopico
I am not looking for agregate functions, but for cross tab or pivot quering. I would typically make a query for different data types (that is located in the same table) and get the listed as timetag - value of type A - value of type B - value of type C - (fore each requested type) And if

[nhusers] Cross tab query

2009-01-02 Thread Utopico
Hi I have not much experience with crosstab queries (pioting). I did som research on the net, but could not find andy good examples on how to do this through HQL and hibernate. Thus I was wondering if I could get some help with my problem. I have two tables: datarecord: (id, time) where id is PK

[nhusers] Re: Import with attributes

2008-12-09 Thread Utopico
. > > On Tue, Dec 9, 2008 at 3:01 PM, Utopico <[EMAIL PROTECTED]> wrote: > > > How would I do this when I do not use hbm files, but attributes on the > > classes instead? > > > On 9 Des, 13:43, "Gustavo Ringel" <[EMAIL PROTECTED]> wrote: > >

[nhusers] Re: Import with attributes

2008-12-09 Thread Utopico
How would I do this when I do not use hbm files, but attributes on the classes instead? On 9 Des, 13:43, "Gustavo Ringel" <[EMAIL PROTECTED]> wrote: > before the > Gustavo. > > On Tue, Dec 9, 2008 at 2:03 PM, Utopico <[EMAIL PROTECTED]> wrote: > > >

[nhusers] Import with attributes

2008-12-09 Thread Utopico
Hi I am trying to get this HQL query: SELECT r.LogTime, v.Value FROM DataRecord as r, DataValue as v WHERE v.DataRecord = r AND r.Device = ? AND v.Type = ? AND r.LogTime >= ? ORDER BY r.LogTime converted to: SELECT new TimeValueRecord(r.LogTime, v.Value) FROM DataRecord as r, DataValue as v WHER

[nhusers] Re: Help when defining mapping

2008-11-24 Thread Utopico
WHERE pm.in_out=false AND pm.datatype_id=dt.id AND pm.proc_id=? Where "?" is the id of the processing_instance. On 24 Nov, 10:51, Utopico <[EMAIL PROTECTED]> wrote: > I have been using NHibernate for 4 months now, but mainly used the > basic features. I am now looking for a way

[nhusers] Help when defining mapping

2008-11-24 Thread Utopico
I have been using NHibernate for 4 months now, but mainly used the basic features. I am now looking for a way to do something a bit more complicated: I have a Processing instance (table "PROCINST"). Each processing instance have several input and output DataTypes defines for it. The datatype is d

[nhusers] How to get foreign key id from child object

2008-11-10 Thread Utopico
I want to just retreive the foreign key id attirbute for my objects retreived from hibernate. I can of course get the child objects primary key, but fail to see how to get the foreign key directly. ChildObject - table A: * id * name * value (* parent_id refering to id of table B, but is not norma