Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.1
-
Component/s: None
-
Labels:None
Description
inserting too large value into rule_failures.message column causes an error on oracle db. Safety column max width checks should be done on this column and other columns that could cause this kind of bugs.
02:10:11.001 WARN o.h.util.JDBCExceptionReporter - SQL Error: 12899,
SQLState: 72000
02:10:11.001 ERROR o.h.util.JDBCExceptionReporter - ORA-12899: value
too large for column "SONAR"."RULE_FAILURES"."MESSAGE" (actual: 780,
maximum: 500)
02:10:11.001 WARN o.h.util.JDBCExceptionReporter - SQL Error: 12899,
SQLState: 72000
02:10:11.001 ERROR o.h.util.JDBCExceptionReporter - ORA-12899: value
too large for column "SONAR"."RULE_FAILURES"."MESSAGE" (actual: 780,
maximum: 500)
02:10:11.001 ERROR o.h.e.d.AbstractFlushingEventListener - Could not
synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC
batch update
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:
103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:
91)
[...]
Caused by: java.sql.BatchUpdateException: ORA-12899: value too large
for column "SONAR"."RULE_FAILURES"."MESSAGE" (actual: 780, maximum:
500)
at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:
343)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:
10698)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:
48)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
246)
... 35 common frames omitted
[INFO]
------------------------------------------------------------------------
[ERROR] FATAL ERROR
[INFO]
------------------------------------------------------------------------
[INFO] Error while commiting the transaction
ORA-12899: value too large for column
"SONAR"."RULE_FAILURES"."MESSAGE" (actual: 780, maximum: 500)
[INFO]
------------------------------------------------------------------------