Re: howto query this

hi, hmm im not shure, but this is not enough, because the the sql statement will look like this: SELECT RF_TELKO_ID,PARTNER_ID_USER,FIRST_NAME,LAST_NAME,NAME_SUFFIX,STREET,ZIP,CITY FROM RFTELCO WHERE RF_TELKO_ID = 65 and SELECT A0.PHONE_NUMBER_ID,A0.RF_TELKO_ID,A0.NUMBER FROM PHONE_NU

Re: howto query this

Hi, yes, this was my first way too. But the "addSql" will insert this sql script after "select ... from .. [here will be inserted]" Hans Thomas Franke schrieb: Hi Hans, PLEASE PLEASE HELP ME ! How about to use ReportQueryByCriteria and the Criteria#addSql method? I think it's the

RE: Optimistic Locking with PB API for 1:M

Hi, We are not using proxies for references. Thanks Rajadurai. -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 18, 2006 8:56 PM To: OJB Users List Subject: Re: Optimistic Locking with PB API for 1:M Hi Rajadurai, Rajadurai K wrote: > Hi, >

RE: Optimistic Locking with PB API for 1:M

Hi, we will call broker.store(C) for each object in the collection first then we will call broker.store(A) Regards Rajadurai. -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 18, 2006 8:56 PM To: OJB Users List Subject: Re: Optimistic Locking wit

Re: bad sql on n-m relation to subclassed object

hi Jakob Braeuchi I have this model : A link to A B, C, and D that inherit of A when i would like retreive a object A by findObjectByIdentity, the left out join make a link on A.id = A.idreftoA for each inherited classes. idreftoA is define as primary key and foreigner key of inherited classe

Re: howto query this

Hi Hans, > PLEASE PLEASE HELP ME ! How about to use ReportQueryByCriteria and the Criteria#addSql method? I think it's the best way to perform this. Hope I could help! Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For addi

Re: howto query this

hi hans, if you have the relationships properly defined, you'll not have to care about the joins. Criteria crit = new Criteria(); crit.addEqual("telcoId", new Integer(65)); ReportQueryByCriteria q = QueryFactory.newReportQuery(Calls.class, crit); q.setAttributes(new String[]{"count(*)"}); Ite

Re: howto query this

Hi, this is already done before (and working). I can read and write to the database (mysql) with ojb criterias and querys. My problem is, how i write the criterias and querys that will be translated to a sql command like described. Hans Jakob Braeuchi schrieb: hi hans, first you need to def

Re: howto query this

hi hans, first you need to define all your classes and their relationships in the repository.xml . and then you could execute a report query selecting count(*). hth jakob Hans Novak schrieb: Hi, i try many hours (without a result) to query this sql statement: SELECT count(*) FROM CALLS c,

Re: Optimistic Locking with PB API for 1:M

Hi Rajadurai, Rajadurai K wrote: Hi, We are using OJB PB API in one of out application. we are trying to do the locking for the following scenario. class A{ some fields; Integer versionMaintainedbyOjb; Collection Cs; } Class C { some fields A a Integer versionMaintainedby

Optimistic Locking with PB API for 1:M

Hi, We are using OJB PB API in one of out application. we are trying to do the locking for the following scenario. class A{ some fields; Integer versionMaintainedbyOjb; Collection Cs; } Class C { some fields A a Integer versionMaintainedbyOjb; } In our repository.xml We

howto query this

Hi, i try many hours (without a result) to query this sql statement: SELECT count(*) FROM CALLS c, PHONE_NUMBER p, RFTELCO r WHERE c.PHONE_NUMBER_ID = p.PHONE_NUMBER_ID AND p.RF_TELKO_ID=r.RF_TELKO_ID AND r.RF_TELKO_ID =65; Java Classes are CALLS, PHONE_NUMBER an RFTELCO. PLEASE PLEASE

Re: how to trace ojb query generated sql

Tuna Ozkasap wrote: > Hi every one, I need to find out how to see the generated sql for an OJB > query? You'll find your answer there: http://db.apache.org/ojb/docu/faq.html regards, Thomas - To unsubscribe, e-mail: [EMAIL PRO