RE: Intercepting updates and inserts

2004-06-02 Thread Coup, Robert Muir
x27;factory' object that was used to serve up PersistenceBroker instances, so it was easy enough for us to set up one or more listeners before we served up any PersistenceBrokers. Ron Gallagher Atlanta, GA ron dot gallagher at bellsouth dot net -Original Message- From: Coup, Robert Muir [m

Intercepting updates and inserts

2004-05-29 Thread Coup, Robert Muir
Hi all, We're using OJB to interface our application to an online database (Postgre) as well as an offline database (HSQLDB). I'm in the process of writing some simple replication code to allow offline updates to be reconciled when the data is synchronised with the online database. What I would l

RE: Additional properties for connection.

2004-05-24 Thread Coup, Robert Muir
Hi, For postgresql we just add it to the dbAlias attribute Eg. Dbalias="//myserver.example.com?ssl" to use a ssl connection Following the same logic you could use something like dbAlias="//myserver.example.com?charSet=Big5&prop2=value2&prop3=value3" Good luck, Rob :) > -O

ProxyHelper.getRealClass(o) != ProxyHelper.getRealObject(o).getClass()

2004-04-15 Thread Coup, Robert Muir
Hi, Fairly self explanatory I'm using RC5 - does anyone have any ideas why this might occur (or has it been fixed - I couldn't find anything in the CVS changelogs)? Situation: Interfaces/Inheritance hierarchy: AbstractEntity - Group* - StaffGroup* - StudentGroup* - AbstractPer

Multiple ODMG Databases open concurrently

2004-03-25 Thread Coup, Robert Muir
Hi all, Situation: We use a single data/db model which can either be an online network database (PGSql) or an offline local one (HSQLDB). At startup time, the user chooses which to use, and we just apply a different connection-descriptor. That all works great. Now one feature requires a connecti

RE: [OTM] bi-directional 1:n not working

2004-03-03 Thread Coup, Robert Muir
Any chance you could post a summary of what you learnt? Thanks, Rob :) > -Original Message- > From: Weaver, Scott [mailto:[EMAIL PROTECTED] > Sent: Thursday, 4 March 2004 11:48 a.m. > To: 'OJB Users List' > Subject: RE: [OTM] bi-directional 1:n not working > > Hi Oleg, > > I had a lo

RE: [OTM] bi-directional 1:n not working

2004-03-01 Thread Coup, Robert Muir
I'm having a great day, so ignore the previous post. :P Is appId field in the PortletDefinitionImpl populated when you retrieve it (as opposed to the app reference)? Rob :) > -Original Message- > From: Weaver, Scott [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 2 March 2004 10:49 a.m. >

RE: [OTM] bi-directional 1:n not working

2004-03-01 Thread Coup, Robert Muir
Hi, Could you send the relevant parts of your repository.xml? Rob :) > -Original Message- > From: Weaver, Scott [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 2 March 2004 10:49 a.m. > To: 'OJB Users List' > Subject: [OTM] bi-directional 1:n not working > > > > I have a PortletApplicatio

RE: Transaction Question.

2004-02-09 Thread Coup, Robert Muir
Hi, There can only be one ODMG transaction open per thread. Thanks, Rob :) > -Original Message- > From: Ziv Yankowitz [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 10 February 2004 5:39 a.m. > To: OJB (E-mail) > Subject: Transaction Question. > > > Folks, > > Is Nested Transaction supp

RE: Forcing materialization of a dynamic proxy object

2004-02-02 Thread Coup, Robert Muir
erialization of a dynamic proxy object > > > Try this > It should work :) > > import org.apache.ojb.broker.util.ProxyHelper; > > > ... > > ProxyHelper.getRealObject(iter.next()); > > > B.R > > T.H > > > -Original Message

Forcing materialization of a dynamic proxy object

2004-02-01 Thread Coup, Robert Muir
Hi all, I have searched through the archives and can't seem to find any answer. How can I force a proxy to materialize its object, or to replace the proxy object witht the real object? I have a collection of Group objects within a Paper object. Group's are proxied dynamically (group, staffgroup),

RE: complex joins

2004-02-01 Thread Coup, Robert Muir
Reading your question a bit more. Do you actually want to customize your queries for specific collection-descriptors (which is what QueryCustomizer is for), or do you just want to perform complex queries? If its the second option, complex queries are relatively straightforward once you get the ha

RE: complex joins

2004-02-01 Thread Coup, Robert Muir
Hi, It's not too difficult - basically your querycustomizer gets called with what it thinks is the query to run based on the collection-descriptor, etc. Then you can add/adjust/replace the query it is going to perform with something that suits better. Very simple example (for this collection, get

RE: How to setup this query with OJB-PB

2004-02-01 Thread Coup, Robert Muir
Hi, Minor assumption/clarification - you want to find all activities with no schedules (where activities is on the 1 side and schedules are on the N side). I'm struggling with something similar (only its nasty m:n) so you're in luck: crit.addIsNull("schedules.uid");// pk

Interfaces and Extents (NPE in TableAlias.hashCode)

2004-01-31 Thread Coup, Robert Muir
Hi all, I have a complicated situation which I have run into using proxies and interfaces... Classes: Interface Group Interface StudentGroup extends Group Interface StaffGroup extends Group Class GroupImpl implements Group Class StudentGroupImpl ex

RE: Closing ODMG JDBC Connection

2004-01-28 Thread Coup, Robert Muir
use them. It looks > like you can specify different connection pooling > implementations though so what you want is probably to set > the following in OJB.properties: > > ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.Conne > ctionFactoryNotPooledImpl > > -

Closing ODMG JDBC Connection

2004-01-28 Thread Coup, Robert Muir
Hi All, We're using a hsqldb database for part of our application, and need to package the database files up into a zip archive before exiting. Problem is, OJB doesn't seem to be closing the database connection so the files are still locked and we can't delete them once they are in the Zip file.

RE: Optimistic Locking Integer/int Bug

2004-01-20 Thread Coup, Robert Muir
> As you suggested, this is the old int/Integer problem. In OJB > the prefered way is to avoid primitives datatypes (as int, > boolean) and use only Object datatypes (as Integer, Boolean). > > I think the problem can be solved at the docs. If not then > how we can test a int to null in Java? ;

Optimistic Locking Integer/int Bug

2004-01-20 Thread Coup, Robert Muir
Hi, I think I found a minor bug in the optimistic locking (OL) code/documentation If you initialise an int field to use OL (locking="true") then updates will fail if the field is null, either silently or with a LockNotGrantedException. public class MyClass { private Integer id; p

Optimistic Locking Integer/int bug

2004-01-18 Thread Coup, Robert Muir
Hi, I think I found a minor bug in the optimistic locking (OL) code/documentation If you initialise an int field to use OL (locking="true") then updates will fail if the field is null, either silently or with a LockNotGrantedException. public class MyClass { private Integer id; p

ODMG Lock Not Granted Exception

2004-01-15 Thread Coup, Robert Muir
Hi All, I'm having some fun with Optimistic locking. Specifically, I'm trying to delete a series of objects contained in a collection, and getting the following error. org.odmg.LockNotGrantedException: Object has been modified by someone else at org.apache.ojb.odmg.ObjectEnvelopeTable.com

RE: Ordered Collections, Lists, DList

2004-01-14 Thread Coup, Robert Muir
updated so their indexes are stored. As always, suggestions are welcome. Thanks, Rob :) > -Original Message- > From: Coup, Robert Muir [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 14 January 2004 12:09 p.m. > To: [EMAIL PROTECTED] > Subject: Ordered Collections, Lists, D

RE: Qualified Collection Relationships

2004-01-14 Thread Coup, Robert Muir
the query generated by ojb. > > hth > jakob > > Coup, Robert Muir wrote: > > > Hi All, > > > > What I have : > > Root Object RO has: > > - a collection of CO objects specified using > > > > > Child Object CO has: > > - a

RE: Qualified Collection Relationships

2004-01-14 Thread Coup, Robert Muir
Hi Jakob, > you can solve this problem by using a QueryCustomizer to add > additional criteria > to the query generated by ojb. I found it! It's only mentioned in the O/R mapping tutorial but not is missing completely from the repository documentation, so I had missed it. I think it would be h

RE: Cache Mechanism

2004-01-14 Thread Coup, Robert Muir
As I understand it OQL queries always hit the database but the objects can be resolved from the cache though. If you use the PB API for accessing objects (you can do this from ODMG) then the cache is accessed much more. Good Luck, Rob :) -Original Message- From: Ronen Yaari [mailto:[EMAI

Qualified Collection Relationships

2004-01-13 Thread Coup, Robert Muir
Hi All, What I have : Root Object RO has: - a collection of CO objects specified using Child Object CO has: - a collection of CO objects specified using - a reference to a parent CO (null if the object has no CO parent) - a reference to the RO Example... RO + CO + CO + CO

Ordered Collections, Lists, DList

2004-01-13 Thread Coup, Robert Muir
Hi all, What is the best way of storing an ordered list without using Dlist which requires additional tables & SQL lookups? OrderBy works great if the positioning has some underlying field (eg. Object id, name) but if the only thing specifying the position is the list index then it doesn't work

RE: FW: NetBeans and OJB

2004-01-13 Thread Coup, Robert Muir
Hi, I really strongly suggest you make a module using an ANT build file. There are lots of docs on the netbeans site and templates in the OpenAPIs Support module. Otherwise it will just get messier and messier every time you try to do something. Once you have a module, use nice netbeans-style pat

RE: FW: NetBeans and OJB

2004-01-12 Thread Coup, Robert Muir
Hi, > No Success! :( I've mounted a directory c:\work\test and > OJB.properties is in it. What should I type after nz/ ? Ah. By nz/... I meant your path to the OJB properties file relative to the mount point It needs to be in a subfolder under the mountpoint otherwise NB won't resolve it.

RE: FW: NetBeans and OJB

2004-01-11 Thread Coup, Robert Muir
> You need the ojb libraries in your classpath. This either means - > - make a module, declare dependencies and install the libs > in netbeans-dir/modules/ext > - do it the nasty way and install in netbeans-dir/lib/ext > Or alternatively, the pinnacle of nastiness, build a jar file with all t

RE: FW: NetBeans and OJB

2004-01-11 Thread Coup, Robert Muir
Hello, Sorry about the late reply. We're using Netbeans to develop an app which also uses OJB, so I've been there and done this :) Before initialisation (ie. Any ojb-calls ) ... System.setProperty("OJB.Properties", "nz/ac/auckland/markit/ojb/OJB.properties") ... ie. Using the netbeans-style resou

RE: ojb_dlist_entries continues to grow ...

2004-01-07 Thread Coup, Robert Muir
Hi, Are you creating Dlist's within a transaction and then not persisting them? I ran into this issue amd didn't really find a satisfactory answer... I would really like to use a general list class (with ordering!) that can be made persistent but doesn't need the overhead/space of re-storing every

RE: Persisting Date and Time

2004-01-07 Thread Coup, Robert Muir
Hi Fabiano, Try JDBC-TYPE='TIMESTAMP' - and try and use java.sql.Date instead of java.util.Date... I have run into problems before with java.util.Date but YMMV. Good Luck, Rob :) > -Original Message- > From: Fabiano Fernandes de Souza [mailto:[EMAIL PROTECTED] > Sent: Thursday, 8 Janu

RE: SequenceManagerMySQLImpl

2004-01-07 Thread Coup, Robert Muir
Hi Claudio OJB's autoincrement is completely separate from the database/table autoincrement Good luck, Rob :) > -Original Message- > From: Claudio Romano [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 7 January 2004 11:53 p.m. > To: OJB Users List; [EMAIL PROTECTED] > Subject: RE: Sequen

RE: How to combine two non-decomposed m:n mappings in one collection?

2004-01-05 Thread Coup, Robert Muir
One more important thing. Make sure your primary keys are unique across Documents _and_ Downloads. Ie. If there is document #10 there should never be download #10 This is because they are in the same extent. If you retrieve a collection of SupportItemI's then they need to have unique IDs, or a Ba

RE: How to combine two non-decomposed m:n mappings in one collection?

2004-01-05 Thread Coup, Robert Muir
> The scenario is this: a PalModel should have a collection of > SupportItemsI and a > Keyword should have a collection of support items. > Keyword doesn't relate to pal_model. Okay. So what was in my last email should work :) > Something else just came to my mind: a category should also > hav

RE: How to combine two non-decomposed m:n mappings in one collection?

2004-01-05 Thread Coup, Robert Muir
> ... and now for something completely different: > > do i even have define foreign key constraints in my > database??? I'm having the > impression that OJB is handling all the joins. Is it enough > to have some loose > tables in my DB ??? Well, it's up to you. OJB can and will do it anyway

RE: How to combine two non-decomposed m:n mappings in one collection?

2004-01-05 Thread Coup, Robert Muir
s ... ... Field Descriptors ... -Original Message- From: Patrick Scheuerer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 6 January 2004 11:38 a.m. To: OJB Users List Subject: Re: How to combine two non-decomposed m:n

RE: How to combine two non-decomposed m:n mappings in one collection?

2004-01-05 Thread Coup, Robert Muir
Hi, > This sounds interesting. Just let me make sure I got it right: I have to create a new table t_download_supportitemI which has a m:n mappings to > t_download and and one to t_document (pretty much a replacement for t_pal_model) Well, I would call it t_pal_model_supportitemI, and its a re

RE: HSQLDB + JBoss Help (Function is Not Supported SQL Exception)

2004-01-05 Thread Coup, Robert Muir
,489 DEBUG [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] Resized cache for bean ConferenceAbstractStatus: old capacity = 100, new capacity = 50 Brian Sam-Bodden wrote: > Coup, Robert Muir wrote: > >> If you use hsqldb in client-server mode you can set it up to log all >> the sql queries

RE: How to combine two non-decomposed m:n mappings in one collection?

2004-01-05 Thread Coup, Robert Muir
Hi, Did you see my response to your other post? Please reply to the list. Cheers, Rob :) -Original Message- From: Patrick Scheuerer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 6 January 2004 10:17 a.m. To: OJB Users List Subject: How to combine two non-decomposed m:n mappings in one colle

RE: timestamp problem with mysql

2004-01-05 Thread Coup, Robert Muir
Hi, AFAIK, fields of TIMESTAMP type in mysql automatically fill themselves with the current time/date if you INSERT or UPDATE them to null values... Maybe you should use a mysql DATETIME field which is essentially the same data type, just without the automatic cleverness? Rob :) -Original Me

RE: Getting the Id in insertion time.

2004-01-05 Thread Coup, Robert Muir
ary 2004 11:33 a.m. To: [EMAIL PROTECTED] Subject: RE: Getting the Id in insertion time. Can I ? How I am stupped! hehehe :-) Thank you. Fabiano. Em Ter, 2004-01-06 às 04:48, Coup, Robert Muir escreveu: > Can't you just look at the primary key field (eg myObject.oid) of the > object to r

RE: HSQLDB + JBoss Help (Function is Not Supported SQL Exception)

2004-01-05 Thread Coup, Robert Muir
If you use hsqldb in client-server mode you can set it up to log all the sql queries (see Advanced Topics in the HSQLDB docs). Or configure p6spy to do the same thing on the OJB side... This might give you some ideas about what it is trying to do... I assume that your db connection in the reposito

RE: Getting the Id in insertion time.

2004-01-05 Thread Coup, Robert Muir
Can't you just look at the primary key field (eg myObject.oid) of the object to retrieve the id value? OJB/ODMG will automatically set this value when the object is persisted/retrieved... Rob :) -Original Message- From: Fabiano Fernandes de Souza [mailto:[EMAIL PROTECTED] Sent: Tuesday

RE: Mapping Question

2004-01-04 Thread Coup, Robert Muir
Hi Patrick. Is the field doc_id in download_pal_model actually meant to be model_id? Otherwise I am a touch confused :) Also, I assume you've checked out the advanced O/R mapping stuff at http://db.apache.org/ojb/tutorial3.html - if not, do it now! Idea #1: For download -> model ... Field D

RE: Ojb samples

2003-12-29 Thread Coup, Robert Muir
I assume you mean repository.xml If so: This uses Postgre's sequences to generate keys for different extents. See the tutorial docs and the sequence manager docs for more information. Thanks, Rob :) -Original Message- From: Fabiano Fernand

Ordered Lists and Index Fields

2003-12-23 Thread Coup, Robert Muir
Hi all, What is the best way of storing an ordered list without using Dlist which requires additional tables & SQL lookups? OrderBy works great if the positioning has some underlying field (eg. Object id, name) but if the only thing specifying the position is the list index then it doesn't work t

RE: Re: InitializerError + OJBRuntimeException

2003-12-23 Thread Coup, Robert Muir
Of course, this is OJB :) OJB.properties location & name can be specified through a call to System.setProperty("OJB.properties", ) before anything is done. In the OJB.properties file you can specify the location and name of the repository.xml file. Have fun, Rob :) -Original Message- F