Re: StringIndexOutOfBoundsException at SqlHelper.splitPath

Thanks Armin, But, that was another problem. That was caused by below line in my code. query.addGroupBy("DATE_FORMAT(DATE, \"%Y/%m/%d\")"); # DATE_FORMAT() is mysql function And SqlHelper.java: colName = betweenBraces.substring(colBegin + 1, colEnd); colBegin is created by..

RE: Transaction Question.

Hi, There can only be one ODMG transaction open per thread. Thanks, Rob :) > -Original Message- > From: Ziv Yankowitz [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 10 February 2004 5:39 a.m. > To: OJB (E-mail) > Subject: Transaction Question. > > > Folks, > > Is Nested Transaction supp

FW: This looks like a bug in store()

Richard, You might try setting up the reference as a proxy and then create a proxy object and set the identity on it. This way your object model would not be out of synch with your database. I'm not sure if OJB is going to try to materialize the proxy on store though. Maybe one of the developer

Re: This looks like a bug in store()

Hi Richard, Richard Schuller wrote: Thanks Gelhar, While that works it results into an unnecessary database call. Is there a way to bypass this behaviour? Latest version from CVS has some improvements on object insert, e.g. now it is allowed to insert a new object only with reference id set (an

RE: This looks like a bug in store()

Thanks Gelhar, While that works it results into an unnecessary database call. Is there a way to bypass this behaviour? Richard --- "Gelhar, Wallace Joseph" <[EMAIL PROTECTED]> wrote: > Hi Richard, > > This is not a bug, but rather behavior by design. > > OJB is an object level mapping layer. T

RE: This looks like a bug in store()

Hi Richard, This is not a bug, but rather behavior by design. OJB is an object level mapping layer. Therefore, OJB is using the value of the reference object you set (null!) and updating the FK (i.e. clearing the field). If you first set the FK and want to resolve the object, you may call pb.ret

Re: GroupBy clause ignored in PersistentBroker.getCount( Query query)

hi danilo, Danilo Tommasina wrote: Hi Jakob, yup I tried to 'patch' the getCount() method and also saw that setting the copy-groupBy flag to true wouldn't solve the problem. copying the 'group by' information may be done by iterating on the results of the Query.getGroubBy() and adding the colu

This looks like a bug in store()

I have a class A representing table TA defined as follows: class A { private Long sourceId; private Long targetId; ... TCorporation source; TCorporation target; } If I set the sourceId to new Long(1234) and source=null the INSERT statement generated blanks out the source id. Anybody else

Re: Inner Join on separate data bases

Sorry, that is supposed to be "inner join on separate data bases". D'oh. Charlie Charles N. Harvey III wrote: Hello. I was wondering if it was possible to join two objects that are mapped to two separate DBs. SELECT p.name, p.email, e.title, e.position FROM users.dbo.PERSON AS p INNER JOIN office

Inner Join on separate tables

Hello. I was wondering if it was possible to join two objects that are mapped to two separate DBs. SELECT p.name, p.email, e.title, e.position FROM users.dbo.PERSON AS p INNER JOIN office.dbo.EMPLOYEES AS e ON e.employee_id = p.person_id WHERE e.title = 'Manager' I have tw

Re: Help, I'm stuck and I can't get out! (Infinite Loop)

It isn't a bug. Actually, it's a "Feature by design". Since I don't maintain cache of objects (this is the behaviour of EmptyCache), there is no way to know that the object is loaded. So it will load. If the loaded object has references to the first object, it will load the first object again, an

Re: JDO Collections

> Oh yes the certainly can be a good idea. I'm not against this, but with > no current java mechanism for automatically enforcing this sort of > thing, effort/time must be expended to enforce it manually, and thus I > would only do it where it appears to be critical (such as an obvious way > th

Re: JDO Collections

This is not necessarily an optimization but rather a removal of unnecessary genericity. Let me explain: in java when you use a collection, you simply say all objects in it are of type Object or subtypes thereof. This may be well but usually you only mean to put objects of type SomeBaseType or subt

Re: JDO Query Performance

SO all you can do for the moment is to wait for our own full JDO implementation that will not have such limitations. So when does this start? In fact it has already started. Have a look at the folder src/java/org/apache/ojb/jdo in the source distribution. This new implementation is

Re: Help, I'm stuck and I can't get out! (Infinite Loop)

For the slow people in the class, can you please explain this problem in a little more detail? If I have to tweak cache timeouts to get correct behavior on simple references, then there 's a bug hiding in here somewhere. Thanks. Edson Carlos Ericksson Richter wrote: Exists some circustantes t

Re: JDO Collections

On Mon, 9 Feb 2004, Gus Heck wrote: > According to the book I have (which is not the spec, but hopefully the > author has read and understood the spec) it has the following example: > > > > > > > > > > > > > > This looks like what you are describing, b

Transaction Question.

Folks, Is Nested Transaction supported within ODMG? assuming we have the following : within the same Thread. Transaction1 start Transaction2 start Transaction2 finish Transaction1 finish. Thanks. -

RE: JDO Query Performance

Hi Gus, > -Original Message- > From: Gus Heck [mailto:[EMAIL PROTECTED] > Sent: Monday, February 09, 2004 4:42 PM > To: OJB Users List > Subject: Re: JDO Query Performance > > > > > > > SO all you can do for the moment is to wait for our own full JDO > > implementation that will not ha

RE: Transaction Problem.

Hi, "If you use Identity queries you will load objects from the cache. But if you use criteria based queries an SQL query is executed against the DB." If I under stand correct then even if I use Identity it won't work because the data is not in the cache until commit is done. Thanks. -Orig

RE: Transaction Problem.

If you use Identity queries you will load objects from the cache. But if you use criteria based queries an SQL query is executed against the DB. > -Original Message- > From: Ziv Yankowitz [mailto:[EMAIL PROTECTED] > Sent: Monday, February 09, 2004 4:34 PM > To: OJB Users List; [EMAIL PROTE

Re: JDO Collections

So does this mean I can only have collections of a specific element type? What about collections that hold multiple types? Is it impossible to store them? I think that specification of element types is supposed to be optional for JDO. (allowing the implementation to optimize if it is specified

Re: JDO Query Performance

SO all you can do for the moment is to wait for our own full JDO implementation that will not have such limitations. So when does this start? Will it use the current JDO related classes or rewrite them? I might be interested in pitching in, a bit when it does if I can find a small chunk or two

Re: Transaction Problem.

Hi again, Ziv Yankowitz wrote: Hi, Armin wrote: No, problem is when object was only pushed to cache it's not possible to query the object and you run into the same problem as before.Thanks. If I under stand correctly then using query by Identity with the Broker Api will first query the cach

AW: foreign key is not being updated...

Wally you are a live saver!!! I just forgot to set the reference object person in class activity. Now it works! thanks for your hint. -Ursprüngliche Nachricht- Von: Gelhar, Wallace Joseph [mailto:[EMAIL PROTECTED] Gesendet: Montag, 9. Februar 2004 15:27 An: OJB Users List Betreff: RE: fo

RE: Transaction Problem.

Hi, Armin wrote: > No, problem is when object was only pushed to cache it's not possible to > query the object and you run into the same problem as before.Thanks. If I under stand correctly then using query by Identity with the Broker Api will first query the cache, so if the object was cached

RE: Transaction Problem.

No. You have to follow the steps that Armin explained. > -Original Message- > From: Ziv Yankowitz [mailto:[EMAIL PROTECTED] > Sent: Monday, February 09, 2004 4:05 PM > To: OJB Users List; [EMAIL PROTECTED] > Subject: RE: Transaction Problem. > > > Hi, > > Thanks for the response. > > i

Re: Transaction Problem.

Hi, Ziv Yankowitz wrote: Hi, Thanks for the response. if I understand correctly the flush writes the object to the db and cache. yep! Is there a way to write only to the cache and not to the db and then when commit accurse the db will be hit. No, problem is when object was only pushed to cache

RE: Transaction Problem.

Hi, Thanks for the response. if I understand correctly the flush writes the object to the db and cache. Is there a way to write only to the cache and not to the db and then when commit accurse the db will be hit. Thanks. -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] S

Re: Transaction Problem.

Hi, Ziv Yankowitz wrote: Folks, I'm using ODMG API . I'm trying to insert an object and query the object in the same transaction before the object was committed is this possible. You have to use a proprietary extension method of Transaction: ((TransactionExt) tx).flush() regards, Armin thanks.

Transaction Problem.

Folks, I'm using ODMG API . I'm trying to insert an object and query the object in the same transaction before the object was committed is this possible. thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comma

RE: foreign key is not being updated...

Hi Dirk, It looks like you are setting the FK and not the reference object. Therefore, on an update, OJB is resolving and updating the FK of the set reference object (null!). If you want to continue setting the FK, you must call pb.resolveReference("reference"); to set the object prior to the

Re: Help, I'm stuck and I can't get out! (Infinite Loop)

Exists some circustantes that results in infinite loop due to use of EmptyCache with two way navigable references. Are you using this? If yes, try to set a in the recerenced bean with a very low time-out (let's say, 1 sec). It solved almost vast majority of my cases. Best regards, Edson Richt

AW: foreign key is not being updated...

I am still struggling to update a foreign key (see below). I try pm.beginTransaction; while(thereAreMoreSchedules){ schedule.set(startDate); schedule.set(endDate); activity.setTimestamp(...) activity.setPersonId(personId); //1:N reference from person to activity

Object Cache question.

Folks, We have a ClassDiscriptor with object cache configured. we are using ODMG API to insert an object. Can we force ODMG to cache the object before commit and then in case of Rollback to call remove. Thanks. - To unsubscrib

Re: GroupBy clause ignored in PersistentBroker.getCount( Query query)

Hi Jakob, yup I tried to 'patch' the getCount() method and also saw that setting the copy-groupBy flag to true wouldn't solve the problem. copying the 'group by' information may be done by iterating on the results of the Query.getGroubBy() and adding the columns to the report query. however,

Re: Object Reference Descriptor.

Hi, Ziv Yankowitz wrote: Folks I am trying to configure an Object Reference Descriptor dynamically can someone please point me to a sample. AFAIK there is no example in docs, but have a look into ...broker.metadata.RepositoryXml#startElement method (line 511). Here you can see how we map metadat

RE: Using Ojb in Applications with large DB tables

Hi, > -Original Message- > From: Var George [mailto:[EMAIL PROTECTED] > Sent: Friday, February 06, 2004 8:35 PM > To: [EMAIL PROTECTED] > Subject: Using Ojb in Applications with large DB tables > > > Is this a bug in OJB (count() vs last.getrow())? I can't verify this at the moment...