hi hans,
please try the following count-query:
Criteria crit = new Criteria();
crit.addEqualTo("phoneNumber.rftelco.rftelcoId", new Integer(65));
broker.getCount(query);
the generated sql for hsqldb looks like this:
SELECT count(*) FROM CALLS A0 INNER JOIN PHONE_NUMBER A1 ON
A0.PHONE_NUMBER_I
Jakob Braeuchi schrieb:
hi hans,
the repository_internal contains only ojb internal classes.
please post the repository that defines your classes.
oh im sorry.
I hope, this is the right one.
I have an ant script, what create this Files automaticly, so i dont look
in it, because it is worki
hi hans,
the repository_internal contains only ojb internal classes.
please post the repository that defines your classes.
jakob
Hans Novak schrieb:
Hello Thomas (and Jakob)
Thomas Franke schrieb:
I'll take a closer look to your statements and tables and try it. Did you
publish all your term
Hello Thomas (and Jakob)
Thomas Franke schrieb:
I'll take a closer look to your statements and tables and try it. Did you
publish all your terms so that I can find them into the previous mails?
I'm not shure.
So her are my classes and the repository: I hope, thats what you need.
Hans
pac
hi hans,
imo you should post the relevant parts of your repository.
jakob
Hans Novak schrieb:
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 RFTE
Hans Novak wrote:
> Can you give me a hint howto realize that ?
I'll take a closer look to your statements and tables and try it. Did you
publish all your terms so that I can find them into the previous mails?
Regards,
Thomas
-
Thomas Franke schrieb:
Hans Novak wrote:
How can i use the ReportQueryByCriteria with more then one class, or is
it a chance to give the broker a native SQL script, without a class ?
Maybe in this case you need a special class with your preferred reference
descriptors?
Can you giv
Hans Novak wrote:
> yes, this was my first way too. But the "addSql" will insert this sql
> script after "select ... from .. [here will be inserted]"
I see.
Regards,
Thomas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additi
Hans Novak wrote:
> How can i use the ReportQueryByCriteria with more then one class, or is
> it a chance to give the broker a native SQL script, without a class ?
Maybe in this case you need a special class with your preferred reference
descriptors?
Regards,
Thomas
---
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
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
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
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
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
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,
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
16 matches
Mail list logo
