1:n mapping problem

2004-05-20 Thread Wolfgang Schmiesing
Hi, I'm trying to do the following 1:n mapping. Class Project should have a vector of n Resource objects, while each Resource object should know it's Project object. Storing objects works fine, the references in the resource objects to their project objects are placed by OJB. What does not work

JDO and using multiple jcd-alias

2004-05-20 Thread Alexandre BOISSEAU
Hi, I have two applications which using 2 different databases. I have a single repository.xml file with two and with two different ccd-alias tag. With PB and ODMG api, we can use this jcd-alias to differentiate the connection. What is the equivalent method with JDO. Anyone can help me ? Best r

Non-deterministic queries generated for references through extents

2004-05-20 Thread Steve Clark
I have encountered a situation where OJB at different times generates two different SQL queries from the same Criteria object, I guess according to the order of some (unordered) collection. My repository is like this:

RE: How to use DUAL table for multiple types of queries

2004-05-20 Thread Glenn Barnard
Andrew, thanks for the quick response. Unfortunately, we're already using a ReportQuery. Here's the code snippet calling OJB: String[] columns = { "ypas.f_GetRotationDate ( " + listingId + "," + locationId + ",'" + zuluStartDate + "') rotationDate" };

Re: Cannot make jar from CVS HEAD

2004-05-20 Thread Armin Waibel
Hi David, I try latest CVS. Works for me. Are you really use CVS head? Did you clean OJB with 'ant clean' before compile? regards, Armin David Santos wrote: Hi! Just checked out CVS HEAD and when I try to make the jar of it I get this: ===

Re: How to use DUAL table for multiple types of queries

2004-05-20 Thread Charles N. Harvey III
The only way that I can see is the one in tutorial 3. You have to add a column to DUAL called "CLASS_NAME" specifying which class that row belongs to. http://db.apache.org/ojb/tutorial3.html#Mapping%20All%20Classes%20on%20the%20Same%20Table Charlie Glenn Barnard said the following on 5/20/2004

Cannot make jar from CVS HEAD

2004-05-20 Thread David Santos
Hi! Just checked out CVS HEAD and when I try to make the jar of it I get this: == D:\Fenix\Sources\OTHER_PROJECTS\db-ojb>ant jar Buildfile: build.xml jar: set-archive-name: set-archive-name-date: detect-jdk: check-jd

RE: How to use DUAL table for multiple types of queries

2004-05-20 Thread Clute, Andrew
Based on looking in org.apache.ojb.broker.accesslayer.sql.SqlSelectStatement.getStatement() -- it looks like if no columns are specified, then it will do the multimapped object select, which you are seeing. It is clearer as what to do in the HEAD version, but in RC5, it looks like if you change it

How to use DUAL table for multiple types of queries

2004-05-20 Thread Glenn Barnard
I posted this yesterdayWould someone PLEASE help me. Am running out of time. We use Oracle 9 and have several different functions we can call. In OJB, they are all mapped with the table name of DUAL. For example: SELECT function(args) AS column FROM DUAL Our repository.xml has a table e

RE: Reference proxies & Interfaces

2004-05-20 Thread Enrique Medina
Thanks very much for your comments. Just a pair of comments: b. You say I don't have to instantiate the variable 'state' inside the constructor of class 'CityVO'. But if I don't put that code in the constructor I get the following exception: java.lang.InstantiationException: StateProxy at org.

RE: Reference proxies & Interfaces

2004-05-20 Thread Daniel Perry
I ended up spending time trying to understand proxies... confusing stuff when you start out with ojb... these days it's making a little more sense :) a. yes, it has to be of type StateProxy (the interface) as ojb will try to instanciate it with a proxy object that implements the interface. If you

Reference proxies & Interfaces

2004-05-20 Thread Enrique Medina
This is just a confirmation question about using reference proxies in OJB. I have been using them in all my applications, but I would like to confirm that I am making a good use of them. So my way of using reference proxies is: 1) Let's consider two business entities: state and city. So I have:

RE: how to count size of resultset in OJB

2004-05-20 Thread Zhou, Andrew
Thx a million! -Original Message- From: Charles N. Harvey III [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 12:04 PM To: OJB Users List Subject: Re: how to count size of resultset in OJB This works for me. --- Per

Re: how to count size of resultset in OJB

2004-05-20 Thread Charles N. Harvey III
This works for me. --- PersistenceBroker broker = null; try { broker = this.getPersistenceBroker(); return new Integer( broker.getCount( query ) ); } catch( Throwable e ) {

how to count size of resultset in OJB

2004-05-20 Thread Zhou, Andrew
Hi guys, I guess this question has been asked by many people. Basically, I'd like get the count(*) from query, that way, I can give user an option if or not user want retrieve everything back. I am wondering if there is any dicussion on this topic before. I'd really appreciate if anyone can

How to set character set for MS Access Connection.

2004-05-20 Thread AKakunin
Hello! I need to connect to specified MsAccess file from OJB by using JDBC-ODBC bridge. Everything works quite well, but I need to connect with using specified character set. I read in this article that JDBC-ODBC allows to do it: http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/bridge.html by using

Re: Interfaces and collection-proxies

2004-05-20 Thread Armin Waibel
Hi Daniel, I will fix this in doc. Thanks for the hint. regards, Armin Daniel Perry wrote: Thanks. I thought this was the case. I also found the relevant part of the tutorial on the website... "The classes participating in this relationship do not need to implement a special interface to be used

RE: Interfaces and collection-proxies

2004-05-20 Thread Daniel Perry
Thanks. I thought this was the case. I also found the relevant part of the tutorial on the website... "The classes participating in this relationship do not need to implement a special interface to be used in a collection proxy." Might I suggest this is reworded to: do not need to implement any

RE: help with 1:n mapping

2004-05-20 Thread Daniel Perry
The collection descriptor needs to be in the 1 side, not the n side... eg. say you had project - task mapping (1 - n respectively) If in the task table you have fk_project_id, and project has id, and in your classes Project.java has id and tasks field, and Task.java has projectId, and in the rep

Re: Interaction of Extent and Super

2004-05-20 Thread Jakob Braeuchi
hi gary, an extent defines subclasses in the repository. these subclasses may reside in their own tables or they may share a common table. each of the subclasses is self-contained (it's mapped on one table only). the super-reference is used to split up a class on multiple tables. each of the ta

Re: Interfaces and collection-proxies

2004-05-20 Thread Jakob Braeuchi
hi daniel, when you use a collection-proxy tho whole collection is proxied so there's no need to define an interface for the contained classes. hth jakob Daniel Perry wrote: I know that I need to use interfaces for classes if they are proxied individually, but if I am only proxying collections, d