Announcement Announcement Module
No announcement yet.
Oracle "Invalid query size" on cachedrowset Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Oracle "Invalid query size" on cachedrowset

    This is to point out the issue uncovered in this thread:

    Which is directly related to the issue reported at the sun forums here:

    The quick summary is that the Oracle JDBC driver is incompatible with Sun's cached rowset implementation (CachedRowSetImpl). the call getScale() on Oracle's driver returns -127 when there is no scale specified on a number data type. Sun's CachedRowSetImpl spit's the dummy reporting "Invalid scale size - scale must be more then zero". Oracle's CachedRowSetImpl however handles it OK.
    This is of course a problem, as Spring uses Sun's CachedRowSetImpl.
    There are a couple of work arounds, but unfortunately none of them really solve my specific case:

    Any suggestions would be really appreciated.
    Last edited by antony.stubbs; Jul 4th, 2007, 07:08 PM. Reason: query -> scale

  • #2
    Well - seems as though I've found the problem:
    I find that quite offensive.
    By default, it's false.
    More info here: