Disable use of bindvariables

[Berner Martin <ma...@braunvieh.ch>]

Hy
I use ojb with an oracle DB.
Usually I create my dynamic SQL's by create hierarchical Criterias. And create a new ReportQuerry.

ReportQueryByCriteria rq =
        QueryFactory.newReportQuery(
          TFoto.class, new String[] { "fotoId" }, crit, true);

But in one special query the Optimiser from Oracle produce a very bad Executionplan because he don't know the concrete Value of the bindvariables in my SQL.

Now I'm searching for a option where I can disable the use ob bindvariables. So that the created SQL includes the concrete values instead of bindvariables.

Sample:
select * from table where col_id = :a; -> that's with bindvariables
select * from table where col_id = 1526; -> that's with concrete value


Is there someone who can help my? Thanks


Berner Martin


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org