Re: HowToDo INTERSECT query

2004-04-18 Thread Jakob Braeuchi
hi glenn, unfortunately the only solutions is to use a queryBySql or you do the intersect processing programmatically. jakob Glenn Barnard wrote: I need to perform the following SQL query against my db. Can anyone steer me in the right direction? SELECT * FROM keywords WHERE keyword_id IN

Re: Is it platform independant if I use upper() and like '%'?

2004-04-18 Thread Jakob Braeuchi
hi zhe, upper is not platform independent. i'm not sure about the '%' most dbms accept it but ms-access uses '*' . jakob ZZZ Liu wrote: Hi All, I am using ojb as the persistence layer and assume that I don't need to re-write my code if I need to switch to a different database. However, if I

Re: RC6 inheritance question.

2004-04-18 Thread Jakob Braeuchi
hi ziv, this also works for three levels. jakob Ziv Yankowitz wrote: Hi Folks, if I have a three level inheritance each mapped to it's own table, where Class C extends Class B extends Class A and I want to query Class C to bring all the data of all level is this possible? I know in two

Re: RC6 inheritance question.

2004-04-18 Thread Mark Berry
- Original Message - From: Jakob Braeuchi [EMAIL PROTECTED] To: OJB Users List [EMAIL PROTECTED] Sent: Monday, April 19, 2004 8:41 AM Subject: Re: RC6 inheritance question. hi ziv, this also works for three levels. jakob Ziv Yankowitz wrote: Hi Folks, if I have a three

RE: deploying OJB in Jboss

2004-04-18 Thread Stephen Ting
Hi Armin, If I were to have multiple ejb.jar that have it owns repository (class descriptor, jdbc-connection-descriptor). OJB will only found the jdbc connection descriptor of the ejb.jar that is firstly deployed. What is the correct strategy for deployment of multiple ejb.jar with it own bundle

Fw: success deploying ojb in jboss

2004-04-18 Thread Michael Mogley
Please keep these things on the list. - Original Message - From: Stephen Ting [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 18, 2004 7:33 PM Subject: RE: success deploying ojb in jboss Hello Michael, I had some problems using the EAR template suggested by you in Jboss