Re: Oracle date tip

2004-02-20 Thread Robert S. Sfeir
I may well have... I always figured that since you can't make a column in an Oracle table of type timestamp that it was just an Oracle quirk. Or, to avoid sticking my neck out too far again, whenever I tried using timestamp as a column type in my Oracle databases, I've gotten an error. In

Re: Re: Out of memory error (3)

2004-02-20 Thread Edson Carlos Ericksson Richter
I don't know if help, but analizing Vector I've seen that when need more space, it double allocated space. ArrayList, at other side, does a less agressive approach (but is slower), and ojb has support for ManageableArrayList for collections (set collection-class). Of course, you should use Proxy

Re: ODMG: Object modifications outside transactions

2004-02-20 Thread Rainer Klute
On Fri, 20 Feb 2004 14:13:40 +0100 Mahler Thomas [EMAIL PROTECTED] wrote: I think that you encounter an interference of the cache. Please try if clearing the cache right before the secong OQL query solves the problem. How can I do this? (It won't work with the ODMG API, of course.) If this

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
hi paul, i'm sorry i forget that ojb manipulates the criteria in addLike. imo it would be the best to pass the criteria withou any modifications to the dbms. what do you think about this ? jakob Nase, Paul R. wrote: Adding a like parameter as the link suggests (addLike(attribute,%[%]%)) will

RE: Query with criteria - like using '%' or '_'

2004-02-20 Thread Nase, Paul R.
It shouldn't matter what db is being used, I should be able to find any fields containing a '%' or a '_' regardless. The SQL specification allows for this by allowing the ESCAPE parameter. I modified the Criteria.java (generateSqlSearchPattern() method) and the SqlQueryStatement.java

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
hi paul, i'd prefer to have the whole escape handling in one place, in critria. also i do not know if the escape handling is platform independent. jakob Nase, Paul R. wrote: It shouldn't matter what db is being used, I should be able to find any fields containing a '%' or a '_' regardless. The

SequenceManagerNextValImpl, buildSequence and Managed Connections

2004-02-20 Thread Gary
We are using WebSphere JTA for managed connection support with Oracle. When an insert occurs and the sequence doesn't exist, the sequence manager code tries to build a sequence on the database. However, a commit is done implicitly after any DDL statement (such as CREATE SEQUENCE). This then

Re: Fw: Problem with inheritance mapping

2004-02-20 Thread Jakob Braeuchi
hi peter, i committed the fix. jakob Peter Wieland wrote: Hi Jakob, the code changes seem to work well. Thank you very much. I'll tell if further problems occur. Thank you for your help, Peter hi peter, please replace the method addJoin in SqlQueryStatement with the following:

RE: Query with criteria - like using '%' or '_'

2004-02-20 Thread Nase, Paul R.
I don't think there are any platform issues, we aren't talking about path names to look for files or anything like this. We are simply Talking about an SQL92/SQL98 feature that is not being utilized. This character could have been anything, I just so happened to pick the '\' character because

Re: Problems with JDO cache (more info)

2004-02-20 Thread Gus Heck
I'm getting the impression noone is reading this thread but me, but for the sake of anyone who searches later, I have determined the following: the JDORI puts objects in the cache, before calling jdoPreStore. Since o.a.o.broker.Identity reflects out the values of the Primary keys during

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
hi paul, Nase, Paul R. wrote: I don't think there are any platform issues, we aren't talking about path names to look for files or anything like this. We are simply Talking about an SQL92/SQL98 feature that is not being utilized. This character could have been anything, I just so happened to

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
hi paul, Nase, Paul R. wrote: Jakob, i just don't see why we can't construct the whole string in criteria. in appendSelectionCriteria you simply append ESCAPE '\\' . why can't this be done in criteria#generateSQLSearchPattern ? We cannot just append this to the search pattern, because when the

Re: JOIN and aliases...is this a bug?

2004-02-20 Thread Jakob Braeuchi
hi alessandro, could you please post the class-descriptors ? jakob Alessandro Villamaina wrote: Hi all, I have the following class declaration (pseudo code): class DBObject private String name private Collection attributes class DBAttribute private String name private String value

Re: Extent problem with ODMG

2004-02-20 Thread Jakob Braeuchi
hi steve, imo OQL is not the problem here. have you tried to query for AccomplishmentImp, just to see if 'site' can be resolved ? may be you should use the latest from repository. jakob Steve Clark wrote: I'm having a problem with extents in ODMG. OJB is generating incorrect (and, in fact,

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
hi paul, yes, now i understand. i did also some experiments and i saw that my solution was not working. i'll have a look at the separate LikeCriteria now. jakob Nase, Paul R. wrote: Jakob, Perhaps I am misunderstanding your question. When you say why can't we add the ESCAPE to the search

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
hi paul, seems like mysql does not like '\'. it works with '|' : SELECT A0.LASTNAME,A0.FIRSTNAME,A0.ID FROM PERSON A0 WHERE A0.FIRSTNAME LIKE 'h%|%' ESCAPE '|' jakob Jakob Braeuchi wrote: hi paul, i implemented the escape handling with LikeCriteria which results in the following sql:

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
hi paul, i did some tests with ms-access. first it uses * instead of %, so replacing * is not an option. second it does not like ESCAPE. i think ms-access uses [*] to escape *. one may argue that ms-access is not a real dbms; but ojb claims to support it... jakob Jakob Braeuchi wrote: hi

Re: Object references... Fetched in a separate thread?

2004-02-20 Thread Antonio Gallardo
Hi Sean: AFAIK, this would not happen. BTW, what version are you using? Best Regards, Antonio Gallardo Sean Dockery dijo: Hello there. I've had a curious experience recently with OJB, and I was wondering if someone could confirm my speculations about the behaviour. Suppose I have two

Re: Object references... Fetched in a separate thread?

2004-02-20 Thread Rainer Klute
Hm, reminds me of the problem I encounter with the cache. Depending on which cache implementation I use my application behaves differently. In your case, could it be the garbage collector removes your ProductCategory instance while your main thread is asleep? Best regards Rainer Klute