Hy
I use ojb with an oracle DB.
Usualy I create my dynamic SQL's by great hirarchical Criterias. And create a
new ReportQuerry.
ReportQueryByCriteria rq =
QueryFactory.newReportQuery(
TFoto.class, new String[] { "fotoId" }, crit, true);
But in one special querry the Optimicer from Oracle produce a very bad
Executionplan becos he dont now the concret Value of the bindvariables in my
SQL.
Now I'm seatching vor a option wher I can disable the use ob bindvariables. So
that the created SQL includes the concret values instat of bindvariables.
Sample:
select * from table where col_id = :a; -> thats with bindvariables
select * from table where col_id = 1526; -> thats with concret value
Is there someone who can help my? Thanks
Berner Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
