RE: [Hibernate] Odd Query behavior

2003-02-19 Thread Gavin . King
I've already fixed this on my local machine its just a matter of calling ps.setFecthSize(0); ps.setMaxRows(0); when re-caching the PreparedStatement. I'll commit this to CVS tonight, hopefully

[Hibernate] [ hibernate-Bugs-686577 ] low performance loading with optional 1-1 association

2003-02-19 Thread SourceForge.net
Bugs item #686577, was opened at 2003-02-14 14:43 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=686577&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Markus Menner (morphace) Assigned to: Nobody/Anonymo

[Hibernate] [ hibernate-Bugs-688513 ] Sequence / nested collection bug

2003-02-19 Thread SourceForge.net
Bugs item #688513, was opened at 2003-02-18 08:06 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=688513&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Markus Menner (morphace) Assigned to: Nobody/Anonymo

Re: [Hibernate] object is not an instance of declaring class

2003-02-19 Thread Viktor Szathmary
hi, On Wed 19 Feb 2003 13:14:30 +0100, "Tom Klaasen" <[EMAIL PROTECTED]> said: > Following Gavin's recommendations, I've tried to wrap the key in a > composite-id tag in the .hbm.xml: > > > > > if i understand correctly, you have a single field primary key wrapper class. in this case

Re: [Hibernate] object is not an instance of declaring class

2003-02-19 Thread Viktor Szathmary
On Wed, 19 Feb 2003 14:14:54 -0500, "Viktor Szathmary" <[EMAIL PROTECTED]> said: > so, finallly you end up with an extra one-line method in all your pk > classes, and this in the mapping file: > > > > > foo.bar.UserPK >

[Hibernate] [ hibernate-Patches-688610 ] Fetch profiles

2003-02-19 Thread SourceForge.net
Patches item #688610, was opened at 2003-02-18 11:45 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428710&aid=688610&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Konstantin Dmitriev (kdmitriev) Assigned to: Nobo

[Hibernate] v 1.2 SchemaExport.execute() method to be made public

2003-02-19 Thread Cameron Braid
For Hibernate 1.2 (code in HEAD as at 20 Feb 2003) I am writing a couple of ant tasks to allow for the execution of the SchemaExport and SchemaUpdate processes directly from ant, rather than using a forked java process. The main reason for doing this is to be able to use the ant fileset to specif

[Hibernate] [ hibernate-Bugs-688743 ] Unable to use properties of type "object" in queries

2003-02-19 Thread SourceForge.net
Bugs item #688743, was opened at 2003-02-19 03:41 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=688743&group_id=40712 Category: None Group: None >Status: Closed >Resolution: Rejected Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobod

[Hibernate] [ hibernate-Patches-688610 ] Fetch profiles

2003-02-19 Thread SourceForge.net
Patches item #688610, was opened at 2003-02-18 11:45 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428710&aid=688610&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Konstantin Dmitriev (kdmitriev) Assigned to: Nobo

[Hibernate] [ hibernate-Bugs-688513 ] Sequence / nested collection bug

2003-02-19 Thread SourceForge.net
Bugs item #688513, was opened at 2003-02-18 19:06 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=688513&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Markus Menner (morphace) Assigned to: Nobody/Anonymo

[Hibernate] SchemaUpdater problems with mySQL for both 1.2 and 2 versions.

2003-02-19 Thread Cameron Braid
Title: Message I have found a problem in the mySQL alter table script generator when adding more than one column to a table.   The resultant, faulty DDL is :   alter table foo add firstNameRenamed VARCHAR(255), lastNameRenamed VARCHAR(255)   Where as the correct DDL is :   alter table foo a

[Hibernate] [ hibernate-Bugs-688513 ] Sequence / nested collection bug

2003-02-19 Thread SourceForge.net
Bugs item #688513, was opened at 2003-02-18 08:06 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=688513&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Markus Menner (morphace) Assigned to: Nobody/Anonymo

Re: [Hibernate] Odd Query behavior

2003-02-19 Thread Gavin . King
Yick! You are probably right. PreparedStatement must retain the value of setMaxRows(). I had kinda assumed it only applied for the very next executeQuery() method, but probably not. Thats a VERY nasty bug. Would you submit a bug report please? (Workaround is to disable Hibernate PreparedStatement

Re: [Hibernate] null check and update, save

2003-02-19 Thread Gavin . King
What JDBC driver are you using? (I've got a funny feeling it might be Oracle, which does not differentiate between null and the empty string in its driver.) Hibernate doesn't do this. Your code, or possibly your JDBC driver might do it. Put a breakpoint in your setter method to discover exactly

[Hibernate] [ hibernate-Patches-688610 ] Fetch profiles

2003-02-19 Thread SourceForge.net
Patches item #688610, was opened at 2003-02-18 11:45 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428710&aid=688610&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Konstantin Dmitriev (kdmitriev) Assigned to: Nobo

[Hibernate] workaround for postgresql driver bug

2003-02-19 Thread Juozas Baliuka
Hi, I have problems with postgresql <= 7.2 and "large" tables. PostgreSQL server uses "typed" indexes, if indexed field and constant is not the same type, index is not used. Driver sends long constant as int ( it must cast it to int8 or convert to string ) test=# \timing Timing is on. test=# select

[Hibernate] [ hibernate-Bugs-688537 ] insert fails in list with non-sequential index

2003-02-19 Thread SourceForge.net
Bugs item #688537, was opened at 2003-02-18 09:09 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=688537&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Isabelle Phan (iphan) Assigned to: Nobody/Anonymous

[Hibernate] [ hibernate-Bugs-688743 ] Unable to use properties of type "object" in queries

2003-02-19 Thread SourceForge.net
Bugs item #688743, was opened at 2003-02-18 08:41 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=688743&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonym

Re: [Hibernate] Performance of "nested relations"

2003-02-19 Thread Philipp Meier
On Wed, Feb 19, 2003 at 10:01:26AM +1100, [EMAIL PROTECTED] wrote: > > Currently there is no way to grab contained collections in a single select > (and I have extreme doubts that it would be a performance increase unless > access to the database is over a slow network). A much better approach in

Re: [Hibernate] Performance of "nested relations"

2003-02-19 Thread Gavin . King
Currently there is no way to grab contained collections in a single select (and I have extreme doubts that it would be a performance increase unless access to the database is over a slow network). A much better approach in most cases is to make the Map lazy. (For contained collections of _entitie

RE: [Hibernate] Odd Query behavior

2003-02-19 Thread Ken Robinson
Rather than disabling PS caching entirely, we've got this workaround when we want to (rarely) see all values. query.setFirstResult(0); query.setMaxResults(Integer.MAX_VALUE); I'll submit a bug report now. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday,

[Hibernate] object is not an instance of declaring class

2003-02-19 Thread Tom Klaasen
Hi all, Some time ago, I posted some frustration about Hibernate on http://blogs.cocoondev.org/tomk/archives/000744.html. By the mysterious ways of the linked web, Gavin gave me a hint on how to solve the issue I was having. So first of all, I want to thank Gavin for that. Now I finally got to

Re: [Hibernate] v 1.2 SchemaExport.execute() method to be made public

2003-02-19 Thread Gavin . King
There is already an Ant tesk for SchemaExport in Hibernate2 CVS. However, I think it is probably achieving less re-use than your code. How about you have a look at what is existing there, and if you think there are any improvements to be made, submit a patch

[Hibernate] [ hibernate-Bugs-682109 ] XML Parsing Error

2003-02-19 Thread SourceForge.net
Bugs item #682109, was opened at 2003-02-07 14:44 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=682109&group_id=40712 Category: None Group: None >Status: Closed >Resolution: Duplicate Priority: 5 Submitted By: Van Tu (cyberisys) Assigned to: Nobody/Anon

Re[2]: [Hibernate] null check and update, save

2003-02-19 Thread Jaroslav Misura
Hi, I am using MySQL with "MySQL Connector/J 2.0.14" JDBC drivers. In my test the bean property is null both before and after update/flush, but when you load the bean from db using session.load(), the property is "". Attached to this mail you can find mapping file for my bean, JUnit test (part of

[Hibernate] [ hibernate-Bugs-688513 ] Sequence / nested collection bug

2003-02-19 Thread SourceForge.net
Bugs item #688513, was opened at 2003-02-18 08:06 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=688513&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Markus Menner (morphace) Assigned to: Nobody/Anonymo

[Hibernate] [ hibernate-Bugs-689112 ] PreparedStatement setFirstResult()/MaxResults() odd behavior

2003-02-19 Thread SourceForge.net
Bugs item #689112, was opened at 2003-02-19 10:17 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=689112&group_id=40712 Category: None Group: None >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Ken Robinson (krobinson) Assigned to: Nobody/An

Re: [Hibernate] Performance of "nested relations"

2003-02-19 Thread Gavin . King
Yes, this is the most compelling case; ie. a 1 - to - few relationship. However, I would be interested to see actual timings showing that the single enormous ResultSet is actually quicker than the 3000 + 1 seperate selects. I'm not saying for sure that it isn't in your case, but whenever I have do

[Hibernate] [ hibernate-Bugs-688537 ] insert fails in list with non-sequential index

2003-02-19 Thread SourceForge.net
Bugs item #688537, was opened at 2003-02-18 20:09 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=688537&group_id=40712 Category: None Group: None >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Isabelle Phan (iphan) Assigned to: Nobody/Anony

[Hibernate] [ hibernate-Patches-688610 ] Fetch profiles

2003-02-19 Thread SourceForge.net
Patches item #688610, was opened at 2003-02-18 11:45 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428710&aid=688610&group_id=40712 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Konstantin Dmitriev (kdmitriev) Assigned to: Nobo

[Hibernate] Re: Performance of "nested relations"

2003-02-19 Thread Marek Mosiewicz
Sorry maybe but I don't understand but It seems that You state that one select for collection is not faster that subsequent calls for each member. It is absolutly not true !!!. Maybe it depends on database but e.g. Oracle usulally returns simplest query :(SELECT * from tab where id = ?) after 10-

RE: [Hibernate] v 1.2 SchemaExport.execute() method to be made public

2003-02-19 Thread Ou, Rong
I've contributed an ant task for SchemaExport. Gavin has committed it to cvs. This is in Hibernate2 though. Rong -Original Message- From: Cameron Braid [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 19, 2003 9:05 AM To: Hibernate Development List Subject: [Hibernate] v 1.2 SchemaExpo