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

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

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

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 tw

Object references... Fetched in a separate thread?

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 objects... Product and ProductCategory. The Product object carries both a productCategoryId field as well as a reference field produ

Re: Problems with JDO cache (solved, sort of)

This strategy has worked but only after I took to caching PersistenceManagers on a per-thread basis, hopefully this won't bite me later... I almost turned it into a single PM for the whole app but that seems too extreme. If I don't do this I keep getting JDOUser Exceptions about Object beloging

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

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 paul

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

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: SELE

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

hi paul, i implemented the escape handling with LikeCriteria which results in the following sql: SELECT A0.LASTNAME,A0.FIRSTNAME,A0.ID FROM PERSON A0 WHERE A0.FIRSTNAME LIKE 'B\%' ESCAPE '\' unfortunately this is not accepted by mySql. it works for hsqldb and sapdb (maxdb). jakob Nase, Paul

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

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 ar

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

Jakob, Perhaps I am misunderstanding your question. When you say "why can't we add the ESCAPE to the search argument?", do you mean add it like the following? criteria.addLike("*\\%* ESCAPE '\\'") // to search for any text containing // the '%'

Re: Extent problem with ODMG

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, in

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

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 whe

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

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 th

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

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 sql is actually generated

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

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 pic

Re: Problems with JDO cache (more info)

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 additio

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

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 thi

Re: Fw: Problem with inheritance mapping

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: priv

SequenceManagerNextValImpl, buildSequence and Managed Connections

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 fail

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

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

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

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 (appendSele

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

I assumed (AKA ass-u-me) that OJB does a database independent wildcard replacement. For example, MSSQL uses % as the wildcard character, but ojb will replace a * with the database specific wildcard character. This would require some syntax for escaping characters that I'm not sure is present (ie h

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

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: ODMG: Object modifications outside transactions

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

Re: Re: Out of memory error (3)

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 f

Res: Re: Out of memory error (3)

It has 1051 registers.   ---Mensagem original---   De: OJB Users List Data: 02/20/04 04:15:22 Para: OJB Users List Assunto: Re: Out of memory error   Hi,   Glauber Andrade wrote: > My system doesn't work anymore. I got this error when I try to get the > object Prestador (+- 600 regis

Re: Oracle date tip

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.

RE: ODMG: Object modifications outside transactions

Hi Rainer, 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. If this is the case I think using the PerBroker cache implementation should solve the issue. cheers, Thomas > -Original Message- >

ODMG: Object modifications outside transactions

>From the ODMG tutorial and the API doc I had the impression that a persistant object >has to be modified inside a transaction in order to become effective in the database. My application begins a transaction, retrieves a persistant object from the database using an OQLQuery and closes the trans

Res: Re: Out of memory error (2)

   The Object is simple. It is working fine for 50, 100 objects... But When I have 600 objects I got the out of memory error. I have tested in 3 different computers with 256Mb (ram), starting java with -Xmx256m   query = new QueryByCriteria(NomePrestador.class, crit); iter =

Res: Re: Out of memory error

Thanks Thomas,   How do I start the server with more heap memory? I use -Xmx256m only.   Glauber    ---Mensagem original---   De: OJB Users List Data: 02/20/04 04:15:22 Para: OJB Users List Assunto: Re: Out of memory error   Hi,   Glauber Andrade wrote: > My system doesn't work anymo

RE: OJB and LOB

Hi Nicolas, since I added CLOB yesterday loading to Torque generated classes I could help you with a few samples and the source code in case you get no ready-to-use solution for OJB. Cheers, Siegfried Goeschl -Original Message- From: Nicolas Arni-Bloch [mailto:[EMAIL PROTECTED] Sent: F

OJB and LOB

Hi all, I'm using OJB 1.0.rc5 and oracle9i. I look for a howto about LOB with OJB. The only thing that I found is this url : http://db.apache.org/ojb/howto-use-lobs.html the discussion about large objects and Lob is very interesting but the howto stop with Strategy 1: Using streams for LOB I/O.