Re: Optimizing object materialization for 1:N relations

Hi Armin, thanks for your reply. Do you think it would be worth a try to materialize our objects with pure SQL - but after initializing them to work with them with OJB? Thanks for your opinion. Regards Tino Armin Waibel schrieb: Hi Tino, Tino Schöllhorn wrote: Hi, we are using OJB

Re: Optimizing object materialization for 1:N relations

only 2 Queries, but you will bulk load several ACLs Bye danilo Tino Schöllhorn wrote: Hi Armin, thanks for your reply. Do you think it would be worth a try to materialize our objects with pure SQL - but after initializing them to work with them with OJB? Thanks for your opinion. Regards Tino

Optimizing object materialization for 1:N relations

Hi, we are using OJB-1.0.1 and evertything works fine. Now I have the following situation: We have a security-mechanism which uses the classes ACL (AccessControlList) and ACLEntry. One ACL has many ACLEntries. Now when using the standard OJB-Materialization methods OJB uses 2 SQLs to

Re: Nested Objects Cocoon Form Binding

Hi, this is not really an issue concerning OJB. You should try to use JavaBeans accessors/mutators to achieve your goal. Look at the spring-framework for example - they have a mapping from forms to javabeans. Tino 許議中 wrote: Hi! Below is running in OJB 1.0.4 Cocoon 2.1.0 I've a set of

Own Proxy-Implementation

Hi, I want to change the used Proxy-Implementation of some of my collections. So I have written a MyProxyListImpl class which implements the CollectionProxy interface: class MyProxyListImpl extends ArrayList implements CollectionProxy { // the 2 constructors. } Then I changed the

Re: Performance PB

Hi, I think you can exactly do that. Just use a thread variable (see ThreadLocal) and store a PB in that. We are doing exactly that and it works great. You just have to close the PBs when the work of your thread is done, of course. Tino Ernst Temp wrote: Hello, I am developing an

Re: Can't read repository file 'repository.xml

Hi, read: http://db.apache.org/ojb/docu/guides/ojb-properties.html. Have a look at the examples. You don't explicitly load the repository.xml file. Tino Sergio del Amo Caballero wrote: Hi all, I am getting an error while trying to retrieve my repository.xml file. My repository.xml is

Re: Finding Broker/Connection leak

the impact to our system. With regards Tino Armin Waibel wrote: Hi Tino, Tino Schöllhorn wrote: Hi, I have a situation where we are running out of PersistenceBrokers (using 1.0.1). We have a web application which so far runs fine - but somehow some requests are causing the application not to close

Finding Broker/Connection leak

Hi, I have a situation where we are running out of PersistenceBrokers (using 1.0.1). We have a web application which so far runs fine - but somehow some requests are causing the application not to close its PB. We can see this when we are monitoring the used connections of mysql which are

Re: Finding Broker/Connection leak

An additional question: How could I monitor the PB-Pool and the Connection-Pools of OJB? Tino Tino Schöllhorn wrote: Hi, I have a situation where we are running out of PersistenceBrokers (using 1.0.1). We have a web application which so far runs fine - but somehow some requests are causing

OJB, MySQL and Query Cache

Hi, probable this isn't the correct forum - but nevertheless I hope that some can help me out. We are using OJB 1.0.1 (we're waiting for a new release to change to) and MySQL 5.0.18. Everything is working fine and OJB works like a charm. Now our sites are getting more traffic and we wanted

Re: OJB, MySQL and Query Cache

this flag in the connection string to disable server side prepared statements: jdbc:mysql://useServerPrepStmts=false; Tino Tino Schöllhorn wrote: Hi, probable this isn't the correct forum - but nevertheless I hope that some can help me out. We are using OJB 1.0.1 (we're waiting

hashCode for Query-Objects

Hi, I have to put OJB-Query-Objects as key in a Map. Now I wonder how I would compute the hashCode of those objects. A first idea was to use the generated SQL-Code for such a Query as the key. How would I get the SQL-Code which gets generated for a Query-Object? But any other ideas how to

Re: How to do this in OJB

Hi, I think you could do a ReportQuery where you can specify an SQL. Just look in the tutorials and the JavaDocs. Tino k jee wrote: Hi All, I need some advice on how to achieve the following with ojb. Select T1.FLD1,T1.FLD2, T2.FLD2,T2.FLD3,T3.FLD1,T3.FLD2,T3.FLD4 from table1 T1,

Re: Next Release

Hi, thanks. That would be great. Tino Armin Waibel wrote: Hi Tino, Tino Schöllhorn wrote: Hi, we are currently using OJB 1.0.1 and are thinking about updating to the latest release. When do you think the next version 1.0.5 will be released? Last week I wasn't able to work on OJB. I

Next Release

Hi, we are currently using OJB 1.0.1 and are thinking about updating to the latest release. When do you think the next version 1.0.5 will be released? With regards Tino - To unsubscribe, e-mail: [EMAIL PROTECTED] For

Way to prevent store?

Hi, I have a situation where I want to prevent the creation of an object in the database. Is there a way to prevent the insertion via the callback-methods (beforeInsert) ? Throwing an Exception in these methods doesn't work, because the situation is not an error and I want to prevent the

Setting Default Class for Collections

Hi, I want to use an own implementation of a java.util.List-Class in my project and I am trying to find the place where to change the default List implementation. I couldn't find it int the OJB.properties file. I am using OJB 1.0.1. With regards Tino

PB.store extremely slow

Hi, we are using OJB 1.0.1 and we have found a very strange issue: We have a class User and a class Group. Now we have a quite common and simple use-case that a User becomes member of a Group. The code for this is like: User user = ...; Group group = ...; user.addGroup(group);

Re: PB.store extremely slow

if this is a bug or a feature ;-) What do you think? Tino Tino Schöllhorn wrote: Hi, we are using OJB 1.0.1 and we have found a very strange issue: We have a class User and a class Group. Now we have a quite common and simple use-case that a User becomes member of a Group. The code for this is like

OJB 1.0.x and Java5.0

Hi, we are currently thinking of moving from JDK1.4.2 to Java 5.0.x. The most interesting part of new Java Editition is the use of Generics which will lead to a much better understandable code-base. I have a few questions, which might be answered by someone of the OJB community: - Are there

Re: strange OJB behaviour

Hi, would you post your loop-code, so it is possible to see what changes you are doing? Tino T. K. Chris wrote: HI, I have tried to access a database through a loop. while the loop is running, I manually modify (in live) and commit a record in the data base. The modification is not detected, at

Concurrency: Best practices

Hi, we are currently working at an web-application, which is currently single-threaded. For performance reason it is obvious that it should be multi-threaded. We are using OJB as persistence-layer. Now my question: Does anyone has best practices for creating an thread-safe object-model?

ConcurrentModificationException while Deleting Objects

Hi, I have a weird problem. We are using OJB 1.0 and are greatly satisfied. Now we stumbled across a strange problem. When deleting a Person-Object with: Person p = ...; pb.beginTransaction(); pb.delete(p); pb.commitTransaction(); we get (sometimes) the following Exception:

Re: [SUGGESTION] - S02 - Answering behaviour on this forum

Hi Ilias, well I not for starting any flame wars. But if you think there should be a common, better FAQ list and the existing documentation is not enough - why don't you just start a FAQ-List and try to improve this project. As you already stated: this is open source and anyone who is

Re: ConcurrentModificationException while Deleting Objects

Nov 2004 11:51:02 +0100, Tino Schöllhorn [EMAIL PROTECTED] wrote: Hi, I have a weird problem. We are using OJB 1.0 and are greatly satisfied. Now we stumbled across a strange problem. When deleting a Person-Object with: Person p = ...; pb.beginTransaction(); pb.delete(p); pb.commitTransaction

Re: How to monitoring connecton pool?

Hi, I don't know how to get this information. But you could quite easily configure the connection-managers as such that they are automatically closing forgotten persistence-broker instances and their connections. Please see: http://db.apache.org/ojb/docu/guides/connection.html Rodrigo G.

Special Rowreader for reading hierarchies

Hi, we are using OJB 1.0 and are greatly satisfied. Now we encounter some cases where we have recursive data-structures, like: class A { Collection someAObjects; // CollectionA } So every A-Object can have several sub-object of type A. Currently we mapped this case as every other

ConcurrentModification!!!

Hi, we are using OJB in a Tomcat-Application and are greatly satisfied. Now we are moving our application to a windows 2003 server with 2 processors and we encounter some problems. One is the following: We implemented a DownloadServlet which is responsible for delivering Streams of previously

Re: ConcurrentModification!!!

I forgot to mention that we are using OJB 1.0 ! Tino Schöllhorn wrote: Hi, we are using OJB in a Tomcat-Application and are greatly satisfied. Now we are moving our application to a windows 2003 server with 2 processors and we encounter some problems. One is the following: We implemented

Re: Debugging Queries

tino, ojb does not use the limit-clause yet. the paging is implemented by positioning the cursor in the resultset. jakob Tino Schöllhorn schrieb: Hi, I am using MySQL and OJB and now I want to create a Query over a large table. For performance reason I want to use the pageing-feature - but I

Re: Debugging Queries

Hi Thomas, I am perfectly aware of that - but in my opinion you're already doing the right thing: emulate the behaviour of paging when the underlying db isn't supporting it. But if the underlying db is supporting this feature (many db implement this: mysql, mssql, oracle...) it should be used

Weird behaviour of PersistenceBroker.store(Object)

Hi, several days ago I changed from RC6 to OJB 1.0.0 and so far it is running fine. But now I encounter a strange bug - something which has not happened with RC6. I have a class Team and there is a N-M-Relation between Teams and Subteam. Now I am adding some (already persistent) Teams t1...tn

Re: Weird behaviour of PersistenceBroker.store(Object)

) regards, Armin Tino Schöllhorn wrote: Hi, several days ago I changed from RC6 to OJB 1.0.0 and so far it is running fine. But now I encounter a strange bug - something which has not happened with RC6. I have a class Team and there is a N-M-Relation between Teams and Subteam. Now I am adding some

Inheritance: One Table

Hi, I have I inheritance-problem. I want to map two classes to one table. They are defined as followed: class A { int id; protected String ojbConcreteClass; // some attributes } class B extends A { // some additional attributes } I created class-descriptors

Re: Inheritance: One Table

what do I do now? Should I ignore this warning? Or do I have to create a not-persistent abstract superclass? Tino Thomas Dudziak wrote: Tino Schöllhorn wrote: Hi, I have I inheritance-problem. I want to map two classes to one table. They are defined as followed: class A { int id

Deletion and Cache

Hi, I think this topic has been discussed before. But I am not sure what the current status is: I have two classes A and B. A has a Collection of Bs. Now if I delete a B object which is part of a Collection of an A object the B object is correctly deleted in the database and is also removed

Re: Collection creation and sorting

are attributes on the RoomImpl object. Wally -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Tino Schöllhorn Sent: Friday, April 30, 2004 2:41 AM To: [EMAIL PROTECTED] Subject: Collection creation and sorting Hi, I have a (probably simple) question about sorting

Collection creation and sorting

Hi, I have a (probably simple) question about sorting collections: I have 3 classes which I successfully mapped to OJB: class Company { Collection companyTeams; public Collection getTeams() { //??? } } class CompanyTeam { Company c; Team t; int pos; } class Team { String

CreationDate-Column for each Table

Hi, I have a (quite small) problem: I want that each table in my database has an attribute CreationDate which reflects the time when this row has been inserted. But I don't want to use any database-specific datatypes or functions. My current idea is really simple and uses the

Rechtekonzept

Hallo, ich habe mal versucht, das Rechtekonzept nochmal zusammenzufassen. Wäre gut, wenn ihr Euch es mal anschauen würdet. Ihr findet es im Projekt 1.Release im Intranet unter dem Order Konzepte. Gruss Tino - To unsubscribe,

Re: soft-deleting objects

. If you mean to not flag the delete in the database at all, but only treat it as such in the application -- that is a bit trickier, but can probably be done via pb callbacks/row readers. -Brian On Mar 23, 2004, at 6:21 AM, Tino Schöllhorn wrote: Hi, I want to implement something like a soft-delete

Re: soft-deleting objects

to the criteria. Charlie Tino Schöllhorn wrote: Hallo Daniel, that sound great. But still I do have one question: how could you then load all non-deleted object *without* using the deleted-flag. I mean something like Criteria crit = new Criteria(); // I can use any criteria here but I don't want

Re: soft-deleting objects

really like not having to fuss about with the PersistenceBroker all the time. Charlie Tino Schöllhorn wrote: Hi, that sounds great. Is there a way to tell OJB that it always should use MyCriteria from the QueryFactory? Or do I have to implement an own version of it? Regards Tino Charles N

Changing Loading Behaviour for N-M-Relations

Hi, I am trying to change the behaviour of loading N-M-Relations - but I have some trouble here. Essentially I have one class Department and a relationship subdepartment (so I have 2 tables Department and Department_Department). Now I want that OJB loads only those subdepartments of a

Re: soft-deleting objects

= 'A' crit.addEqualTo( deleted, false ); // adds WHERE sub.deleted = 'false' Take a look at the tutorial, its really helpful in describing better ways to setup your data and how to query it. Charlie Tino Schöllhorn wrote: Hi, I just tried what you suggested and it seems to work fine. 1.) I extended

soft-deleting objects

Hi, I want to implement something like a soft-delete: Objects should be marked as deleted in its corresponing table and OJB should just ignore them when it is materializing or querying them. Where would be the best point to start when I want to implement this feature? I just played around

creationDate and lastUpdate for classes

Hi, I am successfully using OJB rc5 and I really appreciate this tool. Now I want to extend my data-model so that I have 2 additional fields: - creationDate: the date the object/row was created - lastUpdate: the date the object/row was last updated Currently we are using MySQL as database, but

ConnectinPooling

Hi, I am using OJB(cvs head from 2 weeks ago) in Tomcat 5.0. There I have several PersistenceBroker which I close after each request with PersistenceBrokerFactory.realeaseAll(). After some time I get the following error: org.apache.ojb.broker.PBFactoryException: Borrow broker from pool

Re: ConnectinPooling

Hi, thanks. I wasn't aware of the PeristenceBrokerPool concept. regards Tino Armin Waibel wrote: Hi Tino, Tino Schöllhorn wrote: Hi, I am using OJB(cvs head from 2 weeks ago) in Tomcat 5.0. There I have several PersistenceBroker which I close after each request

Re: FunctionSequenceError and MSAccess

Tino, Tino Schöllhorn wrote: Hi, I am using OJBrc5 (rebuild from CVS head) and I have some troubles with my database: sometimes (not always) when I want to insert or update an object via ojb the JdbcOdbcBridge throws an function sequence error. From my previous experiences this error occurs

QueryFactory issue

Hi, I could pinpoint the described error which has been described in an earliear thread (Cache issue: 13.2.2004). It all boils to the QueryFactory.newQuery(Class, Criteria, boolean) method. if I execute the code to retrieve an instance of class Person with: Criteria crit = new Criteria();

Re: QueryFactory issue

Hi, sorry I got it. It is a database-error. Access doesn't return memo fields when using distinct (g). my fault. tino Tino Schöllhorn wrote: Hi, I could pinpoint the described error which has been described in an earliear thread (Cache issue: 13.2.2004). It all boils

Re: Cache issue

query = QueryFactory.newQuery(Person.class, crit, true); After that query the LONGVARCHARS aren't correctly instantiated. I think that this might be an error of OJB. With regards Tino Armin Waibel wrote: Hi, Tino Schöllhorn wrote: Hi, I have (again) something weird which I suppose is just

Cache Bug with multiple PersistenceBrokers?

Hi, I have a very, very strange phenomenom: I have one web-application which handles several clients. Each client uses its own database, but the database schema is always the same. Our web-application handles requests for all clients, so I have to switch the PersistenceBroker as soon as I

Blobs and MSAccess

Hi, has anyone tried using OJB with MSAccess and can successfully handle BLOBs? I am wondering if I could use OJB to handle this. With regards Tino - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: Checking repository.xml with dtd

reference-descriptor, then all collection-descriptor regards, Armin Tino Schöllhorn wrote: Hi, I want to ensure that the repository.xml-file is syntactically (is that english) correct. So I am trying to validate it against its dtd with the following code: DocumentBuilderFactory factory

Re: Using VerifyMappingTask

Hello Armin, is there another way to verify the mappings which is not outdated? regards, Tino Armin Waibel wrote: Hi Tino, the VerifyMappingsTask is a little bit outdated, thus I don't know if you will get an adequate result. regards, Armin Tino Schöllhorn wrote: Hi, I want

Using VerifyMappingTask

Hi, I want to automatically check the integrity of the repository.xml file and the corresponding database-mapping. So I tried out the VerifyMappingTask which is includes in the OJB-distribution (I am using rc5). But I am having problems with the classpath. Here is the situation: - My

Re: Using VerifyMappingTask

Hi Thomas, thanks for your answer. I checked again, but still I get a NoClassDefFoundError. Unfortuanately there is not stacktrace so it is quite difficult to find it. The class kos.generator.DataObject is located in the ojb-generator.jar file. This jar is correct because I am using this JAR

Starting applicatio via ant

Hi, I have a quite strange problem: I am trying to start an ojb-based application via ant and the commons-laucher tool. I have struggled some time with setting the classpath correctly and it works now fine - except for one ugly thing: I had to pass an ABSOLUTE path in the OJB.properties -file

Design Pattern for referential integrity

Hi there, this is a topic which is not specifically bound to ojb - but since there are a lot of users out there who might have the same problem (and hopefully a solution) I post this message here: I have several classes which I use to map tables to objects. Now I am wondering what the most

Weird Error in Access with Memo-Fields

Hi, I am using OJB and Access at the moment. So far everything worked fine, and I can also store memofields to the database. Now I integrated my classes in a web-application and there I get a really strange behaviour, when I save my data to the database: A) When I start Tomcat (5.0) and edit

Re: Deletion Bug!!!!!?

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 remove this relation. It is another thing when I remove an instance of a class - then the default behaviour could delete the relations as

Deletion Bug!!!!!?

Hi, I have a really weird problem and I don't if I am doing something wrong or if this is a bug of OJB. I have basically 2 classes: Person and Department. I defined a N:M relation between those two. Now I want to remove a Department from a Person. But what happens is, that OJB is trying to

Re: Re:Deletion Bug!!!!!?

Hi, the autodelte flag is set to false. Here is my complete collectin-descriptor !-- N:M - Relation Company-Person -- collection-descriptor name=persons element-class-ref=kos.intranet2.om.Person auto-retrieve=true auto-update=true auto-delete=false proxy=true

Re: Deletion Bug!!!!!?

a RemovalAwareCollection) like this (as an a attribute of the collection descriptor element): collection-class= org.apache.ojb.broker.util.collections.ManageableArrayList - Original Message - From: TINO SCHÖLLHORN [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 3:57 PM

Re: MS Access Memo Field

Graham Lounder [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] Hey all,Hi, as I can see you only have to set the data-type in your repository.xml of the memo-field to LONGVARCHAR. I have had the same problem, but now it is running fine. Tino I'm trying to save a string

Optional Feature not implemented

Hi, currently I am using OJB 1.0rc4 for the object-relational mapping with MS Access an the Jdbc-Odbc-Bridge from SUN. I know that there are some issues with this database but nonetheless I have to make OJB working with it. So far everything worked quite well and I couldn't find any of those