Re: 2 Databases connected to OJB??

2004-08-28 Thread Angus Berry
Armin, The simpler option#2 below, is working for me... thanks. I wonder if you could describe the syntax to connect to the second DB using OQL instead of the Native PB. thanks again... On Wed, 2004-04-21 at 04:20, Armin Waibel wrote: > Hi Angus, > > Angus Berry wrote: > &g

Re: 2 Databases connected to OJB??

2004-04-21 Thread angus . berry
Armin, Thanks for your detailed advice... I'll be exploring both options. On Wed, 2004-04-21 at 04:20, Armin Waibel wrote: > Hi Angus, > > Angus Berry wrote: > > > I'm hoping someone can help me out here. I'm running OJB quite happily, > > but now I need

2 Databases connected to OJB??

2004-04-20 Thread Angus Berry
I'm hoping someone can help me out here. I'm running OJB quite happily, but now I need to add a second Database. The second database is akin to a data warehouse. It contains a large amount of data that I only want to read from for reference purposes. In the future, other applications may also inde

OQL Select by Month

2004-03-26 Thread Angus Berry
I wonder if it's possible to construct an OQL Query (or maybe PB) that is the equivalent of this (in PostgreSQL): select * from tbl_my_table where date_part('month', mt_date) = 12; This selects all records with the month 12. I guess the alternative in OQL that I'm working with is: 'WHERE >= firs

Re: OQL Query by date

2004-03-26 Thread Angus Berry
ad of refactoring my code :-) On Fri, 2004-03-26 at 10:00, Brian McCallister wrote: > On Mar 26, 2004, at 9:15 AM, Angus Berry wrote: > > > Thanks... for the record then 'date' was a bad name for a class > > attribute to be persisted in OQL? > > > > Yes

Re: OQL Query by date

2004-03-26 Thread Angus Berry
"=61 > > the word "date" is a token in OQL =( > > -Brian > > On Mar 25, 2004, at 5:00 PM, Angus Berry wrote: > > > (rc5) > >> From everything I've read I think this should work. I'm trying to > >> select > > an objec

OQL Query by date

2004-03-25 Thread Angus Berry
(rc5) >From everything I've read I think this should work. I'm trying to select an object by it's id & date: query.create("select invoice from " + InvoiceBO.class.getName() + " where invoiceID = $1 and date = $2"); Before I even get to bind the query values (query.bind(invNum)), I get an error sa

Re: OJB with Spring

2004-03-24 Thread Angus Berry
I was wondering what you don't like about Hibernate? I have a couple of OJB projects, but hear a lot of talk about Hibernate. Someone close to Hibernate said that their caching was better. I don't plan on switch anything, but I'd appreciate any insight from folks who know both products. On Wed, 2

Re: JDO status for OJB 1.0 RC5

2004-03-20 Thread Angus Berry
also always help implement the JDO API on top of OJB ;-) > > -Brian > > On Mar 18, 2004, at 8:37 AM, Angus Berry wrote: > > > I wonder if some could give me a little more in depth status of JDO in > > RC5. > > > > Specifically, from looking at the mail archi

JDO status for OJB 1.0 RC5

2004-03-18 Thread Angus Berry
I wonder if some could give me a little more in depth status of JDO in RC5. Specifically, from looking at the mail archives I understand that in addition to the JDO ref. mask, there is some native JDO already implemented. So I'm wondering if what's available is buggy or just incomplete and is this