use a report-query to retrieve the pks only.
hth jakob
Guido Beutler wrote:
Hi,
I've got a small problem.
I have a table with many columns. I would like to select only the primary key field with a complex select first.
It's like a candidate list. From that I can find the correct value (independen from the database).
For the correct value I would like to receive all data.
I build two classes and mapped them to the same table. This is working fine. I got one class
only with the primary key and another with all fields. I do not use inheritance, because all
entries of the table have the same type (there is no third class with another type).
The problem now is , that during the select for the primary key class OJB creates a select
for all colums although only the primary key is needed. This is working, the primary key
class is filled correctly. The the reason for building a primary key class was the performance impact
of reading all coloumns. I would like to avoid reading all colums if I need only one.
Is there a way to avoid reading all coulums directly?
best regards,
Guido
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
