Difficulty in resolving Date ORA-12899: value too large for column
746915Jan 16 2010 — edited Mar 17 2010Hi,
I am having great difficulty to resolve the following error for insert of date column in DB : java.sql.SQLException: ORA-12899: value too large for column
Oracle Database Version : 10.2.0.3.0
Oracle Client Version : 10.2.0.1.0
Oracle DB OS - Win2003 R2 E x64.
Oracle client OS - Windows 2003 R2 E x32
JDK version : 1.4
We have our software running on multile m/cs. Most of the places its working fine. But on one m/c, we are facing issue for the same code and same database.
On that m/c, 1000 sqls are executed successfully, but some times one of them fails and gives below error. This issue is very hard to reproduce. It comes once in a while but it has affected our software quality a lot.
Date is 'Wed Sep 30 00:00:00 CEST 2009'
Error is :-
java.sql.SQLException: ORA-12899: value too large for column "PRD_7"."SUMMARY_TABLE"."PERIOD_END_DT" (actual: 40, maximum: 7)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:671)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:597)
at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:570)
at oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:763)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1159)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367)
This problem has really show stopper to us and I cannot see how to resolve it.
Can someone, please help me?