Java/Oracle thin driver SQL statement limit

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • DiggidyMack69
    #1

    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'did n'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.SQLEx ception: 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...
    Tags: None
    • simon
      #2
      Re: Java/Oracle thin driver SQL statement limit

      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.

        Comment

        • SteveE
          #3
          Re: Java/Oracle thin driver SQL statement limit

          simon wrote:[color=blue]
          > 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.[/color]
          Or create a View and query off that.

            Comment

            Previous template Next
            Working...