471,050 Members | 1,387 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

Java/Oracle thin driver SQL statement limit

Hello folks,
I have a jsp using the thin oracle drivers. I need to add a query for
a large table (70 something columns...I'didn't build it) due the high
number of columns and some things that are going on in the WHERE
clause the query itself pretty long. The query runs fine in SQL*Plus
without errors but when I add it to my JSP I am getting the exception
"java.sql.SQLException: SQL string is not Query".
This was working fine on another page with a much more manageable
query.

Is there a fixed limit to the amount of text you can pass in a query?
if so does anyone know what it is?

thanks...
Jul 19 '05 #1
2 5108
Why don't you create a stored procedure in Oracle to handle the query and
then call the stored procedure from JSP? It is more efficient that way.

simon.
Jul 19 '05 #2
simon wrote:
Why don't you create a stored procedure in Oracle to handle the query and
then call the stored procedure from JSP? It is more efficient that way.

simon.

Or create a View and query off that.

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by DiggidyMack69 | last post: by
2 posts views Thread by Dave Brueck | last post: by
reply views Thread by Oxmard | last post: by
5 posts views Thread by Joe Kinsella | last post: by
3 posts views Thread by owen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.