Re: ojb + ms-sql server: error re-reading row data

2004-10-22 Thread Jakob Braeuchi
hi phil, forgot to post the revision of the patch. it's RowReaderDefaultImpl revision 1.31 jakob Jakob Braeuchi schrieb: hi phil, imo the problem is caused by an optimization. first only the columns of the pk are read, and then in a second step all columns of the rows are read. afaik there's a pa

Re: ojb + ms-sql server: error re-reading row data

2004-10-22 Thread Jakob Braeuchi
hi phil, imo the problem is caused by an optimization. first only the columns of the pk are read, and then in a second step all columns of the rows are read. afaik there's a patch available. jakob WHIRLYCOTT schrieb: I just upgraded to OJB 1.0.01 today. I was using rc7 previously and didn't hav

Re: Conditional Join

2004-10-22 Thread Jakob Braeuchi
hi xu, afaik ojb cannot handle the conditional join. btw what does the complete sql look like ? jakob Jay Xu schrieb: Hello, I have a situation that I need to do a conditional Join. For example, IF OBJECT_A.type == 'B' THEN GET OBJECT_B with KEY(OBJECT_A.id) ELSE IF OBJECT_A.type == 'C' THEN

ojb + ms-sql server: error re-reading row data

2004-10-22 Thread WHIRLYCOTT
I just upgraded to OJB 1.0.01 today. I was using rc7 previously and didn't have the following problem. Quick description of my environment: I have a class called 'Folder' that corresponds to a db table called 'folder'. I have a class called 'Letter' that corresponds to a table called 'letter

Conditional Join

2004-10-22 Thread Jay Xu
Hello, I have a situation that I need to do a conditional Join. For example, IF OBJECT_A.type == 'B' THEN GET OBJECT_B with KEY(OBJECT_A.id) ELSE IF OBJECT_A.type == 'C' THEN GET OBJECT_C with KEY(OBJECT_A.id) END I am using OJB to handle the DB access. I use JOIN a lot. But is there an

Transaction rollback problem

2004-10-22 Thread Guido Beutler
Hi, I use OJB 1.0.0 inside of JBoss 3.2.3. how to handle the following condition: First I try to insert a row. This fails because of one required field wasn't filled and the transaction is rolled back. After that I try to insert the same row again, this time with correct data. OJB then generates

Transaction rollback problem

2004-10-22 Thread Guido Beutler
Hi, I use OJB 1.0.0 inside of JBoss 3.2.3. how to handle the following condition: First I try to insert a row. This fails because of one required field wasn't filled and the transaction is rolled back. After that I try to insert the same row again, this time with correct data. OJB then generates

problem storing composite objects using JDO API

2004-10-22 Thread George Mardale
Hi everybody, I am trying to persist a Company object with one Address object and one Discount object (1:1 aggregation for both relationships: Company-Address, Company-Discount). I am using JDO API (Sun's JDO Reference Implementation + OJB's JDO-plugin). That's because I wanted my application t

Re: OTM Transaction Rollback broken?

2004-10-22 Thread Sebastian
Sebastian wrote: Hi, I'm using OJB 1.01 with MySQL (com.mysql.jdbc.Driver, useAutoCommit="2"). I'm trying to persist an object that contains a RemovalAwareCollection with persistable child objects (refresh="true", auto-retrieve="true", otm-dependent="true"). I added a PBLifeCycleListener to the