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

    de151a45-1002-4c34-af5b-ae90c7391a49

      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