Jump to content
JasperReports Library 7.0 is now available ×

Please solve the problem of "Numeric Overflow"


shikha1610

Recommended Posts


Please Help me,When I am running the job to fetch data from Oracle DB table and Insert into another Oracle DB table,1310000 records are being inserted succesfully.After that it is throwing the Error "Numeric Overflow".Below is the detailed Error Code.

Please Solve it its Very Urgent.

 

Thanks,

Shikha

 

Exception in component tOracleInput_1

java.sql.SQLException: Numeric Overflow

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)

at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)

at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:121)

at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:489)

at datacollection_fact.task_fact_test.Task_Fact_Test.tOracleInput_1Process(Task_Fact_Test.java:567)

at datacollection_fact.task_fact_test.Task_Fact_Test.runJobInTOS(Task_Fact_Test.java:1212)

at datacollection_fact.task_fact_test.Task_Fact_Test.main(Task_Fact_Test.java:1128)

 

 

 

 

Code:
Exception in component tOracleInput_1java.sql.SQLException: Numeric Overflowat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:121)at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:489)at datacollection_fact.task_fact_test.Task_Fact_Test.tOracleInput_1Process(Task_Fact_Test.java:567)at datacollection_fact.task_fact_test.Task_Fact_Test.runJobInTOS(Task_Fact_Test.java:1212)at datacollection_fact.task_fact_test.Task_Fact_Test.main(Task_Fact_Test.java:1128)
Link to comment
Share on other sites

  • 3 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...