combine resultset

[avihaimar]

Hello
I have a long statement so when i execute it i get an exception :
"Statement length exceeds maximum "
the statement is in this format : select from table where clauseA or clauseb or ...

i wonder if there is a way to overcome on the length restriction ?

in case that there is no way and i need to split the query i wonder if there is any solution to union all the resultset that i get into one resultset ?

thank you a lot.

[Davey]

Is it possible to run your query either through a stored procedure or view on the database? That way you wouldn't need to have such a long statement poassed to JDBC.

[avihaimar]

but the statement is dynamic