Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
http://article.gmane.org/gmane.comp.jakarta.ojb.user/4038/match=rownum for > an example of adding the appropriate SQL to a query... > > Note, this will tie your application to Oracle. > > Cheers, > > Charles. > > > -Original Message- > > From: Andy Czerwonka [mailto:[E

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
or and move to the next. If no error, I delete after processing. So, it's a challenge setting the endIndex() because I never know how many 'error' records are sitting at the top of the queue. On November 11, 2003 7:30 am, Andy Czerwonka wrote: > the setStartAtIndex() and setE

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
November 11, 2003 6:49 am, Charles Anthony wrote: > Which Database ? > > > -Original Message- > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > Sent: 11 November 2003 13:55 > > To: OJB Users List > > Subject: Re: only grab 10 records > > > > &

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
Oracle 9i On November 11, 2003 6:49 am, Charles Anthony wrote: > Which Database ? > > > -Original Message- > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > Sent: 11 November 2003 13:55 > > To: OJB Users List > > Subject: Re: only grab 10 recor

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
OJB. > > For an explanation of the reasons why, see > http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/match=paging+per >f ormance+issues > > Cheers, > > Charles. > > > -Original Message- > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > >

only grab 10 records

2003-11-11 Thread Andy Czerwonka
Does anyone know if its possible to do something like this in OJB: select * from table where criteria but only return me a maximum of 10 records. Is this possible? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comm

RE: Allocation of auto incremented primary keys between 2 JVMs

2003-11-03 Thread Andy Czerwonka
gt; Moreover, MS Sql does not support native datbase sequences - and, as Mark > mentions, he is using MS SQL. > > Cheers, > > Charles. > > > -Original Message- > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > Sent: 03 November 2003 14:57 &g

Re: Allocation of auto incremented primary keys between 2 JVMs

2003-11-03 Thread Andy Czerwonka
OUCH!! If this doesn't work, the it's a MAJOR problem. Has someone verified in using the PB API in a multi-system environment? Given that it's using a database sequence, it shouldn't be a problem. It's got to be a bug. On Mon, 2003-11-03 at 04:37, Mark Rowell wrote: > Hi > > Further to my mail

help with auto-update and/or auto-delete

2003-10-30 Thread Andy Czerwonka
If I have a 1..n relationship in my object, eg: Car--->Parts and I do something like: Car car = new Car(); car.getParts().add(new Engine()); broker.store(car); I expect one record in my Car table and one in my Parts table. Perfect - that's what I have. Now, I do a: car.setParts(new ArrayList

RE: problem/question with getIteratorByQuery()

2003-10-30 Thread Andy Czerwonka
You need it for the lazy instantiation via the iterator On Thu, 2003-10-30 at 09:06, [EMAIL PROTECTED] wrote: > > get rid of the transaction... why are you doing a > > broker.close() before > > you starting iterating? Not sure what you are trying to do. > > I'm doing a broker.close() to be sure

Re: problem/question with getIteratorByQuery()

2003-10-30 Thread Andy Czerwonka
get rid of the transaction... why are you doing a broker.close() before you starting iterating? Not sure what you are trying to do. getIteratorByQuery() is a lazy version of getCollectionByQuery(). If does a count when creating the iterator and a select on each iter.next(). your code should loo

Optimistic Locking using the PersistenceBroker API

2003-10-28 Thread Andy Czerwonka
Has anyone implemented an optimistic-locking strategy (I actually may need a Pessimistic strategy - not sure yet) using the PersistenceBroker API? Can you point me in the right direction? -andy - To unsubscribe, e-mail: [EMAIL

Re: Oracle Auto-Increment

2003-10-28 Thread Andy Czerwonka
Turn batch-mode off and then try your test. If it works, you'll need the fix for this. You can either patch ti yourself, or take the latest CVS image. On Tue, 2003-10-28 at 10:08, Ronald Paloschi wrote: > Hi Danilo, > > I will try to explain a little better (forgive the errors... IÂm > brazilli

RE: Auto incremented primary key and extents

2003-10-28 Thread Andy Czerwonka
autogenerated keys using the DefaultSequenceManagerImpl are not assigned on broker.store(obj) using batch-mode=true. I'm wondering if the hash gets messed up (ordering) on the batch. On Mon, 2003-10-27 at 05:25, Mark Rowell wrote: > Armin > > No the only thing I changed was OJB.properties. > >

Re: OutOfMemoryError using commons-lang 2.0 and OJB 1.0rc4

2003-10-25 Thread Andy Czerwonka
How many records are you bringing back? On Fri, 2003-10-24 at 18:15, Michel Marti wrote: > Hello, Since I upgraded commons-lang to version 2.0 (due to the > "display" taglib requiring it), OJB (1.0rc4) always throws a > OutOfMemoryError when calling getCollectionByQuery() on the > defaultPersisten

someone please tell me...

2003-10-24 Thread Andy Czerwonka
How could batch-mode=true be slower than batch-mode=false??? OJB rc4 + small batch-mode hack (Mark Rowell) Oracle9i ojdbc14.jar - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: mapping problem or something VERY wierd...

2003-10-23 Thread Andy Czerwonka
The mapping needed the obvious primary key On Thu, 2003-10-23 at 17:15, Andy Czerwonka wrote: > In looking at the SQL, and update is done when I do the store.. hey I > think the PK is NOT unique... yup - it's not unique... that's gotta be > the problem... > > On

Re: mapping problem or something VERY wierd...

2003-10-23 Thread Andy Czerwonka
In looking at the SQL, and update is done when I do the store.. hey I think the PK is NOT unique... yup - it's not unique... that's gotta be the problem... On Thu, 2003-10-23 at 16:07, Andy Czerwonka wrote: > I've got a simple 1..n association and I'm doing something li

mapping problem or something VERY wierd...

2003-10-23 Thread Andy Czerwonka
I've got a simple 1..n association and I'm doing something like this...(pardon the syntax... just trying to make a point) Parent parent = new Parent() Child c1 = new Child(parent); Child c2 = new Child(parent); parent.getChildren.add(c1); parent.getChildren.add(c2); broker.store(parent); broker.co

RE: problems with batch-mode=true

2003-10-23 Thread Andy Czerwonka
Okay, first of all, thanks for the fix Mark. Now that I have it working, can anyone explain why my performance just dropped about 20% after turning on batch mode? I reason I wanted a fix is because i was trying to get some better performance, not worsen then performance! HELP!!! On Thu, 2003-

Re: RE : problems with batch-mode=true

2003-10-23 Thread Andy Czerwonka
See Mark Rowell's posts to see the bug and fix. Thanks to Mark!! Cheers!! On Thu, 2003-10-23 at 06:53, Emmanuel Dupont wrote: > Please to tell you yhat we are three ! > > :) > > -Message d'origine- > De : Bonnie MacKellar [mailto:[EMAIL PROTECTED] > Envoyé : jeudi 23 octobre 2003 14:3

RE: refresh=true OR refresh=false

2003-10-23 Thread Andy Czerwonka
refreshed when the object is retrieved from the cache. > > The use of CollectionProxies prevents the actual materialization of all > object in colleciton until needed i.e. the full query is not actually > executed until the contents of the collection is accessed. > > Cheers, >

IllegalClassCastException when batch-mode=true

2003-10-22 Thread Andy Czerwonka
All my tests run fine with batch-mode off. As soon as I turn it on, BOOM... I get a IllegalClassCastException. I'm using Orcle 9.2 and ojdbc4.jar -andy - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mai

refresh=true OR refresh=false

2003-10-22 Thread Andy Czerwonka
In looking at the documentation, there isn't really anything descriptive regarding this attribute on collections/references. I'd like to turn it off, but I'm afraid. Should I be? Can someone help me understand this a little better so that I know what's going on? Is this a cache thing? -andy

Can't search by reference-descriptor object - Why?????

2003-10-10 Thread Andy Czerwonka
How come I can't do a query and use a reference-descriptor. It should work. Here's my code. Criteria crit = new Criteria(); crit.addEqualTo("identifierText", value); crit.addEqualTo("issuingAuthority", issuingAuthority); Query query = QueryFactory.newQuery(PersonIdentifier.class, crit, true); re

Can't search by reference-descriptor object - Why?????

2003-10-10 Thread Andy Czerwonka
How come I can't do a query and use a reference-descriptor. It should work. Here's my code. Criteria crit = new Criteria(); crit.addEqualTo("identifierText", value); crit.addEqualTo("issuingAuthority", issuingAuthority); Query query = QueryFactory.newQuery(PersonIdentifier.class, crit, true); re

Re: Objects in referenced collection don't auto delete

2003-09-27 Thread Andy Czerwonka
Something to do with the Cache I think. BTW - broker.deleteByQuery doesn't work but if I get a collection via the same query and delete each object - works fine. On Sat, 2003-09-27 at 09:12, Andy Czerwonka wrote: > Anyone see this before? > > What I'd like is when I remo

Objects in referenced collection don't auto delete

2003-09-27 Thread Andy Czerwonka
Anyone see this before? What I'd like is when I remove an object from a collection that is referenced by another object, and then store() the object, I'd like the collection to reflect that. It doesn't seen to work. The add worked fine. Failing Test Person found = PersonHome.getIns

FAQ for XDoclet

2003-09-25 Thread Andy Czerwonka
Is there an FAQ out there that'll show me how to use XDoclet to generate my .xml for my mappings? That'd be great. -- andy - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: PLEASE HELP!!!! No recursion??????

2003-09-23 Thread Andy Czerwonka
Need the auto-update to be "true" - off by default I guess thanks for all who were beginning to try and help me On Tue, 2003-09-23 at 08:08, Andy Czerwonka wrote: > So that you can see a pattern, I've attached the database results after > I run the test 3 times. > >

Re: PLEASE HELP!!!! No recursion??????

2003-09-23 Thread Andy Czerwonka
So that you can see a pattern, I've attached the database results after I run the test 3 times. On Tue, 2003-09-23 at 07:57, Andy Czerwonka wrote: > One more thing... > > One the one record in the database it does produce, the UNQ_ID = 1 and > the NXT_UNQ_ID = 2, just as expec

Re: PLEASE HELP!!!! No recursion??????

2003-09-23 Thread Andy Czerwonka
BTW - on a subsequent test that does the query again, it fails. I does only see the 1 record and doesn't build my linked list. Looks like there is some caching. Anyone know what I'm doing wrong here or do we just have a bug? On Tue, 2003-09-23 at 07:42, Andy Czerwonka wrote: >

Re: PLEASE HELP!!!! No recursion??????

2003-09-23 Thread Andy Czerwonka
can't persist the recursive behaviour. On Tue, 2003-09-23 at 07:50, Andy Czerwonka wrote: > BTW - on a subsequent test that does the query again, it fails. I does > only see the 1 record and doesn't build my linked list. Looks like > there is some caching. Anyone know what I

PLEASE HELP!!!! No recursion??????

2003-09-23 Thread Andy Czerwonka
I'm having a problem with a very simple mapping. I've went through all the docs and examples, and afaik, the mappings are right. I'll provide some context. Database create table LBRTRY_Q (UNQ_ID number(12) not null, MSG_TXT clob not / null, STTS_CODE number(8) not null, NXT_UNQ_ID number

Evaluation and CLOB... or not

2003-09-21 Thread Andy Czerwonka
Hi guys/gals, I've got a problem that I'd like to solve, and at the same time I'd like to evaluate OJB as a potential solution moving forward in a project I'm using. Anyway here' my issue. I've got a simple socket listener that listens for message from an HL7 message server. The listener simple

Re: OJB and Oracle 9ias

2003-09-15 Thread Andy Czerwonka
Oracle obviously deals with classpaths differently. In Tomcat, you either deployed the ojb jars contextually or in $TOMCAT_HOME/server/lib. I'd be that you need to drop them somewhere where the container knows to look. On Mon, 2003-09-15 at 08:25, Durham David Contr 805 CSPTS/SCBE wrote: > Hi al

RE: Xdoclet: How to use base-class properties with different colu mn names in children?

2003-09-12 Thread Andy Czerwonka
Outstanding On Fri, 2003-09-12 at 05:58, Thomas Dudziak wrote: > Yes, both the repository descriptor (aka repository_user.xml) and the > table schema (for Torque which then generates the tables in your > database) are generated by the xdoclet ojb module. > If you want to try it out, grab OJB f

RE: Xdoclet: How to use base-class properties with different colu mn names in children?

2003-09-12 Thread Andy Czerwonka
I'd love to learn how your using XDoclet with OJB. Are you generating both the DDL and the repository? On Fri, 2003-09-12 at 03:13, Thomas Dudziak wrote: > A field declared in the class javadoc comment is only then not anonymous > if there is a tagged field with that name in a base class of that

id in the class

2003-09-11 Thread Andy Czerwonka
link, where you don't need to store the id the aggregate? -- Andy Czerwonka Arctic Penguin Open Source Solutions Inc. (403) 547-8892 (403) 540-6133 (mobile) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comm