Bug #61484 jdbc Exceptions
Submitted: 10 Jun 2011 17:01 Modified: 26 Apr 2013 7:08
Reporter: Goutham Bvsrk Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Alexander Soklakov CPU Architecture:Any

[10 Jun 2011 17:01] Goutham Bvsrk 
Description:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'LoginId' cannot be null
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
	at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
	at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
	at com.gouth.corejava.ServletToDB.doGet(ServletToDB.java:66)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)

How to repeat:
1
[10 Jun 2011 17:34] Valeriy Kravchuk 
Please, send the output of SHOW CREATE TABLE for the table you worked with when you had got this exception.

What exact version of Connector/J do you use?
[13 Jun 2011 6:16] Tonci Grgin 
Goutham, unfortunately, this is *not* a bug report... Please check on test cases attached to other reports and write a complete one exhibiting your problem.
Essentially, you are inserting NULL value in not-null column which should be rather easy to fix in your code/schema.
[10 Jul 2011 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[26 Apr 2013 7:08] Alexander Soklakov 
Goutham,

There is no feedback since Jun 2011 and no info to analyze the problem, so I close this report as "Can't repeat". Feel free to reopen it if you can provide complete report.