How to use SQL functions with parameters?

2007-01-31 Thread Francesco Martinelli
Dear all, I need to filter a query using an SQL function. In SQL this would be achieved with the following statement: select * from myTable where key in (select * from myFunc(myParam)) I tried the same with ODB-ODBC, and this worked using the following query string: String oqlQuery =

Re: OJB code fix contribution.

2007-01-31 Thread Armin Waibel
Hi, Virgo Smart wrote: Hello, We have done a code fix affecting around 3 files to solve a object materialization related issue we had faced some time back. The fix allows us to create instances of right classes within the class hierarchy during the materialization of objects (with TPS and TPS

Re: preventing foreign key to set to null

2007-01-31 Thread Armin Waibel
Hi, Christopher Cheng wrote: It seems that if set auto-retrieve to false for foreign key object, when I call broker.store(), it will also set the foreign key to null also! Supposing I have 2 tables Checks and CheckBooks class-descriptor class=Check table=Checks

Re: SequenceManagerHighLowImpl

2007-01-31 Thread Armin Waibel
Hi Bernd, Längerich wrote: Hi, I have some problems with OJB (PB-API) and the sequence manager. I derived a new sequence manager from the shipped HighLowImpl, that checks for every grab size with SequenceManagerHelper.getMaxForExtent() for the max id of the field. This works fine with data

AW: SequenceManagerHighLowImpl

2007-01-31 Thread Längerich , Bernd
Hi Armin, thanks again for your response. Armin wrote: Längerich wrote: Is it sufficient/possible to overwrite the afterStore() method of the sequence manager? Yep it's possible. Assume you want to lookup the HLSequence-object for the current used (fixed) field and invalidate the