[nhusers] Re: Hbm2ddl TimeStamp Issues

2009-04-20 Thread Maxus
Hi Paulo, I gave that a try but instead it creates a column that is varbinary (8000). any other ideas? Thanks! M PS Sorry if this message appears twice, IE being wierd. On Apr 16, 7:06 pm, Paulo Quicoli pauloquic...@gmail.com wrote: I think you can specify in mapping file, the SQL type for

[nhusers] Re: Second level cache syscache in WPF Application

2009-04-20 Thread ronald
I would like to share some further information I got on this issue: I have written an E-mail to someone from microsoft support who has contributed to the following discussion: http://www.eggheadcafe.com/conversation.aspx?messageid=33359447threadid=33359424 Here is an excerpt from my E-Mail to

[nhusers] Re: I gave up

2009-04-20 Thread Markus Zywitza
I have read this to late... but I had this problem before. The error is to make this work with NH mapping resp. ActiveRecord attributes. From the models POV, the update is just fine, since you want to save an object's change to the database. The auditing is part of the database, not of the object

[nhusers] question about join tables

2009-04-20 Thread graphicsxp
Hi, I've read this article on the blog : http://nhforge.org/blogs/nhibernate/archive/2009/04/20/nhibernate-mapping-lt-join-gt.aspx My question is, is it possible to do the same thing and have complex objects making up the join table ? Example : 3 tables : [Article] {article_id, content}

[nhusers] Re: Lost database connection

2009-04-20 Thread Waqar Sadiq
To add more detail to my above post, what I am seeing is that the current session obtained from the above code shows that it is connected and open (when checked session.IsConnected and session.IsOpen properties). However, when a query is executed on it, the ADOException that is thrown has an

[nhusers] Re: Hbm2ddl TimeStamp Issues

2009-04-20 Thread Maxus
Solved it! For everyone and hopefully for google to remember: version name=Version generated=always unsaved-value=null type=BinaryBlob column name=Version not-null=false sql-type=timestamp/ /version There is also a custom user type with a series of tests, in the

[nhusers] Re: Second level cache syscache in WPF Application

2009-04-20 Thread Fabio Maulo
we have a provider implementation for:http://www.sharedcache.com/cms/ http://www.codeplex.com/memcachedproviders I'm not sure about its usability outside ASP.NET 2009/4/20 ronald ronald.ploe...@bertelsmann.de I would like to share some further information I got on this issue: I have

[nhusers] Re: question about join tables

2009-04-20 Thread Oskar Berggren
The join clause if for mapping one object over several tables. However, your scenario seems to be a normal one-to-many or many-to-many scenario between Article and Flag, with the ArticleFlag table being a normal link table. Look at set and many-to-many mapping tags. /Oskar 2009/4/20 graphicsxp

[nhusers] Two Transactions

2009-04-20 Thread Andrew Smith
I'm am trying to figure this out, I'm not sure if this is something that is just a bad way of doing this, but I want to have a second transaction within another transaction, like a subtransaction or something. I want the subtransaction to commit and be saved, but i want the first to rollback, but

[nhusers] NHContrib default.build

2009-04-20 Thread dagda1
Hi, I am trying to build the enitre of nhcontrib from the default.build file at the root of the src folder which will build all the individual projects. It fails pretty quickly. Can anyone tell me which switches and tasks I should call to enable the build to work. If I enter the following

[nhusers] Re: Criteria query across associations using 'OR'

2009-04-20 Thread Chris Nicola
Ah, thanks that did it. On Sat, Apr 18, 2009 at 4:45 AM, cws cw.stenb...@gmail.com wrote: Opps! Sorry, I meant Restrictions.Disjunction() Regards On 18 Apr, 00:24, Chris Nicola chnic...@gmail.com wrote: Hmmm, no that seems to produce exactly the same sql code. On Tue, Apr 14, 2009

[nhusers] ado timeouts

2009-04-20 Thread Jan Limpens
hello, on the production server (where else), my otherwise snappy web app suddenly has timeouts and crawls like a snail. my config is: settings item key=show_sqltrue/item item key=max_fetch_depth1/item item

[nhusers] Add distict row in drop down

2009-04-20 Thread Viki
Hi, I have below C# ASP.NET code to get distinct row of Coulmn batc id. config = new NHibernate.Cfg.Configuration(); config.AddAssembly(typeof(CSTS.Main.CashPosting).Assembly); factory = config.BuildSessionFactory(); session = factory.OpenSession(); query =

[nhusers] Get distinct Row using Hibernate

2009-04-20 Thread Viki
Hi, Below code i am using to get the distinct row of coulmnn batch id using Hibernate. Here when i am binding with Dropdown, complete row is coming, i need to bind only Batch id coulmn. config = new NHibernate.Cfg.Configuration();config.AddAssembly(typeof (CSTS.Main.CashPosting).Assembly);

[nhusers] Question: Mutliquery with dynamic parameters and existing limitations on In-Parameter

2009-04-20 Thread zoid
Two questions: In a Multiquery: Is it possible to fill a parameter dynamically within one query and read it in an other one, or multiple queries? Or do i need to make two calls to be able to use the Result as a filter for multiple following queries? Would this be possible using native SQL? In

[nhusers] Spatial Tests Fail

2009-04-20 Thread Heinrich
Hi, When I download the trunk, and run the tests in Spatial, they all fail. TestFixture failed: NHibernate.MappingException : Could not compile the mapping document: Tests.NHibernate.Spatial.Model.Simple.hbm.xml NHibernate.HibernateException : Could not instantiate dialect class

[nhusers] System.IndexOutOfRangeException on Persist Object with more than 400 fields

2009-04-20 Thread prog
I am trying to persist an object with more than 400 fields and when i go commit it, the follow exception occur...Any IDEA??? Thanks in advanced! [System.IndexOutOfRangeException] {O índice estava fora dos limites da matriz.}System.IndexOutOfRangeException Data

[nhusers] Re: Question: Mutliquery with dynamic parameters and existing limitations on In-Parameter

2009-04-20 Thread Fabio Maulo
2009/4/20 zoid zoidb...@googlemail.com Two questions: In a Multiquery: Is it possible to fill a parameter dynamically within one query and read it in an other one, or multiple queries? No. Or do i need to make two calls to be able to use the Result as a filter for multiple following

[nhusers] Re: System.IndexOutOfRangeException on Persist Object with more than 400 fields

2009-04-20 Thread Fabio Maulo
Source FirebirdSql.Data.FirebirdClient 2009/4/20 prog progjav...@gmail.com I am trying to persist an object with more than 400 fields and when i go commit it, the follow exception occur...Any IDEA??? Thanks in advanced! [System.IndexOutOfRangeException] {O índice estava fora dos

[nhusers] Re: Get distinct Row using Hibernate

2009-04-20 Thread Fabio Maulo
Are you going to db when you jut have what you need though the first query ?var batchChildren = Trans.Select(cp=cp.Batch_id); 2009/4/20 Viki vikas.jehana...@gmail.com Hi, Below code i am using to get the distinct row of coulmnn batch id using Hibernate. Here when i am binding with Dropdown,

[nhusers] Re: Add distict row in drop down

2009-04-20 Thread Fabio Maulo
Are you going to db when you jut have what you need trough the first query ?var batchIds = new HashSetint(Trans.Select(cp=cp.Batch_id)); P.S. please take your time to study ICriteria a little bit more because that resultsTrasformer with a projection don't have many sense. 2009/4/20 Viki

[nhusers] Re: Spatial Tests Fail

2009-04-20 Thread Fabio Maulo
The trunk of what ? 2009/4/20 Heinrich heinrichbre...@gmail.com Hi, When I download the trunk, and run the tests in Spatial, they all fail. TestFixture failed: NHibernate.MappingException : Could not compile the mapping document: Tests.NHibernate.Spatial.Model.Simple.hbm.xml