How to do SQL MIN MAX functions ??

2003-02-10 Thread Stefan Schlösser
Hi, I would like to use sql functions such as min and max for an SQL query. I used the queryFactory create ( .. sql) method. This does require a class AND a table name specified in the from clause. Why is this so ? I would not want to specify the table name since this is something done via the m

Fetch rows n to m; Lazy instantiate objects/rows

2003-02-10 Thread Stefan Schlösser
Hi all, when retrieving data from a DB a sometimes don't want to fetch all data, e.g I want to fetch 100 rows at a time. E.g. when I allow a user to page through a ton of results I would like to only fetch the next page. I would therefore need some Criteria to say fetch rows from n to m only.

Re: PBKey and OJB 0.9.9

2003-02-10 Thread Jason Mihalick
I whole-heartedly agree. Thanks for responding so quickly, and thanks for correcting this. Thanks to you too Shannon for the great suggestion. -- Jason - Original Message - From: "Armin Waibel" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003

Re: PBKey and OJB 0.9.9

2003-02-10 Thread Armin Waibel
- Original Message - From: "Shannon Ewing" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 11:14 PM Subject: RE: PBKey and OJB 0.9.9 > Are you saying that if the connection is not "default" then the user and > password must be passed in desp

RE: PBKey and OJB 0.9.9

2003-02-10 Thread Shannon Ewing
Are you saying that if the connection is not "default" then the user and password must be passed in despite the fact that the user and password is defined in the jdbc-connection-descriptor? This does not make since. The only difference should be the connection being flagged as default which would b

Re: PBKey and OJB 0.9.9

2003-02-10 Thread Armin Waibel
Hi Jason, sorry for the hassle, but the new release is more strict in handling different users. Thus OJB try to find a connection without user and password, because both fields were null (new PBKey("mydb")). If you only use one database per application and you set the default-connection attribute

Re: reverse-db (yet again)

2003-02-10 Thread Robert S. Sfeir
Hey Jason, How did you get it to work with Postgres? I tried in vain a few times, even with the 0.9.9 rev. Which postgres driver are you using? Tried with the JDBC 3.0 driver that comes with 7.3 R On Monday, Feb 10, 2003, at 16:24 US/Eastern, Jason McKerr wrote: I dunno what the problem is.

Re: reverse-db (yet again)

2003-02-10 Thread Jason McKerr
I dunno what the problem is. I've used the reverse tool successfully on oracle and Postgres. Maybe it's not picking up relationships because MySQL doesn't support RI? -Jason On Mon, 2003-02-10 at 13:02, Jeremy wrote: > OK, now that I know the new version supports MySQL and now that I know > th

Re: reverse-db (yet again)

2003-02-10 Thread Robert S. Sfeir
Jeremy, I tried reverse-db with various DBs, and finally gave up on it. By the time you try to figure out how to do things, chances are you've already mapped the DB manually. it's a shame it doesn't really work with DBs like SQL Server, My SQL, and Postgresql. It would in fact cut down a lot

OJB in real world

2003-02-10 Thread Nuno Marques
Hye, I'm a newbie in OJB, but I would like to know if anyone has already used OJB in real production environments. Was it sucessfull? Good performance? Scalability? Thanks, Nuno - Busca Yahoo! O serviço de busca mais completo da Internet. O que você pensar o Y

reverse-db (yet again)

2003-02-10 Thread Jeremy
OK, now that I know the new version supports MySQL and now that I know that the schema with a MySQL DB would always be represented as empty. I still am not getting what I expect to happen. I connect to my db server, read the database I want to generate classes and mapping for, then save xml.

.9.9 Field conversion on primary keys Error

2003-02-10 Thread casterx
I just upgraded to .9.9 and started to encounter a conversion bug. If a field is set as a primary key, the conversion routines are not executed. I added a printline to "org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlTimestampFieldCon version" Whenever primarykey=false, the statement get

PBKey and OJB 0.9.9

2003-02-10 Thread jrmihalick
Hi, I recently reconfigured our application to use the new 0.9.9 release. Previously we were using 0.9.8. We are using the PersistenceBroker API. After reconfiguring our repository.xml file to use the new jcd-alias attribute on the connection descriptor, my connection descriptor is as follows:

Re: update persistance

2003-02-10 Thread Christopher C Worley
Hi, Since my last post i have set the logLevel for just about everything to DEBUG. After doing this and running the program again, i noticed none of the 'UPDATE' sql statements were getting generated. Does any one have an idea of what area of the ojb source i should look into for this? -chri

New Transaction

2003-02-10 Thread Goncalo Luiz
Why do I have to open a new database everytime I need to begin a transaction ? I have to : [CODE] Database db = new Database(); db.open("OJB/repository.xml", Database.OPEN_READ_WRITE); Transaction tx = _odmg.newTransaction(); tx.begin(); [/CODE] How does the Broker do the association of tx with d

Re: Does OJB supports clustering in an EJB container?

2003-02-10 Thread Norman C . Jarvis
In an email from Thomas Mahler: "It is also possible to run the ODMG transaction manager in distributed mode. You just have to configure usage of the Persistent Lock Manager in OJB.properties." The message thread on the mailing list is: configuring OJB in a cluster Norman Jarvis On Mon, 10 Feb

Re: custom collection proxies

2003-02-10 Thread Jakob Braeuchi
hi bill, i'll hava a look at it. jakob V B Skrypnyk wrote: Hello, I woner if it would be difficult to provide a mechanism to specify a custom **collection** proxy in the instead of the default provided CollectionProxy or ListProxy (or at least be able to change the default type in the OJB.

Re: Does OJB supports clustering in an EJB container?

2003-02-10 Thread Armin Waibel
Hi Fernando, - Original Message - From: "Fernando" <[EMAIL PROTECTED]> To: "OJB User List (E-mail)" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 6:19 PM Subject: Does OJB supports clustering in an EJB container? > Hello. > > I would like to know if OJB supports clustering in an EJ

Re: tutorial1 does not work - repository.xml

2003-02-10 Thread Armin Waibel
Hi, - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 2:23 PM Subject: tutorial1 does not work - repository.xml Hello, a colleque of mine just downloaded 0.9.9. Since last christmas, the file test/org/apache/repository.xml does not im

update persistance

2003-02-10 Thread Christopher C Worley
Hello, First off the link to subscribe to this mailing list is incorrect on the website, unless i was doing it wrong. The link has [EMAIL PROTECTED], however to subscribe i had to us [EMAIL PROTECTED] Might need to be fixed. I am having a problem with my objects getting persisted in the data

RE: How to use Proxies, was: Re: Null References and Proxies

2003-02-10 Thread Tal Yalon
Hi Olli, From what I remember, if you define your primary key field(s) to be NON-primitive (e.g. Integer instead of int) OJB can correctly set the proxy reference to null if the primary key field was null (maybe also add refresh="true" in the reference descriptor but I'm not sure since it's been

Does OJB supports clustering in an EJB container?

2003-02-10 Thread Fernando
Hello. I would like to know if OJB supports clustering in an EJB container. That is, I want to use OJB from inside sessions beans running in a clustered enviro. I want to use OJB cache, and I'm worried about when a session bean updates the datastore. The question can be illustrated with this: 1.

RE: How to use Proxies, was: Re: Null References and Proxies

2003-02-10 Thread oliver . matz
Hej Armin, thank you for your answer. > I could kick out the log statement if this > solve your problem? That would be an improvement, but not satisfactory: throwing and catching exceptions is costly. A better solution would be an API method or some other defined way to tell whether the proxy w

tutorial1 does not work - repository.xml

2003-02-10 Thread oliver . matz
Hello, a colleque of mine just downloaded 0.9.9. Since last christmas, the file test/org/apache/repository.xml does not import repository_user.xml any more. Consequently, tutorial1 does not work. Is that intended? In order to correct this, the line include &user must be uncommented a

Re: How to use Proxies, was: Re: Null References and Proxies

2003-02-10 Thread Armin Waibel
Hi Oliver, think there is no need to log this exception, re-throw it will be enough. I could kick out the log statement if this solve your problem? regards, Armin - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 11:47 AM Subject: RE:

RE: How to use Proxies, was: Re: Null References and Proxies

2003-02-10 Thread oliver . matz
Hello, > I am still wondering how to use proxies appropriately. > Someone else must have done this before. I seem to be the only one interested in this, but nevertheless I would like to say that I found another problem. see below. > > > -Original Message- > > >In short: Is is intende

RE: Why does odmg.OJB try to be a singleton?

2003-02-10 Thread oliver . matz
Hello Armin, > -Original Message- > From: Armin Waibel [mailto:[EMAIL PROTECTED]] > > Hi again, > > Oliver wrote: > > I want to build an application-server-like > > thing that allows several clients to connect to the same > > database. > > Hope I catch the sentence of this, you got > pr

Re: Why does odmg.OJB try to be a singleton?

2003-02-10 Thread Armin Waibel
Hi again, Oliver wrote: > I want to build an application-server-like > thing that allows several clients to connect to the same > database. Hope I catch the sentence of this, you got problems using ODMG with several clients although all clients do a Implementation odmg = OJB.getInstance(); call?

RE: Why does odmg.OJB try to be a singleton?

2003-02-10 Thread oliver . matz
Hello Armin, > -Original Message- > From: Armin Waibel [mailto:[EMAIL PROTECTED]] > which version do you use? > I think >0.94 OJB isn' a singleton. current cvs HEAD: /** * private Constructor: use static factory method * getInstance() to obtain an instance */ prot

Re: Why tries odmg.OJB to be a singleton?

2003-02-10 Thread Armin Waibel
Hi Oliver, which version do you use? I think >0.94 OJB isn' a singleton. regards, Armin /** * Return new instance of the {@link org.odmg.Implementation} class. */ public static Implementation getInstance() { OJB implementation = new OJB(); implementation.setConfigurato

Why tries odmg.OJB to be a singleton?

2003-02-10 Thread oliver . matz
Hello, I have a question and a remark. Q: Why is odmg.OJB a singleton? Am I going to run into problems if I use two instances of OJB? R: Since the constructor of OJB is protected, I can easily bypass the singleton constraint by firstOdmg = OJB.getInstance(); secondOdmg = new OJB() {}.g