Disable use of bindvariables

"Berner Martin" <[email protected]>
Newsgroups gmane.comp.jakarta.ojb.user
Organization SBZV
Message-ID <20060905171012273.00000002796@sbzvzgws084>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.