jQuery in Action, 2nd edition*
The moose likes Object Relational Mapping and the fly likes jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'balance' cannot be null Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column Watch "jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column New topic
Author

jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'balance' cannot be null

Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 573
Hi,

I am trying to persist an entity to a databse

in my database balance can not be null


in my code i have the following



In my testEntity i am setting balance, but I have the feeling its flling over before it runs the test. That i need to add something in the Column
Annotation
Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 573
Thanks for any help
James Sutherland
Ranch Hand

Joined: Oct 01, 2007
Posts: 553
Are you sure you are setting the balance? Include your code and the log on finest.

TopLink : EclipseLink : Book:Java Persistence : Blog:Java Persistence Performance
Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 573
Hi James thanks for replying in fact it was a deeper issue which I am now trying to fix.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'balance' cannot be null
 
Similar Threads
Program like ATM where person enters amount in dollars and cents but program uses int for monies
Checkbox editor for JTable column
Concurrency Issue on My mac?
Having trouble understanding an error code i keep getting. Please help!
Problem in ""Lost Update" problem" program output from Head First Java 2nd ed. (Java 5.0)