website updated

2003-02-13 Thread Thomas Mahler
Hi all, Months of waiting have paid: I finally managed to update the website. Our old home at Jakarta is now removed and does only contain a forwarding to the new db.apache.org site. Please use the new site at http://db.apache.org/ojb and report all inconsistenties you may find. cheers, Thomas

Query on object with reference to object with extents

2003-02-13 Thread lsinger
We are doing a query on an object which has a 1:1 reference to another object. The other object is the base class of a table which has an extent with 6 variant classes. We are using an ojbConcreteClass to store the class type in the table. The object we are doing a query on is also an extent. Our

RE: problems loading repository.xml using resin

2003-02-13 Thread Ryan Vanderwerf
I had to do this to make other xerces work with resin (stick it in the bottom of resin.conf: Ryan -Original Message- From: Klaasjan Brand [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 9:06 AM To: OJB Users List Subject: Re: problems loading repository.xml using resin

is this an old .97 bug? (sequencing)

2003-02-13 Thread Ryan Vanderwerf
I've experienced a weird problem in my servlet environment (caucho resin 1.2.6, RH8, sql server 2k, 0.9.7 using PB API) with the sequence manager. Until recently my application has run on 1 application server, with a grab size of 10 for sequences (I'm using the HI_LO seq manager) which was working

Re: How to do Lazy Foreign Keys?

2003-02-13 Thread David Warnock
Charles, http://db.apache.org/ojb/tutorial3.html#using%20proxy%20classes discusses the use of proxies in detail. Yes and now on the nth reading it is starting to make sense. I had seen the proxy stuff for collections but missed it for singles. Our Object model couldn't support that (not in a

Re: Relationship problem.

2003-02-13 Thread David Warnock
Jakob, Many thanks. I am starting to get this worked out now. I now have this relationship working OK and am working on a) making it lazy by using VirtualProxy b) getting the collection relationship working in the opposite direction, first without proxy and then with proxy. Thank for your hel

Re: Relationship problem.

2003-02-13 Thread Jakob Braeuchi
hi david, in the reference-descriptor foreignkey you have to use a field defined in the same class-descriptor as the reference-descriptor. the class-descriptor for state lacks the field 'countryStateId' as indicatet in the stack trace. class="org.visres.contact.data.State" t

Re: foreign keys... last time I swear :)

2003-02-13 Thread Robert S. Sfeir
Ok I figured out the missing link. The missing link is that when you have a fk reference in one table to another the other table needs to have a collection with an inverse fk to the first since in the example I gave originally I had a many to one relationship between brokers and homes, many ho

Re: Why is this done this way?

2003-02-13 Thread David . Corbin
That makes some sense to me. We're using ODMG, and I noticed this happening on "supporting objects" (i.e., not an object *I* locked). Which layer is responsible for determining all the objects that need to be written? ODMG or PB? David |-+---> | |

Re: custom collection proxies

2003-02-13 Thread Jakob Braeuchi
hi all, forgot to mention that the custom CollectionProxy class must provide a constructor with the same signature as ListProxy does: public MyCustomCollectionProxy(PBKey aKey, Class aCollClass, Query aQuery) ... jakob Jakob Braeuchi wrote: hi all, the class to be used for CollectionProxy c

Re: Why is this done this way?

2003-02-13 Thread Thomas Mahler
Hi David, [EMAIL PROTECTED] wrote: Can someone explain the WHY behind this code fragment? It's from org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Object). I thought there was a state kept, to determine if it's an insert or new. The PB is a very low level kernel. It does not track

Re: custom collection proxies

2003-02-13 Thread Jakob Braeuchi
hi all, the class to be used for CollectionProxy can now be configured in OJB.properties: ... # # CollectionProxy class #---

Oracle/OJB bug with 0.9.9

2003-02-13 Thread David . Corbin
Well, after severe hair pulling and teeth gnashing. I've found a bug. I don't know if it's OJB or the oracle driver. Here's what happens: Here's the brunt of the problem - I turn off batch-mode in my connector, but OJB ignores that essentially, and turns it on later when the driver's metadata

Re: report query question

2003-02-13 Thread Thomas Mahler
Hi David, David Mitchell wrote: I have a question regarding report queries. What is the purpose of having to provide a OJB persistent class reference when supplying the query code that will be executed? I can see why you need to provide the following String array with the names of the fields

Why is this done this way?

2003-02-13 Thread David . Corbin
Can someone explain the WHY behind this code fragment? It's from org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Object). I thought there was a state kept, to determine if it's an insert or new. Having to load the object from the database just to write it back out seems very wasteful.

Second Attempt at Question - Per class caching, MetaObjectCacheImpl

2003-02-13 Thread Andrew Gilbert
We have some interest in per class caching behavior. For example, class Person uses cache, class Group uses cache, etc. Any examples of actually using MetaObjectCacheImpl or is it just provided as an example implementation? Believe we can use it providing we have our own CacheFactory and a s

RE: foreign keys... last time I swear :)

2003-02-13 Thread Matthew Baird
now I'm confused. let's recap: - objects are related based on foreign keys, right? - you can load objects in ojb based on any value, either in PB or in odmg, so a select myclass where myclass.somerelatedobject.someattribute=? will work. OJB will generate the appropriate joins for you. queries ca

0.9.9 vs. P6Spy vs. Tomcat

2003-02-13 Thread sclark
Does anybody else have P6Spy working with 0.9.9 and Tomcat? I have had it working with 0.9.7 and 0.9.8, as well as with various intermediate bits from the CVS HEAD. But now that I've upgraded to 0.9.9, I don't get any output in my spy.log (actually, I get a bunch of startup messages in there,

Re: AW: How to do SQL MIN MAX functions ??

2003-02-13 Thread Thomas Mahler
Hi again Stefan, Stefan Schlösser wrote: On 13 Feb 2003 at 12:21, Mahler Thomas wrote: getCount does exist for OJB internal purposes. I hope this does not mean it will be deleted from the interface at some point ... We have a long tradition not to remove existing methods from public inter

RE: foreign keys... last time I swear :)

2003-02-13 Thread David Mitchell
Ok, I guess I pretty much understand it. You use the reference name to do a lookup on the referenced object. So if I want to join two tables on something other than a primary key, I need to use a hand-written sql query. Im okay with that. I believe I will also have to use hand-written sql for my

RE: foreign keys... again

2003-02-13 Thread Matthew Baird
the docs may not be clear, but the examples are pretty clear. you have to map the field first: example: <--- a conversion (optional) then the referenced object: <-- the java type <-- the field-descriptor name that will be used to find the foreign key value. now, the class you are

Re: foreign keys... again, joins, and OJB templates

2003-02-13 Thread Robert S. Sfeir
To tell you the truth for all I care I can setup the join in the db or not at all. I just wanted to setup the fk syntax for development purposes only. Foreign keys always slow down insert, update and deletes and for performance reasons I don't put them in. So since this is just a development

Re: report query question

2003-02-13 Thread Jakob Braeuchi
hi david, the class is used to get the classdescriptor describing the table, the columns etc. from repository. field names are translated into column names using this descriptor. hth jakob David Mitchell wrote: I have a question regarding report queries. What is the purpose of having to prov

report query question

2003-02-13 Thread David Mitchell
I have a question regarding report queries. What is the purpose of having to provide a OJB persistent class reference when supplying the query code that will be executed? I can see why you need to provide the following String array with the names of the fields you want, but why do I need to p

RE: foreign keys... again, joins, and OJB templates

2003-02-13 Thread Andrew Gilbert
I am new to OJB but have some input. I could be smoking something, so be warned... If Product can only be associated with one Group, shouldn't one assume you would be referring to the Group using it's unique identity (primary key)? How else can you guarantee effeciency and uniqueness? In the Co

RE: foreign keys... again, joins, and OJB templates

2003-02-13 Thread David Mitchell
Im having the same issue exactly, and was trying to figure out how to put the question! I have two tables, Product and Group. A product can only be in one group, but a group has many products. Here are representative schemas: table Product ndx int primary key, name varchar,

Re: AW: How to do SQL MIN MAX functions ??

2003-02-13 Thread Jakob Braeuchi
hi, report query is the way to go: ReportQueryByCriteria query; Criteria crit; System.out.println("\nreport (sum(test) with name like '%er'"); crit = new Criteria(); crit.addLike("name", "%er"); query = new ReportQueryByCriteria(Person.class, crit);

foreign keys... again

2003-02-13 Thread Robert S. Sfeir
Still a bit confused, If I have this: ... and I want to setup a foreign key from assignedToID to another table called Users and the column there is called userID I added this as the foreign-key reference: But it doesn't make any sense, if I put assignedToID in the field-ref, how does

OJB132

2003-02-13 Thread oliver . matz
I found another bug in the treatment of arrays in combination with indirection tables. Please see OJB132 for a junit test to reproduce. Olli -- Dr. Oliver Matz ppi Media GmbH Deliusstraße 10 D-24114 Kiel phone +49 (0) 43 1-53 53-422 fax +49 (0) 43 1-53 53-2 22 email mail

Need helping debugging double insert.

2003-02-13 Thread David . Corbin
I have the following model: a P contains a collection of Rs a P also contains an explicit reference to one of the Rs it contains an R contains a single PS a PS contains a single OS, a single AS and several collections of other things that are all empty for this problem. I construct a P, with sing

Re: AW: How to do SQL MIN MAX functions ??

2003-02-13 Thread Stefan Schlösser
On 13 Feb 2003 at 12:21, Mahler Thomas wrote: > getCount does exist for OJB internal purposes. I hope this does not mean it will be deleted from the interface at some point ... > If you want to work with resulsets instead with full entity objects use the > reportquery mechanism. I would very muc

AW: broker.store() always no distinction between insert or update ??

2003-02-13 Thread Mahler Thomas
Hi STefan, http://jakarta.apache.org/ojb/apidocs/org/apache/ojb/broker/PersistenceBroke r.html#store(java.lang.Object,%20org.apache.ojb.broker.util.ObjectModificati on) allows to specify wether to use isert or update, by a ObjectModification (http://jakarta.apache.org/ojb/apidocs/org/apache/ojb/b

broker.store() always no distinction between insert or update ??

2003-02-13 Thread Stefan Schlösser
Hi, I very much like the interface store of the broker which shields me from the differences between insert or update. Sometimes however I would like to prevent an update when an insert is not possible. E.g a legacy application does not allow some records to be updated but only to be inserted. Wh

RE: problems loading repository.xml using resin

2003-02-13 Thread Ricardo Tercero Lozano
I put this conde in resin.conf inside a tag. . I don't know if is used only for the host definition or if it is global for all hosts defined. Ricardo. -Mensaje original- De: Klaasjan Brand [mailto:[EMAIL PROTECTED]] Enviado el: jueves, 13 de febrero de 2003 1

Re: problems loading repository.xml using resin

2003-02-13 Thread Klaasjan Brand
On Thu, 2003-02-13 at 14:27, Leandro Rodrigo Saad Cruz wrote: > I use resin to develop with ojb, but I put my parsers on WEB-INF/lib That's needed when using Xerces too, but how do you set up OJB so it's using Xerces to parse it's repository. The only way I know with Resin is to use a server globa

Re: Could not found autoincement attribute for class: org.apache.ojb.odmg.collections.DListImpl

2003-02-13 Thread Armin Waibel
Seems you don't fully update. Do you replace the repository_internal.xml file? regards, Armin - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 1:50 PM Subject: Could not found autoincement attribute for class: org.apache.ojb.odmg.col

Re: problems loading repository.xml using resin

2003-02-13 Thread Leandro Rodrigo Saad Cruz
I use resin to develop with ojb, but I put my parsers on WEB-INF/lib On Thu, 2003-02-13 at 06:15, Klaasjan Brand wrote: > Hi, > > We're using OJB 0.9.9 for a web application which has to be deployed on > Resin. The app works fine on Tomcat, but when deployed on Resin I get > the following error:

Re: reference-descriptors

2003-02-13 Thread Robert S. Sfeir
On Thursday, Feb 13, 2003, at 00:23 US/Eastern, Matthew Baird wrote: your class com.lawton.business.BrokersToHomes must have a getter and setter for "homeID" that sets/gets a HomeBO object. aha, there is the major missing piece. Makes sense. So I would need BOTH the bHomeID that is in the B

Could not found autoincement attribute for class: org.apache.ojb.odmg.collections.DListImpl

2003-02-13 Thread Matthias . Roth
Hi, I get the following warnig: Could not found autoincement attribute for class: org.apache.ojb.odmg.collections.DListImpl then java.lang.NullPointerExceptionr is thrown in Class DListImpl.generateNewId() have some body an Idee where the problem is? With the old 0.9.7 Version every thing works f

Re: [patch] Re: PBKey and OJB 0.9.9

2003-02-13 Thread Jason Mihalick
I've got everything working great now too. Thanks again. -- Jason - Original Message - From: "Shannon Ewing" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 5:12 PM Subject: RE: [patch] Re: PBKey and OJB 0.9.9 > Works

AW: How to do SQL MIN MAX functions ??

2003-02-13 Thread Mahler Thomas
Hi, > Hi Jens, > > OJB defines a layer between my java app and a database. Since the > repositiory file contains a description of the tables and column > names I would think it to be bad design on my part if I repeated that > information some-where hard-coded in my programm by doing a direct >

RE: How to do Lazy Foreign Keys?

2003-02-13 Thread Charles Anthony
Hi, http://db.apache.org/ojb/tutorial3.html#using%20proxy%20classes discusses the use of proxies in detail. Essentially, if you want to use proxies for a SingleReference they ultimately will have to be interfaces so that OJB can generate a DynamicProxy for them. Our Object model couldn't support

How to do Lazy Foreign Keys?

2003-02-13 Thread David Warnock
Hi, I have solved my earlier problem with simple foreign key relationships and they now work. But how do I avoid loading the parent object before it is required? I know I can use a single proxy for a whole collection BUT what is the equivilent for single foreign key relationships like this

Pb with MySQL

2003-02-13 Thread Jean-Paul Le Fèvre
In a previous post I mentionned a couple of problems found when I tried to switch to MySQL. The workaround was to restart from a fresh new distrib. It seems that it not possible to change the database once hsqldb has been set up. 1) A kind of target 'cleandb' should be present in the build.xm

Re: Problem with start broker with OJB 0.9.9 with MsSQLServer

2003-02-13 Thread Armin Waibel
Hi Matthias, this was a known bug in 0.9.9, was fixed: - Original Message - From: "Armin Waibel" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 10:57 AM Subject: [patch] Re: PBKey and OJB 0.9.9 > Hi Jason, Shannon, > >

problems loading repository.xml using resin

2003-02-13 Thread Klaasjan Brand
Hi, We're using OJB 0.9.9 for a web application which has to be deployed on Resin. The app works fine on Tomcat, but when deployed on Resin I get the following error: [BOOT] ERROR: Error in instantiation of PersistenceBrokerFactory class Could not read repository class descriptor data, using repo