java - SPRING MVC database error jdbc -

java - SPRING MVC database error jdbc -

thanks time

i getting error project having 2 modules add together driver , add together truck executing sql query both when execute query adddriver module database exception throwing stating

org.springframework.dao.dataintegrityviolationexception: preparedstatementcallback; sql [insert truck(tregnno,vendorname,purchasedate,price,repairdate,invoiceno,repaircost) values(?,?,?,?,?,?,?)]; column 'tregnno' cannot null; nested exception com.mysql.jdbc.exceptions.mysqlintegrityconstraintviolationexception: column 'tregnno' cannot null org.springframework.jdbc.support.sqlstatesqlexceptiontranslator.dotranslate(sqlstatesqlexceptiontranslator.java:101)

driver insert sql statement public void insertdata(driver driver) { string sql = "insert driver" + "(dlno,dname,age,experience) values (?,?,?,?)"; jdbctemplate jdbctemplate = new jdbctemplate(datasource);

jdbctemplate.update(sql, new object[] {driver.getlicensenumber(),driver.getdrivername(),driver.getage(),driver.getexperience()}); } truck insert code public void insertdata(truck truck) { string sql = "insert truck" + "(tregnno,vendorname,purchasedate,price,repairdate,invoiceno,repaircost) values(?,?,?,?,?,?,?)"; jdbctemplate jdbctemplate = new jdbctemplate(datasource); jdbctemplate.update(sql , new object[] {truck.gettregno(),truck.getvendorname(),truck.getpurchasedate(),truck.getprice(),truck.getrepairdate(),truck.getinvoiceno(),truck.getrepaircost()}); }

column tregnno can not null. have assign (unique) value row.

java mysql sql spring jdbc