From thorntonjeremy@example.com Mon Dec 01 08:22:39 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 42704 invoked from network); 1 Dec 2003 08:22:39 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 08:22:39 -0000 Received: (qmail 61471 invoked by uid 500); 1 Dec 2003 08:22:11 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 61336 invoked by uid 500); 1 Dec 2003 08:22:11 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 61320 invoked from network); 1 Dec 2003 08:22:10 -0000 Received: from unknown (HELO ns8.sony.co.jp) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 08:22:10 -0000 Received: from mail6.sony.co.jp (mail6.sony.co.jp [83.161.120.155]) Received: from mail6.sony.co.jp (localhost [83.161.120.155]) by mail6.sony.co.jp (R8/Sony) with ESMTP id hB18MLP24115 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 17:22:21 +0900 (JST) Received: from calserv-u1.cal.sony.co.jp (calserv-u1.cal.sony.co.jp [83.161.120.155]) by mail6.sony.co.jp (R8/Sony) with ESMTP id hB18MI024044 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 17:22:18 +0900 (JST) Received: from springgh ([83.161.120.155]) by calserv-u1.cal.sony.co.jp (8.11.6/8.11.6) with SMTP id hB18DYI11644 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 17:13:34 +0900 Message-ID: <018701c3b7e4$472d6650$4d8b0b2b@springgh> From: "gong" <thorntonjeremy@example.com> To: "OJB Users List" <thorntonjeremy@example.com> References: <000e01c3b6cd$9109b7f0$0200a8c0@mozart> <thorntonjeremy@example.com> <002901c3b7df$d8bb00f0$0200a8c0@mozart> Subject: Re: does PersistenceBroker.getCollectionByQuery use the cache? Date: Mon, 1 Dec 2003 17:22:37 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N hi, all. from your email, i think you can help me. Thanks advance. I encountered a problem as follows: class myList and myEntry has a 1:n relationship each myList has a collection of myEntry(s) Class myList { ... List entries; ... } Class myEntry { String entryName; ... } I store them in two DB tables as CREATE TABLE list ( id varchar(20) not null, ... primary key(id) ); CREATE TABLE entry ( id varchar(20) not null, list_id varchar(20), name varchar(100), ... primary key(id), foreign key(list_id) references list(id) ); in reporsitory.xml: <!-- ==== List ==== --> <class-descriptor class="myList" table="list" > <field-descriptor name="id" column="id" jdbc-type="VARCHAR" primarykey="true" autoincrement="true" /> <collection-descriptor name="entries" collection-class="org.apache.ojb.broker.util.collections.ManageableArrayList " element-class-ref="myEntry" auto-retrieve="true" auto-update="true" auto-delete="true" > <inverse-foreignkey field-ref="listId"/> </collection-descriptor> </class-descriptor> <!-- ==== Entry ==== --> <class-descriptor class="myEntry" table="entry" > <field-descriptor name="id" column="id" jdbc-type="VARCHAR" primarykey="true" autoincrement="true" /> <field-descriptor name="listId" column="list_id" jdbc-type="VARCHAR" access="anonymous" /> <field-descriptor name="name" column="name" jdbc-type="VARCHAR" /> </class-descriptor> in this way, listPersisiter.store() and get() can automatically store and retrieve entry. but when i retrieve myList, and remove an entry from myList.entries, and store back, it can not automatically delete the entry in DB which have been removed from myList.entries. is ojb can not support this kind of operation? i think in ojb must have a way to automatically do these things. thanks! ----- Original Message ----- From: "Michael Mogley" <thorntonjeremy@example.com> To: "OJB Users List" <thorntonjeremy@example.com>; <thorntonjeremy@example.com> Sent: Monday, December 01, 2003 4:50 PM Subject: Re: does PersistenceBroker.getCollectionByQuery use the cache? > Thanks Thomas. Actually, right after I posted, the problem seems to have > gone away. In my webapp, I am actually being careful not to maintain copies > of the domain objects, as this would lead to precisely the issue you > describe. > > Michael > > ----- Original Message ----- > From: "Thomas Mahler" <thorntonjeremy@example.com> > To: "OJB Users List" <thorntonjeremy@example.com> > Sent: Sunday, November 30, 2003 11:42 PM > Subject: Re: does PersistenceBroker.getCollectionByQuery use the cache? > > > > Hi Michael, > > > > OJB puts all loaded entities (also those in collection attributes) into > > the cache. > > So if you can make sure that the updates are executed on exactly the > > same instances (and not a copy) of the photos stored in your collection > > everything should be fine. > > > > But this is exactly the problem! in webapplications you typically have a > > some kind of (copying) data transfer between the jsp pages and the > > domain model. If you are using copies somewhere, your changes to those > > copies will be stored by the broker, but they are reflected in the cache. > > > > Please call broker.clearCache() before loading the complete album in > > albumPhotos.jsp. If I am right it should now display all photos with the > > correct information. > > > > cheers, > > Thomas > > > > Michael Mogley wrote: > > > In my webapp, I've run across what may be a bug in Ojb. > > > > > > I have an Album class with a collection of Photos. > > > > > > I also have a jsp page, photoEdit.jsp, that retrieves a specific > > > Photo by identity, modifies it, then does PersistenceBroker.store. > > > > > > I have another page, albumPhotos.jsp, that lists all the photos in a > > > given album along with some of their attributes. > > > > > > When I make a change in photoEdit.jsp to a given Photo, then go to > > > albumPhotos.jsp to to list all the photos in the album, the Photo I > > > changed is listed with the old attributes. > > > > > > I am using ObjectDefaultCacheImpl and the app initializes and keeps a > > > reference to a single PersistenceBroker instance. > > > > > > It seems to me that when the Albums.photos collection attribute is > > > being initialized, the elements in the collection are not being > > > cached. > > > > > > Is this true? If so, it seems this would be bug. > > > > > > Or could I doing something half-assed? > > > > > > Thanks in advance. > > > > > > Michael > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: thorntonjeremy@example.com > > For additional commands, e-mail: thorntonjeremy@example.com > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: thorntonjeremy@example.com > For additional commands, e-mail: thorntonjeremy@example.com --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 09:26:37 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 70085 invoked from network); 1 Dec 2003 09:26:37 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 09:26:37 -0000 Received: (qmail 18646 invoked by uid 500); 1 Dec 2003 09:26:08 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 18629 invoked by uid 500); 1 Dec 2003 09:26:08 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 18616 invoked from network); 1 Dec 2003 09:26:07 -0000 Received: from unknown (HELO e450.ensicaen.ismra.fr) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 09:26:07 -0000 Received: from Jware005 (natn.ensicaen.ismra.fr [83.161.120.155]) by e450.ensicaen.ismra.fr (Postfix) with ESMTP id A08935E9F1 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 10:25:50 +0100 (MET) From: "Emmanuel Dupont" <thorntonjeremy@example.com> To: "OJB Users List" <thorntonjeremy@example.com> Subject: Field length control Date: Mon, 1 Dec 2003 10:29:58 +0100 Message-ID: <thorntonjeremy@example.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C3B7F6.12390370" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4510 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N ------=_NextPart_000_0001_01C3B7F6.12390370 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable All, =20 What is the best solution to control the field length of a JSP = application with OJB. =20 The repository. Xml doesn't contain any information about the database = field length. =20 Anyway if it would do it, I would have the same trouble. All the jdo attribute I use are String, etc.and in database I have Varchar(20), = Varchar (4) etc.. =20 =20 Any help, please... =20 =20 =20 =20 ------=_NextPart_000_0001_01C3B7F6.12390370-- From thorntonjeremy@example.com Mon Dec 01 09:45:20 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 80074 invoked from network); 1 Dec 2003 09:45:20 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 09:45:20 -0000 Received: (qmail 41433 invoked by uid 500); 1 Dec 2003 09:44:51 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 41413 invoked by uid 500); 1 Dec 2003 09:44:51 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 41400 invoked from network); 1 Dec 2003 09:44:50 -0000 Received: from unknown (HELO prosun.first.fraunhofer.de) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 09:44:50 -0000 Received: from pille.first.gmd.de (pille [83.161.120.155]) by prosun.first.fraunhofer.de (8.12.10/8.12.10) with SMTP id hB19j3Lh016032 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 10:45:03 +0100 (MET) Received: from localhost by pille.first.gmd.de (SMI-8.6/SMI-SVR4) id KAA12975; Mon, 1 Dec 2003 10:45:02 +0100 Date: Mon, 1 Dec 2003 10:45:02 +0100 (MET) From: Thomas Dudziak <thorntonjeremy@example.com> X-Sender: tomdz@pille To: OJB Users List <thorntonjeremy@example.com> Subject: Re: problem with ojbdoclet In-Reply-To: <thorntonjeremy@example.com> Message-ID: <Pine.GSO.4.21.0312011039090.12973-100000@pille> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I've found the cause of the problem. Basically, xdoclet tasks are similar to the javac compiler in that they expect the directory structure to match the package structure for their input files. So when you specified <fileset dir="${model-dir}"> <filename name="**/Dienst*.java"/> </fileset> the xdoclet ojb module expected the DienstStelle class to be in the default package as model-dir pointed to the directory de/phca/model which contains the java file. If you change model-dir to point to '.' then the module should work. As a rule of thumb, if the javac compiler works with the fileset, the an xdoclet task should also work with it. Tom --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 09:51:23 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 83269 invoked from network); 1 Dec 2003 09:51:23 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 09:51:23 -0000 Received: (qmail 48920 invoked by uid 500); 1 Dec 2003 09:50:55 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 48724 invoked by uid 500); 1 Dec 2003 09:50:53 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 48710 invoked from network); 1 Dec 2003 09:50:53 -0000 Received: from unknown (HELO prosun.first.fraunhofer.de) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 09:50:53 -0000 Received: from pille.first.gmd.de (pille [83.161.120.155]) by prosun.first.fraunhofer.de (8.12.10/8.12.10) with SMTP id hB19p5Lh016389 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 10:51:05 +0100 (MET) Received: from localhost by pille.first.gmd.de (SMI-8.6/SMI-SVR4) id KAA12979; Mon, 1 Dec 2003 10:51:05 +0100 Date: Mon, 1 Dec 2003 10:51:05 +0100 (MET) From: Thomas Dudziak <thorntonjeremy@example.com> X-Sender: tomdz@pille To: OJB Users List <thorntonjeremy@example.com> Subject: Re: Field length control In-Reply-To: <thorntonjeremy@example.com> Message-ID: <Pine.GSO.4.21.0312011045380.12973-100000@pille> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N On Mon, 1 Dec 2003, Emmanuel Dupont wrote: > All, > > What is the best solution to control the field length of a JSP application > with OJB. > > The repository. Xml doesn't contain any information about the database field > length. > > Anyway if it would do it, I would have the same trouble. All the jdo > attribute I use are String, etc.and in database I have Varchar(20), Varchar > (4) etc.. > > Any help, please... There is an attribute "length" for the field-descriptors which should help you (there are also "precision" and "scale" attributes for DECIMAL/NUMERIC fields). I have zero knowledge about JDO, but if you can use Torque to initialize your database then you can also use the "size" attribute of the column tags. Tom --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 09:56:13 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 85605 invoked from network); 1 Dec 2003 09:56:12 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 09:56:12 -0000 Received: (qmail 53685 invoked by uid 500); 1 Dec 2003 09:55:45 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 53440 invoked by uid 500); 1 Dec 2003 09:55:43 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 53425 invoked from network); 1 Dec 2003 09:55:43 -0000 Received: from unknown (HELO prosun.first.fraunhofer.de) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 09:55:43 -0000 Received: from pille.first.gmd.de (pille [83.161.120.155]) by prosun.first.fraunhofer.de (8.12.10/8.12.10) with SMTP id hB19ttLh016681 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 10:55:55 +0100 (MET) Received: from localhost by pille.first.gmd.de (SMI-8.6/SMI-SVR4) id KAA12983; Mon, 1 Dec 2003 10:55:55 +0100 Date: Mon, 1 Dec 2003 10:55:55 +0100 (MET) From: Thomas Dudziak <thorntonjeremy@example.com> X-Sender: tomdz@pille To: OJB Users List <thorntonjeremy@example.com> Subject: Re: problem with ojbdoclet In-Reply-To: <thorntonjeremy@example.com> Message-ID: <Pine.GSO.4.21.0312011053410.12981-100000@pille> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N > > I have uploaded the broken project to > > > > http://kasparov.skife.org/knf.tar.gz > > Brian, I'm not able to access the archive (404). Could you mail it to me if it's not too big ? Tom --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 10:21:49 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 98085 invoked from network); 1 Dec 2003 10:21:49 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 10:21:49 -0000 Received: (qmail 78887 invoked by uid 500); 1 Dec 2003 10:21:19 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 78872 invoked by uid 500); 1 Dec 2003 10:21:19 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 78858 invoked from network); 1 Dec 2003 10:21:18 -0000 Received: from unknown (HELO mp-backup.komtel.net) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 10:21:18 -0000 Received: from mx03.komtel.net (IDENT:thorntonjeremy@example.com [83.161.120.155]) by mp-backup.komtel.net (8.11.6/8.11.6) with ESMTP id hB1ALUH13256 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 11:21:30 +0100 Received: from ntserver01.lohndirekt.de ([83.161.120.155]) by mx03.komtel.net (Mirapoint Messaging Server MOS 3.3.7-GR) with ESMTP id APR47826 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 11:06:19 +0100 (CET) Received: by ntserver01.lohndirekt.de with Internet Mail Service (5.5.2653.19) id <WFWYLHWZ>; Mon, 1 Dec 2003 11:06:18 +0100 Message-ID: <thorntonjeremy@example.com> From: thorntonjeremy@example.com To: thorntonjeremy@example.com Subject: RE: postgresql clob/alternatives Date: Mon, 1 Dec 2003 11:06:08 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-15" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi, What's your problem with VARBINARY? We are mapping VARBINARY to byte[] and it works. We're using PostgreSQL 7.3.4. (But it worked with older versions, too) Sven -----Original Message----- From: Gunnar Hilling [mailto:thorntonjeremy@example.com] Sent: Monday, December 01, 2003 1:58 AM To: thorntonjeremy@example.com Subject: postgresql clob/alternatives ...or are there alternatives for storing long character data (working in postgreSQL again. Loading "VARBINARY" seems also not to work correctly). -Gunnar --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 10:24:19 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 99101 invoked from network); 1 Dec 2003 10:24:19 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 10:24:19 -0000 Received: (qmail 80740 invoked by uid 500); 1 Dec 2003 10:23:49 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 80718 invoked by uid 500); 1 Dec 2003 10:23:49 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 80702 invoked from network); 1 Dec 2003 10:23:49 -0000 Received: from unknown (HELO minotaur.apache.org) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 10:23:49 -0000 Received: (qmail 99081 invoked from network); 1 Dec 2003 10:24:14 -0000 Received: from mx1.bmi.gv.at (HELO smsw111101n2.bmi-net.local) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 10:24:14 -0000 Received: from swi001003.bmi.intra.gv.at (unverified) by smsw111101n2.bmi-net.local (Content Technologies SMTPRS 4.3.10) with ESMTP id <thorntonjeremy@example.com> for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 11:23:47 +0100 Received: by swi001003.bmiz.intra.gv.at with Internet Mail Service (5.5.2653.19) id <XZKFAD15>; Mon, 1 Dec 2003 11:23:46 +0100 Message-ID: <B011C212A71DD51183E700008317220B09807D9E@BMIMHS03> From: thorntonjeremy@example.com To: thorntonjeremy@example.com Subject: RE: Mapping question Date: Mon, 1 Dec 2003 11:23:44 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hello Eric, the descriptor as example: <class-descriptor=20 class=3D"at.gv.bmi.ClassA" table=3D"TableA" > <field-descriptor=20 name=3D"fieldA" column=3D"A" jdbc-type=3D"CHAR" primarykey=3D"true" /> <field-descriptor=20 name=3D"fieldB" column=3D"B" jdbc-type=3D"CHAR" /> <collection-descriptor name=3D"joinAB" element-class-ref=3D"at.gv.bmi.ClassB" > <inverse-foreignkey field-ref=3D"fieldY"/> </collection-descriptor> </class-descriptor> <class-descriptor=20 class=3D"at.gv.bmi.ClassB" table=3D"TableB" > <field-descriptor=20 name=3D"fieldX" column=3D"X" jdbc-type=3D"CHAR" primarykey=3D"true" /> <field-descriptor=20 name=3D"fieldY" column=3D"Y" jdbc-type=3D"CHAR" /> <field-descriptor=20 name=3D"fieldZ" column=3D"Z" jdbc-type=3D"CHAR" /> </class-descriptor> The join has to be made from ClassA:B to ClassB:Y, ie the where = condition has to be=20 where A0.B =3D A1.Y instead of A0.A =3D A1.Y What do I have to do to get this join? Thanks, Norbert. -----Original Message----- From: eric barbe [mailto:thorntonjeremy@example.com] Sent: Freitag, 28. November 2003 15:08 To: OJB Users List Subject: RE: Mapping question Hi, I don't really understand you're pb. ;o( Is it : any field from my class A can be THE foreign key (mykey in this case) from my class B ? Regards =C9ric -----Message d'origine----- De : thorntonjeremy@example.com [mailto:thorntonjeremy@example.com] Envoy=E9 : jeudi 27 novembre 2003 17:49 =C0 : thorntonjeremy@example.com Objet : RE: Mapping question Thanks, I defined it like that, but: >If A is 1 and B is n. >In A class descriptor write : ><collection-descriptor name=3D"relation_name_in_A_class" >element-class-ref=3D"url.B"> > <inverse-foreignkey field-ref=3D"mykey"/> ></collection-descriptor> >And in B class descriptor write this ><field-descriptor name=3D"mykey" column=3D"mycolumn" = jdbc-type=3D"INTEGER"/> >Here mykey is the foreignkey but not a primary key ! OJB generates statements where mykey points to the pk of class A. The generated join looks like: A.pk =3D B.mykey We need: A.anyField =3D B.mykey In fact I think we've a m:n mapping without intermediary table... What can we do (the database model cannot be changed)? Is there a possibility to add to the collection-descriptor something = like <foreignkey field-ref=3D"anyField"/> similar to the = <inverse-foreignkey/> element? Thanks again. -----Message d'origine----- De : thorntonjeremy@example.com [mailto:thorntonjeremy@example.com] Envoy=E9 : jeudi 27 novembre 2003 16:57 =C0 : thorntonjeremy@example.com Objet : Mapping question Hi, I've got a 1:n mapping from table A to table B. But the foreign key = field of table A is not it's primary key. I can't find how to tell OJB to use = another field to join table B. Thanks for help, Norbert. --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 12:45:24 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 67064 invoked from network); 1 Dec 2003 12:45:23 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 12:45:23 -0000 Received: (qmail 34331 invoked by uid 500); 1 Dec 2003 12:45:19 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 34063 invoked by uid 500); 1 Dec 2003 12:45:18 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 34006 invoked from network); 1 Dec 2003 12:45:17 -0000 Received: from unknown (HELO linkwell.com.br) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 12:45:17 -0000 Received: (qmail 15072 invoked from network); 1 Dec 2003 12:45:16 -0000 Received: from ba199063164.user.veloxzone.com.br (HELO glauber) (83.161.120.155) by 0 with SMTP; 1 Dec 2003 12:45:16 -0000 Message-ID: <004801c3b808$f86a6fc0$a43fc7c8@glauber> From: "Glauber Andrade" <thorntonjeremy@example.com> To: <thorntonjeremy@example.com> References: <010b01c37bbd$74356e80$6479fea9@win> <01a301c37bbe$65e00a10$f81da4c8@glauber> <002d01c37bd3$6acbc180$91a09384@Marc> <021901c37bf1$c2ead310$f81da4c8@glauber> <00eb01c37bf8$43a3f3f0$91a09384@Marc> <014e01c388f0$6aaac190$901fa4c8@glauber> <thorntonjeremy@example.com> <016901c388f2$26ce66f0$901fa4c8@glauber> <thorntonjeremy@example.com> <019701c388f5$afdce400$901fa4c8@glauber> <thorntonjeremy@example.com> Subject: too slow! Date: Mon, 1 Dec 2003 09:45:13 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I am using OJB and Mysql (4.0.16) (with mysql-connector-java-3.0.9-stable) in an swing application and the system is too slow. A simple query whith 2000 registers takes more than 15s to go. How can I speed it up ? Thanks, Criteria crit = new Criteria(); crit.addEqualTo("id_empresa", "" + empresa.getId()); crit.addOrderBy("pagamento", true); crit.addOrderBy("prestador.nome", true); Query q = QueryFactory.newQuery(NotaRecibo.class, crit); Collection c = broker.getCollectionByQuery(q); --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 12:47:22 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 67974 invoked from network); 1 Dec 2003 12:47:22 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 12:47:22 -0000 Received: (qmail 36335 invoked by uid 500); 1 Dec 2003 12:47:17 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 36108 invoked by uid 500); 1 Dec 2003 12:47:16 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 36073 invoked from network); 1 Dec 2003 12:47:15 -0000 Received: from unknown (HELO atlantida.fys.com.ar) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 12:47:15 -0000 Received: from obiwan.fys.com.ar ([83.161.120.155]) by atlantida.fys.com.ar (8.11.6/8.11.6) with ESMTP id hB16UDf04734 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 09:30:13 +0300 In-Reply-To: <thorntonjeremy@example.com> To: "OJB Users List" <thorntonjeremy@example.com> Subject: Re: Object replication vs RDBMS replication (little off topic) MIME-Version: 1.0 X-Mailer: Lotus Notes Build V65_M1_04032003NP April 03, 2003 Message-ID: <thorntonjeremy@example.com> From: thorntonjeremy@example.com Date: Mon, 1 Dec 2003 09:47:12 -0300 X-MIMETrack: Serialize by Router on Boromir/FSC(Release 6.5|September 26, 2003) at 01/12/2003 09:47:13 a.m., Serialize complete at 01/12/2003 09:47:13 a.m. Content-Type: multipart/alternative; boundary="=_alternative 00463D9303256DEF_=" X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: Found to be clean X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N --=_alternative 00463D9303256DEF_= Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Robert, Your are right. Unique key generation (or I might say object's unique id=20 generation) is a crtical issue here. We are looking into a couple of=20 algorithms here to address this. It means we would need to delegate OJB?s=20 sequencer a "key" function. This unique object id might work across=20 replicas letting the replicator to identify objects replicas across=20 different object repositories. Regards, Gustavo. Robert Coup <thorntonjeremy@example.com>=20 30/11/2003 08:37 p.m. Please respond to "OJB Users List" <thorntonjeremy@example.com> To OJB Users List <thorntonjeremy@example.com> cc Subject Re: Object replication vs RDBMS replication (little off topic) Me too. we have an application underway which will require some offline operation. = While it won't have masses of conflicting stuff, unique key generation would be=20 nice. However, I expect the offline abilities to be expanded in future, which=20 would make things more messy :) Thanks, Rob :) Quoting Jason Pyeron <thorntonjeremy@example.com>: > ditto. >=20 > we have two (2) applications under way right now, which we want to do=20 > something similar. >=20 > 1) n locations connected by a 90% up slow link, these locations need=20 > access to each others information, and not to conflict. >=20 > 2) a port of bugzilla, which will allow offline entry/submission >=20 > -Jason Pyeron >=20 > On Sun, 30 Nov 2003, Colin Kilburn wrote: >=20 > > Gustavo, > >=20 > > I expect to have a project soon that will require some replication, > although perhaps with differing requirements, but I'm sure there'll be=20 some > overlap in requirements as well as challenges. At minimum I'd be=20 interested > in discussing issues and approaches in this arena "soon" (I'm currently=20 very > tied up trying to finish another project.) > >=20 > > What results from these efforts (or at least parts of them) may be=20 generic > enough to be useful to others. Anyone else? > >=20 > > Colin Kilburn > >=20 > > thorntonjeremy@example.com wrote: > >=20 > > >Hi all, > > > > > >We=E2??ve being using OJB for a while and we do like it.=20 > > >While we depart from the old paradigm (delegating the "important"=20 stuff to >=20 > > >the RDBMS) and we delegate OJB the real work, some=20 > > >opportunities/challenges come to our mind. > > >And since data/object replication is one of those opportunities, we=20 would >=20 > > >like to address in a new project. We believe OJB is ready for a job=20 like=20 > > >this. > > > > > >Let=E2??s say we have some data collection apps running in notebooks > offsite.=20 > > >Thanks to OJB, the app runs on almost any RDBMS in every notebook=20 (hsql,=20 > > >mysql, postgresql or any $$ vendor base rdbms) an in a main site=20 storing=20 > > >the objects again in an opensource or $$vendor base dbms. > > > > > >Once the data collectors have a network connection available (either=20 WAN=20 > > >or LAN) we would like them to "replicate" their objects with the main = site >=20 > > >or with other partners. Scheduled or ad-hoc replication, it just=20 doesn=C2=B4t >=20 > > >matter. OJB would do it no matter when or where. > > > > > >The apps have some business objects that will remain with little or=20 no=20 > > >changes through their life cycle (like the old master tables) ; some=20 > > >others will face heavy updates (customers service requests). > > > > > >If any of you are familiar with it, Lotus Notes/Domino type of=20 replication >=20 > > >is the best model of the replication mechanism we would like to=20 implement >=20 > > >in this project (but remember, at an object or better business object = > > >level replication, not record/document level replication). > > > > > >Let=C2=B4s dream for a minute: OJB will let us replicate objects acros= s=20 > > >different dbms, without even having the same schema (due to the=20 > > >repository.xml mapping magic!!!!) > > > > > >Among some other things, we will need to take care of things like=20 unique=20 > > >ids across db replicas ( sequencers ), differential replication,=20 > > >replication conficts etc.=20 > > > > > >Any frameworks or ideas out there? Any volunteers to start an "OJB=20 > > >replicator" contribution to this great framework? > > > > > >Finally and again: Thanks Thomas and the whole OJB team!. > > > > > >Best regards, > > > > > >Gustavo Faerman > > >Buenos Aires, Argentina > > >=20 > > > > >=20 > >=20 > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: thorntonjeremy@example.com > > For additional commands, e-mail: thorntonjeremy@example.com > >=20 >=20 > --=20 > -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- > - - > - Jason Pyeron http://www.pyerotechnics.com - > - Partner & Sr. Manager Pyerotechnics Development, Inc. - > - +1 (443) 451-2697 500 West University Parkway #1S - > - 600.956.9433 (c) Baltimore, Maryland 21210-3253 - > - - > -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- >=20 > This message is for the designated recipient only and may contain=20 > privileged, proprietary, or otherwise private information. If you=20 > have received it in error, purge the message from your system and=20 > notify the sender immediately. Any other use of the email by you=20 > is prohibited. >=20 >=20 >=20 >=20 > --------------------------------------------------------------------- > To unsubscribe, e-mail: thorntonjeremy@example.com > For additional commands, e-mail: thorntonjeremy@example.com >=20 >=20 --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com --=_alternative 00463D9303256DEF_=-- From thorntonjeremy@example.com Mon Dec 01 12:52:54 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 70280 invoked from network); 1 Dec 2003 12:52:54 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 12:52:54 -0000 Received: (qmail 40575 invoked by uid 500); 1 Dec 2003 12:52:48 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 40553 invoked by uid 500); 1 Dec 2003 12:52:48 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 40538 invoked from network); 1 Dec 2003 12:52:46 -0000 Received: from unknown (HELO atlantida.fys.com.ar) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 12:52:46 -0000 Received: from obiwan.fys.com.ar ([83.161.120.155]) by atlantida.fys.com.ar (8.11.6/8.11.6) with ESMTP id hB16Nof04648 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 09:23:51 +0300 In-Reply-To: <thorntonjeremy@example.com> To: "OJB Users List" <thorntonjeremy@example.com> Subject: Re: Object replication vs RDBMS replication (little off topic) MIME-Version: 1.0 X-Mailer: Lotus Notes Build V65_M1_04032003NP April 03, 2003 Message-ID: <thorntonjeremy@example.com> From: thorntonjeremy@example.com Date: Mon, 1 Dec 2003 09:40:50 -0300 X-MIMETrack: Serialize by Router on Boromir/FSC(Release 6.5|September 26, 2003) at 01/12/2003 09:40:51 a.m., Serialize complete at 01/12/2003 09:40:51 a.m. Content-Type: multipart/alternative; boundary="=_alternative 0045A83B03256DEF_=" X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: Found to be clean X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N --=_alternative 0045A83B03256DEF_= Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Hi Mircea, >when you design a system for backup/recovery you want to be sure that >if the testing is ok for 2 or 3 systems then everything will work fine >with all of them. Good point. It=B4s add another perspective. In a server <--> server=20 replication (hub to hub), at this point I would even think about using=20 different dbms.From ours, we did not mean we would like Object replication = with backup/recovery features "no matter" your rdbms. As you say, we do=20 not want to add heterogenity to the application with major unwanted=20 consequences. We just think, based in some own replication experience, in a client <-->=20 server replication (hub & spoke architecture), the client (the=20 offsite/offline app client) tipically just need to read master tables (RO=20 access) and just need to add/update records impacting in a DB subset. For=20 this situation,we envisioning the clients using small footprint db=B4s (lik= e=20 HSQL).=20 But no matter the different requirements we might identify in the 2=20 scenarios (client <--> server or server <--> server replication), objects=20 replication is still grabbing our attention. Thanks for the input and best regards, Gustavo. thorntonjeremy@example.com=20 29/11/2003 05:59 a.m. Please respond to "OJB Users List" <thorntonjeremy@example.com> To "OJB Users List" <thorntonjeremy@example.com> cc Subject Re: Object replication vs RDBMS replication (little off topic) Hi Gustavo, > Let&#194;&#180;s dream for a minute: OJB will let us replicate objects=20 across > different dbms, without even having the same schema (due to the > repository.xml mapping magic!!!!) IMHO, this will be a dream for some time. Our purpose is, in the end, to have the same set on objects on different machines. The assumption of different providers for databases is not a realistic one because when you design a system for backup/recovery you want to be sure that if the testing is ok for 2 or 3 systems then everything will work fine with all of them. Adding such heterogenity to your application can have major unwanted consequences. Of course, we can implement a 'SmartPersistenceBroker' that send data to its subscribers and execute localy some broker.op(), but keeping those subscribers syncronized is not easy. You may take a look over the replication packages available for PostgreSQL or BerkeleyDB. >Finally and again: Thanks Thomas and the whole OJB team!. Thanks Thomas for this framework, I look forward to see it at version 1.1=20 :) Best regards, -- Mircea Lazar --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com --=_alternative 0045A83B03256DEF_=-- From thorntonjeremy@example.com Mon Dec 01 12:57:54 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 72194 invoked from network); 1 Dec 2003 12:57:54 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 12:57:54 -0000 Received: (qmail 45659 invoked by uid 500); 1 Dec 2003 12:57:49 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 45641 invoked by uid 500); 1 Dec 2003 12:57:48 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 45628 invoked from network); 1 Dec 2003 12:57:48 -0000 Received: from unknown (HELO mail.ppi.de) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 12:57:48 -0000 Received: from max.ppinet.de (max.ppinet.de [83.161.120.155]) by mail.ppi.de (8.12.2/8.12.2) with ESMTP id hB1Cvle5024084 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 13:57:47 +0100 Received: by max.ppinet.de with Internet Mail Service (5.5.2653.19) id <X7273J9R>; Mon, 1 Dec 2003 13:57:48 +0100 Message-ID: <thorntonjeremy@example.com> From: thorntonjeremy@example.com To: thorntonjeremy@example.com Subject: RE: too slow! Date: Mon, 1 Dec 2003 13:57:47 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="ISO-8859-1" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hello Andrade, > -----Original Message----- > From: Glauber Andrade [mailto:thorntonjeremy@example.com] > I am using OJB and Mysql (4.0.16) (with > mysql-connector-java-3.0.9-stable) > in an swing application and the system is too slow. A simple > query whith > 2000 registers takes more than 15s to go. > How can I speed it up ? You have to give us some more information, for example your repository_user.xml. Besides, you may have a look at the documentation (proxies etc.) > Criteria crit = new Criteria(); > crit.addEqualTo("id_empresa", "" + empresa.getId()); > crit.addOrderBy("pagamento", true); > crit.addOrderBy("prestador.nome", true); > Query q = QueryFactory.newQuery(NotaRecibo.class, crit); > Collection c = broker.getCollectionByQuery(q); Olli --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 13:09:05 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 77332 invoked from network); 1 Dec 2003 13:09:05 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 13:09:05 -0000 Received: (qmail 55395 invoked by uid 500); 1 Dec 2003 13:08:59 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 55376 invoked by uid 500); 1 Dec 2003 13:08:59 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 55357 invoked from network); 1 Dec 2003 13:08:58 -0000 Received: from unknown (HELO mail.ppi.de) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 13:08:58 -0000 Received: from max.ppinet.de (max.ppinet.de [83.161.120.155]) by mail.ppi.de (8.12.2/8.12.2) with ESMTP id hB1D8ve5025175 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 14:08:57 +0100 Received: by max.ppinet.de with Internet Mail Service (5.5.2653.19) id <X7273J0V>; Mon, 1 Dec 2003 14:08:58 +0100 Message-ID: <thorntonjeremy@example.com> From: thorntonjeremy@example.com To: thorntonjeremy@example.com Subject: RemovalAwareCollection, was: RE: does PersistenceBroker.getCollec tionByQuery use the cache? Date: Mon, 1 Dec 2003 14:08:58 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="ISO-8859-1" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hello Gong, please start a new thread when you ask a new question. > -----Original Message----- > class myList and myEntry has a 1:n relationship > each myList has a collection of myEntry(s) [..] > <collection-descriptor > name="entries" > > collection-class= > "org.apache.ojb.broker.util.collections.ManageableArrayList" > element-class-ref="myEntry" > auto-retrieve="true" > auto-update="true" > auto-delete="true" > > > <inverse-foreignkey field-ref="listId"/> > </collection-descriptor> > > </class-descriptor> [..] > in this way, listPersisiter.store() and get() can automatically > store and retrieve entry. > > but when i retrieve myList, and remove an entry from > myList.entries, and store back, it can not automatically > delete the entry in DB which have been removed from > myList.entries. If you want this behaviour, you must not use the ManageableArrayList (as you explicitly do, see above) but have to use the RemovalAwareCollection (which is actually the default.) Just remove the attribute collection-class from the class-descriptor and try again. BTW: this is a FAQ. Olli --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 14:04:59 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 8946 invoked from network); 1 Dec 2003 14:04:59 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 14:04:59 -0000 Received: (qmail 36514 invoked by uid 500); 1 Dec 2003 14:04:52 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 36495 invoked by uid 500); 1 Dec 2003 14:04:51 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 36482 invoked from network); 1 Dec 2003 14:04:51 -0000 Received: from unknown (HELO mail.fridayfives.net) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 14:04:51 -0000 Received: from kamajii.forthill.int (localhost [83.161.120.155]) by localhost (Postfix) with SMTP id AAE861F442 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 09:04:52 -0500 (EST) Received: from forthillcompany.com (kite.forthill.int [83.161.120.155]) by mail.fridayfives.net (Postfix) with ESMTP id 73DA61F439 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 09:04:52 -0500 (EST) Date: Mon, 1 Dec 2003 09:04:51 -0500 Subject: Re: problem with ojbdoclet Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v553) From: Brian McCallister <thorntonjeremy@example.com> To: "OJB Users List" <thorntonjeremy@example.com> Content-Transfer-Encoding: 7bit In-Reply-To: <Pine.GSO.4.21.0312011053410.12981-100000@pille> Message-Id: <thorntonjeremy@example.com> X-Mailer: Apple Mail (2.553) X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I took it down when I got it working. -Brian On Monday, December 1, 2003, at 04:55 AM, Thomas Dudziak wrote: > >>> I have uploaded the broken project to >>> >>> http://kasparov.skife.org/knf.tar.gz >>> > > Brian, I'm not able to access the archive (404). Could you mail it to > me > if it's not too big ? > > Tom > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: thorntonjeremy@example.com > For additional commands, e-mail: thorntonjeremy@example.com > > --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 14:30:00 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 28688 invoked from network); 1 Dec 2003 14:30:00 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 14:30:00 -0000 Received: (qmail 61399 invoked by uid 500); 1 Dec 2003 14:29:52 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 61331 invoked by uid 500); 1 Dec 2003 14:29:52 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 61292 invoked from network); 1 Dec 2003 14:29:51 -0000 Received: from unknown (HELO mail.ppi.de) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 14:29:51 -0000 Received: from max.ppinet.de (max.ppinet.de [83.161.120.155]) by mail.ppi.de (8.12.2/8.12.2) with ESMTP id hB1ETpe5031982 for <thorntonjeremy@example.com>; Mon, 1 Dec 2003 15:29:51 +0100 Received: by max.ppinet.de with Internet Mail Service (5.5.2653.19) id <X7273KHF>; Mon, 1 Dec 2003 15:29:52 +0100 Message-ID: <thorntonjeremy@example.com> From: thorntonjeremy@example.com To: thorntonjeremy@example.com Subject: RE: RemovalAwareCollection, was: RE: does PersistenceBroker.getCo llec tionByQuery use the cache? Date: Mon, 1 Dec 2003 15:29:52 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="ISO-8859-1" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hello, > -----Original Message----- > From: thorntonjeremy@example.com [mailto:thorntonjeremy@example.com] > Just remove the attribute collection-class from the > class-descriptor and try again. ^^^^^ oops, I meant the collection-descriptor. Olli --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 15:04:54 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 54631 invoked from network); 1 Dec 2003 15:04:54 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 15:04:54 -0000 Received: (qmail 4054 invoked by uid 500); 1 Dec 2003 15:04:46 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 4038 invoked by uid 500); 1 Dec 2003 15:04:45 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 4024 invoked from network); 1 Dec 2003 15:04:45 -0000 Received: from unknown (HELO dozer.whisperwire.com) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 15:04:45 -0000 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: RE: too slow! Date: Mon, 1 Dec 2003 09:04:44 -0600 Message-ID: <thorntonjeremy@example.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: too slow! Thread-Index: AcO4CPzn5tASz1PBQleyxJzNJLJCjAAEtAow From: "Lance Eason" <thorntonjeremy@example.com> To: "OJB Users List" <thorntonjeremy@example.com> X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N You didn't really give enough information to help. Before you're going = to be able to optimize you're going to need to figure out where the time = is being spent. Is it the main query taking a long time executing = against the db? Are relationships forcing lots of extra queries? Is it = in the OJB or the instantiation of your objects? Things I would check off the top of my head: - do you have an index on the id_empresa field? - does the NotaRecibo have a lot of relationships to other objects in = the repository? If so have you tried proxying these relationships so = they're not loaded with the initial query? -----Original Message----- From: Glauber Andrade [mailto:thorntonjeremy@example.com] Sent: Monday, December 01, 2003 6:45 AM To: thorntonjeremy@example.com Subject: too slow! I am using OJB and Mysql (4.0.16) (with = mysql-connector-java-3.0.9-stable) in an swing application and the system is too slow. A simple query whith 2000 registers takes more than 15s to go. How can I speed it up ? Thanks, Criteria crit =3D new Criteria(); crit.addEqualTo("id_empresa", "" + empresa.getId()); crit.addOrderBy("pagamento", true); crit.addOrderBy("prestador.nome", true); Query q =3D QueryFactory.newQuery(NotaRecibo.class, crit); Collection c =3D broker.getCollectionByQuery(q); --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 15:22:14 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 65779 invoked from network); 1 Dec 2003 15:22:14 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 15:22:14 -0000 Received: (qmail 23630 invoked by uid 500); 1 Dec 2003 15:22:05 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 23608 invoked by uid 500); 1 Dec 2003 15:22:05 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 23574 invoked from network); 1 Dec 2003 15:22:05 -0000 Received: from unknown (HELO web21002.mail.yahoo.com) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 15:22:05 -0000 Message-ID: <thorntonjeremy@example.com> Received: from [83.161.120.155] by web21002.mail.yahoo.com via HTTP; Mon, 01 Dec 2003 07:22:07 PST Date: Mon, 1 Dec 2003 07:22:07 -0800 (PST) From: Gary <thorntonjeremy@example.com> Subject: Transaction Confusion To: thorntonjeremy@example.com MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N We are going to use WebSphere as our transaction manager. I am confused over what APIs I can use in this configuration, and how the transaction begin/commit/rollback boundries would look. Can someone please give a thumbnail sketch of my options, and (in a perfect world) examples? Thanks, Gary __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 16:57:30 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 16889 invoked from network); 1 Dec 2003 16:57:30 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 16:57:30 -0000 Received: (qmail 14004 invoked by uid 500); 1 Dec 2003 16:57:22 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 13675 invoked by uid 500); 1 Dec 2003 16:57:19 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 13610 invoked from network); 1 Dec 2003 16:57:14 -0000 Received: from unknown (HELO mail-out.ukr.net) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 16:57:14 -0000 Received: from hammer.ukr.net ([83.161.120.155]) by mail-out.ukr.net with esmtp ID 1AQrMJ-00004f-00; Mon, 01 Dec 2003 18:57:15 +0200 Received: from mail by hammer.ukr.net with local ID 1AQrMJ-000OBZ-00 for thorntonjeremy@example.com; Mon, 01 Dec 2003 18:57:15 +0200 Received: from [83.161.120.155] by www2.ukr.net with HTTP; Mon, 01 Dec 2003 16:57:15 +0000 (GMT) From: "Oleg Nitz" <thorntonjeremy@example.com> To: "OJB Users List" <thorntonjeremy@example.com> Subject: Re: too slow! Mime-Version: 1.0 X-Mailer: mPOP Web-Mail 2.19 X-Originating-IP: ns.ibis.ua [83.161.120.155] In-Reply-To: <004801c3b808$f86a6fc0$a43fc7c8@glauber> Reply-To: "Oleg Nitz" <thorntonjeremy@example.com> Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 8bit Message-Id: <thorntonjeremy@example.com> Date: Mon, 01 Dec 2003 18:57:15 +0200 X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/) *1AQrMJ-000OBZ-00*sU2FyqxvvMI* X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N -----Original Message----- From: "Glauber Andrade" <thorntonjeremy@example.com> To: <thorntonjeremy@example.com> Date: Mon, 1 Dec 2003 09:45:13 -0300 Subject: too slow! > I am using OJB and Mysql (4.0.16) (with mysql-connector-java-3.0.9-stable) > in an swing application and the system is too slow. A simple query whith > 2000 registers takes more than 15s to go. > How can I speed it up ? First of all, does plain JDBC query load the same data much faster? If yes, you could use proxies to avoid immediate loading of related objects. If no and queries of this kind will run often, you can build database index for the "id_empresa" column, maybe also for "pagamento". Regards, Oleg > Criteria crit = new Criteria(); > crit.addEqualTo("id_empresa", "" + empresa.getId()); > crit.addOrderBy("pagamento", true); > crit.addOrderBy("prestador.nome", true); > Query q = QueryFactory.newQuery(NotaRecibo.class, crit); > Collection c = broker.getCollectionByQuery(q); --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 17:13:21 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 27176 invoked from network); 1 Dec 2003 17:13:20 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 17:13:20 -0000 Received: (qmail 52921 invoked by uid 500); 1 Dec 2003 17:13:09 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 52902 invoked by uid 500); 1 Dec 2003 17:13:09 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 52888 invoked from network); 1 Dec 2003 17:13:09 -0000 Received: from unknown (HELO linkwell.com.br) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 17:13:09 -0000 Received: (qmail 32387 invoked from network); 1 Dec 2003 17:13:13 -0000 Received: from ba199063164.user.veloxzone.com.br (HELO glauber) (83.161.120.155) by 0 with SMTP; 1 Dec 2003 17:13:13 -0000 Message-ID: <000e01c3b82e$66579c90$a43fc7c8@glauber> From: "Glauber Andrade" <thorntonjeremy@example.com> To: "OJB Users List" <thorntonjeremy@example.com> References: <thorntonjeremy@example.com> Subject: Re: too slow! Date: Mon, 1 Dec 2003 14:13:10 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Where should I use proxy?? Thanks <!-- Definitions for com..data.NotaRecibo --> <class-descriptor class="com..data.NotaRecibo" table="notasrecibos" > <field-descriptor name="id" column="id" jdbc-type="BIGINT" primarykey="true" autoincrement="true" /> <field-descriptor name="id_prestador" column="prestador" jdbc-type="BIGINT" /> <reference-descriptor name="prestador" class-ref="com..data.Prestador" > <foreignkey field-ref="id_prestador"/> </reference-descriptor> <field-descriptor name="id_servico" column="servico" jdbc-type="BIGINT" /> <reference-descriptor name="servico" class-ref="com..data.ServicoJuridico" > <foreignkey field-ref="id_servico"/> </reference-descriptor> <field-descriptor name="data" column="DATA" jdbc-type="DATE" conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi eldConversion" /> <field-descriptor name="pagamento" column="PAGAMENTO" jdbc-type="DATE" conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi eldConversion" /> <field-descriptor name="credito" column="CREDITO" jdbc-type="DATE" conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi eldConversion" /> <field-descriptor name="valor" column="VALOR" jdbc-type="DOUBLE" /> <field-descriptor name="retidoIRRF" column="RETIDOIRRF" jdbc-type="DOUBLE" /> <field-descriptor name="retidoINSS" column="RETIDOINSS" jdbc-type="DOUBLE" /> <field-descriptor name="retidoISS" column="RETIDOISS" jdbc-type="DOUBLE" /> <field-descriptor name="outros" column="OUTROS" jdbc-type="DOUBLE" /> <field-descriptor name="numeroNF" column="NUMERONF" jdbc-type="BIGINT" /> <field-descriptor name="recibo" column="RECIBO" jdbc-type="BIGINT" /> <field-descriptor name="id_darf" column="DARF" jdbc-type="INTEGER" /> <reference-descriptor name="darf" class-ref="com..data.Darf" > <foreignkey field-ref="id_darf"/> </reference-descriptor> <field-descriptor name="gps" column="GPS" jdbc-type="INTEGER" /> <field-descriptor name="iss" column="ISS" jdbc-type="INTEGER" /> <field-descriptor name="id_empresa" column="id_empresa" jdbc-type="INTEGER" /> <reference-descriptor name="empresa" class-ref="com..data.Empresa" > <foreignkey field-ref="id_empresa"/> </reference-descriptor> <field-descriptor name="exportado" column="EXPORTADO" jdbc-type="INTEGER" /> <collection-descriptor name="excessoes" element-class-ref="com..data.NotaRecibo_Excessao" auto-retrieve="true" auto-update="true" auto-delete="true" refresh="true" > <inverse-foreignkey field-ref="id_notaRecibo"/> </collection-descriptor> </class-descriptor> ----- Original Message ----- From: <thorntonjeremy@example.com> To: <thorntonjeremy@example.com> Sent: Monday, December 01, 2003 9:57 AM Subject: RE: too slow! > Hello Andrade, > > > -----Original Message----- > > From: Glauber Andrade [mailto:thorntonjeremy@example.com] > > > I am using OJB and Mysql (4.0.16) (with > > mysql-connector-java-3.0.9-stable) > > in an swing application and the system is too slow. A simple > > query whith > > 2000 registers takes more than 15s to go. > > How can I speed it up ? > > You have to give us some more information, for example > your repository_user.xml. > > Besides, you may have a look at the documentation > (proxies etc.) > > > Criteria crit = new Criteria(); > > crit.addEqualTo("id_empresa", "" + empresa.getId()); > > crit.addOrderBy("pagamento", true); > > crit.addOrderBy("prestador.nome", true); > > Query q = QueryFactory.newQuery(NotaRecibo.class, crit); > > Collection c = broker.getCollectionByQuery(q); > > Olli > > --------------------------------------------------------------------- > To unsubscribe, e-mail: thorntonjeremy@example.com > For additional commands, e-mail: thorntonjeremy@example.com > --------------------------------------------------------------------- To unsubscribe, e-mail: thorntonjeremy@example.com For additional commands, e-mail: thorntonjeremy@example.com From thorntonjeremy@example.com Mon Dec 01 18:05:51 2003 Return-Path: <thorntonjeremy@example.com> Delivered-To: thorntonjeremy@example.com Received: (qmail 58855 invoked from network); 1 Dec 2003 18:05:51 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur-2.apache.org with SMTP; 1 Dec 2003 18:05:51 -0000 Received: (qmail 41292 invoked by uid 500); 1 Dec 2003 18:05:40 -0000 Delivered-To: thorntonjeremy@example.com Received: (qmail 41128 invoked by uid 500); 1 Dec 2003 18:05:39 -0000 Mailing-List: contact thorntonjeremy@example.com; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:thorntonjeremy@example.com> List-Subscribe: <mailto:thorntonjeremy@example.com> List-Help: <mailto:thorntonjeremy@example.com> List-Post: <mailto:thorntonjeremy@example.com> List-Id: "OJB Users List" <ojb-user.db.apache.org> Reply-To: "OJB Users List" <thorntonjeremy@example.com> Delivered-To: mailing list thorntonjeremy@example.com Received: (qmail 41000 invoked from network); 1 Dec 2003 18:05:38 -0000 Received: from unknown (HELO mail.gmx.net) (83.161.120.155) by daedalus.apache.org with SMTP; 1 Dec 2003 18:05:38 -0000 Received: (qmail 8410 invoked by uid 65534); 1 Dec 2003 18:05:38 -0000 Received: from unknown (EHLO gmx.ch) (83.161.120.155) by mail.gmx.net (mp027) with SMTP; 01 Dec 2003 19:05:38 +0100 X-Authenticated: #15507884 Message-ID: <thorntonjeremy@example.com> Date: Mon, 01 Dec 2003 19:05:32 +0100 From: Jakob Braeuchi <thorntonjeremy@example.com> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en MIME-Version: 1.0 To: OJB Users List <thorntonjeremy@example.com> Subject: Re: Deletion Bug!!!!!? References: <thorntonjeremy@example.com> <007201c3b5e2$35cb0600$6600a8c0@notebookts> In-Reply-To: <007201c3b5e2$35cb0600$6600a8c0@notebookts> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N hi tino, i agree this behaviour is dangerous and it should _not_ be the default behaviour. i would also like the collection to be insertion-aware. but i think these features are already implemented in odmg-api; so we kinda duplicate functionality here. jakob TINO SCHÖLLHORN wrote: > Hi Olli, > > and what about changing the default behaviour again? Honestly I think it is > pretty "dangerous" because when I want to remove a relation I just want to >
{'source': 'Apache Software Foundation Public Mail Archives'}