jira.codehaus.org

  • Log In Access more options
    • Online Help
    • Keyboard Shortcuts
    • About JIRA
    • JIRA Credits
    • What?s New
  • Dashboards Access more options (Alt+d)
  • Projects Access more options (Alt+p)
  • Issues Access more options (Alt+i)
  • Sonar
  • SONAR-12

Some rule messages are too large for the database

  • Log In
  • Views
    • XML
    • Word
    • Printable

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major 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]
------------------------------------------------------------------------

Activity

  • All
  • Comments
  • Work Log
  • History
  • Activity
There are no comments yet on this issue.

People

  • Assignee:
    Cédric Munger
    Reporter:
    Simon Brandhof
Vote (0)
Watch (0)

Dates

  • Created:
    17/Dec/07 7:33 AM
    Updated:
    19/Dec/07 2:58 AM
    Resolved:
    18/Dec/07 7:46 AM
  • Atlassian JIRA (v5.0.4#731-sha1:3aa7374)
  • Report a problem
  • Powered by a free Atlassian JIRA open source license for Codehaus. Try JIRA - bug tracking software for your team.