You are currently reviewing an older revision of this page.

DRAFT KB-XXXX Cannot Insert NULL Into DB Table Error

Symptoms

Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("APPIANDEV"."TEST_DATA"."DATA")

Cause

This is an error thrown by the Oracle database when you try to insert a null value into a column that does not allow nulls. 

Action

The resolution is to either use code to ensure a null value does not attempt to write to the database or to update your table definition to allow null values for the column.