my every entity beas has findAll() method defined in ejb-jar.xml as follow:
<query>
<query-method>
<method-name>findAll</method-name>
<method-params/>
</query-method>
<ejb-ql><![CDATA[SELECT OBJECT(o) FROM firm o]]></ejb-ql>
</query>Could be this done better by other mechanism? JBoss are generating this query for PostgreSQL:
// get all id's LOG: query: SELECT t0_o.firm_id FROM firm t0_o
// call for every id
LOG: query:
SELECT firm_id,name FROM firm WHERE (firm_id=1) OR (firm_id=2) OR (firm_id=1046258766552575) OR (firm_id=1046258766812847) OR (firm_id=1046258766781998) OR (firm_id=1046258766823725) OR (
firm_id=1046258766815290) OR (firm_id=1046258766821931) OR (firm_id=1046258766808355) OR (firm_id=1046258766805899) OR (firm_id=1046258766840567) OR (firm_id=1046258766818653) OR (firm_id=1046258766857549) OR (firm_id=1046258766870043)
...
LOG: query: SELECT firm_id,name FROM firm WHERE (firm_id=1046258766821931) OR (firm_id=1046258766808355) OR (firm_id=1046258766805899) OR (firm_id=1046258766840567) OR (firm_id=1046258766818653) OR (
firm_id=1046258766857549) OR (firm_id=1046258766870043)
...
LOG: query: SELECT firm_id,name FROM firm WHERE (firm_id=1046258766818653) OR (firm_id=1046258766857549) OR (firm_id=1046258766870043)
...
LOG: query: SELECT firm_id,name FROM firm WHERE (firm_id=1046258766857549) OR (firm_id=1046258766870043)
...
// last sql query LOG: query: SELECT firm_id,name FROM firm WHERE (firm_id=1046258766870043)
why are sending JBoss not for every firm_id one query?
I have other tables, where are stored much more values. which generate than longer query.
Best Regards, Rafal
------------------------------------------------------- This SF.net email is sponsored by: Scholarships for Techies! Can't afford IT training? All 2003 ictp students receive scholarships. Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more. www.ictp.com/training/sourceforge.asp _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
