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

  • Oracle "Invalid query size" on cachedrowset

    This is to point out the issue uncovered in this thread:
    http://forum.springframework.org/sho...35&postcount=7

    Which is directly related to the issue reported at the sun forums here:
    http://forum.java.sun.com/thread.jsp...712&tstart=165

    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:
    http://forum.springframework.org/sho...2&postcount=16

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

  • #2
    Well - seems as though I've found the problem:
    -Doracle.jdbc.J2EE13Compliant=true
    I find that quite offensive.
    By default, it's false.
    More info here:
    http://forum.springframework.org/sho...5&postcount=17

    Comment

    Working...
    X