FWIW, I have been using the microsoft driver successfully in my current
project (which uses Hibernate *very* nontrivially). However, it *is* very
slow compared to the other drivers we tested (esp. with large result sets).
If your client cares about performance, I strongly recommend a third party
d
Interesting.. Does this cause an error like "can reread from column 3 in
row.."? I may have just stumbled across that.. So outer joins are out for
MSSQL?
I will try and catalog all these gotchas, and maybe add unit tests to prove
them...
Eric Pugh
-Original Message-
From: Morten Wilke
I use the "Open Session in View" pattern for production sites. Works
great. I did some serious stress testing with and without the pattern.
The results did not show a performance penalty when using the pattern,
and neither did I get deadlocks etc. I guess there could be a
performance penalty if you
Interesting.. Does this cause an error like "can reread from column 3 in
row.."? I may have just stumbled across that.. So outer joins are out for
MSSQL?
I will try and catalog all these gotchas, and maybe add unit tests to prove
them...
Eric Pugh
-Original Message-
From: Morten Wilke
Hello,
I have been working with a lot of polymorphic associations using a table-per-
concreteclass strategy. This has led me to create a custom type which helps in
mapping an "integer" into a class type for use with the "" relationship.
Given many such relationships, I have created a abstract Cu
I don't close the session at all in any of my business logic methods. In
deployment, a servlet filter _always_ closes the session at the end of the
request. For unit testing, I have a base test case class that does the same
thing in the tearDown() method. That way, each test case can execute in the
