1 Reply Latest reply: Jul 6, 2013 11:47 AM by jschellSomeoneStoleMyAlias RSS

    While using Springjdbc query for rowset and oracle 11g: Invalid scale size. Cannot be less than zero


      I am using org.springframework.jdbc-3.1.0.M2.jar and ojdbc6 jar to connect oracle 11g database. When i am trying to read number related columns it shows the following exception



      org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [select SD_PRO_STATUS.STATUS_ID as F1056907316997216450, SD_PRO_STATUS.STATUS_NAME as F6373028189061548480 from SD_PRO_STATUS]; SQL state [null]; error code [0]; Invalid scale size. Cannot be less than zero; nested exception is java.sql.SQLException: Invalid scale size. Cannot be less than zero


      I found a temprovery solution for this

      • Now i am using NVL function for number columns in query. while using NVL function The query is running fine.
      • And also i checked that,The query is running fine wile running the query without Springjdbc(using oracle6. jar and oracleDriver)

      How do i fix this. Please help me