null value to database table from JForm

[Gokcen Guner]

Im working on a project similar to custom database app tutorial of NetBeans (http://www.netbeans.org/kb/docs/java/gui-db-custom.html)

When I try to add new record to detail table i get he error:

  javax.persistence.RollbackException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException 
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'offense' cannot be null 
Error Code: 1048 
Call: INSERT INTO deneme.committed_crime (cdate, location, criminal_id, offense) VALUES (?, ?, ?, ?) 
        bind => [null, null, 3, null] 
Query: InsertObjectQuery(justiceforall.CommittedCrime[commitId=null]) 
[TopLink Warning]: 2009.05.23 09:25:10.296--UnitOfWork(4545192)--Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException 
        at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:120) 
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'offense' cannot be null 
Error Code: 1048 
Call: INSERT INTO deneme.committed_crime (cdate, location, criminal_id, offense) VALUES (?, ?, ?, ?) 
        bind => [null, null, 3, null] 
Query: InsertObjectQuery(justiceforall.CommittedCrime[commitId=null])  

There are a lot of errors too, but that may be enough. If not i can post it too.
I've just followed the instructions in the tutorial to trace the problem and they are all the same. I couldn't find the problem.

[Rob Spoor]

Gokcen Guner wrote:Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'offense' cannot be null

Apparently, in your database table, you've specified that column "offense" cannot have any null values.

Moving to JDBC.

[Gokcen Guner]

thanks for reply. Eventually Ive found why the data didnt go to database from JForm.

[himanshu rai]

@Gokcen Guner
Im having the same problem, how did solve it?