title: java.sql.SQLException: Field doesn't have a default value
body: <p>I'm getting the following error when invoking the Spring Data JPA save() method:</p>
  
  <p>-- UPDATED WITH SQL LOGGING --</p>
  
  <pre><code>[DEBUG] [http-nio-8090-exec-4 01:33:59] (SQLStatementLogger.java:logStatement:111) select role0_.RLE_ID as RLE1_0_, role0_.RLE_ROLE as RLE2_0_, role0_.TENANT_ENT_ID as TENANT3_0_ from roles role0_
  Hibernate: select role0_.RLE_ID as RLE1_0_, role0_.RLE_ROLE as RLE2_0_, role0_.TENANT_ENT_ID as TENANT3_0_ from roles role0_
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [RLE1_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [Enterprise Manager] as column [RLE2_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [TENANT3_0_]
  [DEBUG] [http-nio-8090-exec-4 01:33:59] (SQLStatementLogger.java:logStatement:111) select permission0_.RLE_ID as RLE1_0_1_, permission0_.PRM_ID as PRM2_1_, permission1_.PRM_ID as PRM1_7_0_, permission1_.PRM_PERMISSION as PRM2_7_0_, permission1_.TENANT_ENT_ID as TENANT3_7_0_ from ROLE_PERMISSIONS permission0_ inner join permissions permission1_ on permission0_.PRM_ID=permission1_.PRM_ID where permission0_.RLE_ID=?
  Hibernate: select permission0_.RLE_ID as RLE1_0_1_, permission0_.PRM_ID as PRM2_1_, permission1_.PRM_ID as PRM1_7_0_, permission1_.PRM_PERMISSION as PRM2_7_0_, permission1_.TENANT_ENT_ID as TENANT3_7_0_ from ROLE_PERMISSIONS permission0_ inner join permissions permission1_ on permission0_.PRM_ID=permission1_.PRM_ID where permission0_.RLE_ID=?
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [1] as [INTEGER] - 1
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [PRM1_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [ACCESS_ENTERPRISE_DASHBOARD] as column [PRM2_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [TENANT3_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [RLE1_0_1_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [PRM2_1_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [2] as column [PRM1_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [ACCESS_WORKSHOP_DASHBOARD] as column [PRM2_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [TENANT3_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [RLE1_0_1_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [2] as column [PRM2_1_]
  [DEBUG] [http-nio-8090-exec-4 01:33:59] (SQLStatementLogger.java:logStatement:111) select contact0_.CON_ID as CON1_1_, contact0_.CON_FIRST_NAME as CON2_1_, contact0_.CON_LAST_NAME as CON3_1_, contact0_.CON_MIDDLE_NAME as CON4_1_, contact0_.CON_PASSWORD as CON5_1_, contact0_.TENANT_ENT_ID as TENANT6_1_, contact0_.CON_USERNAME as CON7_1_ from contacts contact0_ where contact0_.CON_USERNAME=? limit ?
  Hibernate: select contact0_.CON_ID as CON1_1_, contact0_.CON_FIRST_NAME as CON2_1_, contact0_.CON_LAST_NAME as CON3_1_, contact0_.CON_MIDDLE_NAME as CON4_1_, contact0_.CON_PASSWORD as CON5_1_, contact0_.TENANT_ENT_ID as TENANT6_1_, contact0_.CON_USERNAME as CON7_1_ from contacts contact0_ where contact0_.CON_USERNAME=? limit ?
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [1] as [VARCHAR] - peter
  [DEBUG] [http-nio-8090-exec-4 01:33:59] (SQLStatementLogger.java:logStatement:111) select role0_.RLE_ID as RLE1_0_, role0_.RLE_ROLE as RLE2_0_, role0_.TENANT_ENT_ID as TENANT3_0_ from roles role0_ where role0_.RLE_ID=? limit ?
  Hibernate: select role0_.RLE_ID as RLE1_0_, role0_.RLE_ROLE as RLE2_0_, role0_.TENANT_ENT_ID as TENANT3_0_ from roles role0_ where role0_.RLE_ID=? limit ?
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [1] as [INTEGER] - 1
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [RLE1_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [Enterprise Manager] as column [RLE2_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [TENANT3_0_]
  [DEBUG] [http-nio-8090-exec-4 01:33:59] (SQLStatementLogger.java:logStatement:111) select permission0_.RLE_ID as RLE1_0_1_, permission0_.PRM_ID as PRM2_1_, permission1_.PRM_ID as PRM1_7_0_, permission1_.PRM_PERMISSION as PRM2_7_0_, permission1_.TENANT_ENT_ID as TENANT3_7_0_ from ROLE_PERMISSIONS permission0_ inner join permissions permission1_ on permission0_.PRM_ID=permission1_.PRM_ID where permission0_.RLE_ID=?
  Hibernate: select permission0_.RLE_ID as RLE1_0_1_, permission0_.PRM_ID as PRM2_1_, permission1_.PRM_ID as PRM1_7_0_, permission1_.PRM_PERMISSION as PRM2_7_0_, permission1_.TENANT_ENT_ID as TENANT3_7_0_ from ROLE_PERMISSIONS permission0_ inner join permissions permission1_ on permission0_.PRM_ID=permission1_.PRM_ID where permission0_.RLE_ID=?
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [1] as [INTEGER] - 1
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [PRM1_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [ACCESS_ENTERPRISE_DASHBOARD] as column [PRM2_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [TENANT3_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [RLE1_0_1_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [PRM2_1_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [2] as column [PRM1_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [ACCESS_WORKSHOP_DASHBOARD] as column [PRM2_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [TENANT3_7_0_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [1] as column [RLE1_0_1_]
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicExtractor.java:extract:70) found [2] as column [PRM2_1_]
  [DEBUG] [http-nio-8090-exec-4 01:33:59] (SQLStatementLogger.java:logStatement:111) insert into contacts (CON_FIRST_NAME, CON_LAST_NAME, CON_MIDDLE_NAME, CON_PASSWORD, TENANT_ENT_ID, CON_USERNAME) values (?, ?, ?, ?, ?, ?)
  Hibernate: insert into contacts (CON_FIRST_NAME, CON_LAST_NAME, CON_MIDDLE_NAME, CON_PASSWORD, TENANT_ENT_ID, CON_USERNAME) values (?, ?, ?, ?, ?, ?)
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [1] as [VARCHAR] - Peter
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [2] as [VARCHAR] - Parker
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [3] as [VARCHAR] - 
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [4] as [VARCHAR] - $2a$10$leropYevLndPWXSgdCU.huXoWXeXA5VPnRqABBLRcYjXTVH.IH.Q.
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [5] as [INTEGER] - 1
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [6] as [VARCHAR] - peter
  [DEBUG] [http-nio-8090-exec-4 01:33:59] (SQLStatementLogger.java:logStatement:111) insert into USER_ROLES (USER_CON_ID, RLE_ID) values (?, ?)
  Hibernate: insert into USER_ROLES (USER_CON_ID, RLE_ID) values (?, ?)
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [1] as [INTEGER] - 10
  [TRACE] [http-nio-8090-exec-4 01:33:59] (BasicBinder.java:bind:82) binding parameter [2] as [INTEGER] - 1
  [ERROR] [http-nio-8090-exec-4 01:33:59] (JDBCExceptionReporter.java:logExceptions:234) Field 'TENANT_ENT_ID' doesn't have a default value
  Apr 28, 2015 1:33:59 PM org.apache.catalina.core.StandardWrapperValve invoke
  SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/hub] threw exception [Request processing failed; nested exception is org.springframework.orm.jpa.JpaSystemException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update] with root cause
  java.sql.SQLException: Field 'TENANT_ENT_ID' doesn't have a default value
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
      at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1976)
      at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:188)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
      at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
      at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:76)
      at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
      at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
      at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)
      at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:521)
      at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodIntercceptor.invoke(CrudMethodMetadataPostProcessor.java:122)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
      at com.sun.proxy.$Proxy53.save(Unknown Source)
      at com.motodoc.hub.service.UserServiceImpl.addUser(UserServiceImpl.java:74)
      at com.motodoc.hub.controller.administration.users.UserListController.addSave(UserListController.java:204)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:483)
      at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
      at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
      at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
      at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
      at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
      at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
      at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
      at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
      at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
      at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
      at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
      at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
      at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:57)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
      at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
      at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)
      at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516)
      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1086)
      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:659)
      at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:223)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1558)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1515)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      at java.lang.Thread.run(Thread.java:745)
  </code></pre>
  
  <p>Here is my service method which invokes the save() method:</p>
  
  <pre><code>@Override
  public Contact addUser(UserForm userForm) {
  
      String encodedPassword;
      Contact user = userForm.getUser();
  
      //encode the password
      encodedPassword = encoder.encode(userForm.getPassword());
  
      //set the encoded password as the password
      user.setPassword(encodedPassword);
  
      Set&lt;Role&gt; securityRoles = new HashSet&lt;Role&gt;();
  
      //get Role
      securityRoles.add(roleDao.findById(userForm.getRoleId()));
  
      user.setRoles(securityRoles);
  
      user.setTenantId(securityAccessor.getCurrentLoggedUser().getTenantId());
  
      //now save
      return contactDao.save(user);
  }
  </code></pre>
  
  <p>I have done the checks to make sure that the 'user' object properties (i.e. firstName, lastName, tenantId) are populated and can confirm that they are.</p>
  
  <p>Any help will be much appreciated.</p>
  
  <p>Here are the remaining relevant codes....</p>
  
  <p>Contact Class:</p>
  
  <pre><code>@Entity
  @Table(name = "contacts")
  public class Contact implements UserDetails {
  
      @Id
      @GeneratedValue(strategy = GenerationType.AUTO)
      @Column(name="CON_ID")
      private int id;
  
      @NotEmpty
      @Column(name="CON_USERNAME")
      private String username;
  
      //Custom validation is carried out in controller class
      @Column(name="CON_PASSWORD")
      private String password;
  
      @NotEmpty
      @Column(name="CON_FIRST_NAME")
      private String firstName;
  
      @Column(name="CON_MIDDLE_NAME")
      private String middleName;
  
      @NotEmpty
      @Column(name="CON_LAST_NAME")
      private String lastName;
  
      @OneToMany(fetch = FetchType.EAGER)
      @JoinTable(name = "USER_ROLES", joinColumns = { 
              @JoinColumn(name = "USER_CON_ID") }, inverseJoinColumns = { 
              @JoinColumn(name = "RLE_ID") })
      private Set&lt;Role&gt; roles;
  
  
      @Column(name = "TENANT_ENT_ID")
      private int tenantId;
  
  //  @Column(name="ENT_ID")
  //  private int enterpriseId;
  
      @Transient
      private final String PERMISSION_PREFIX = "ROLE_PERM_";
  
      public int getId() {
          return id;
      }
  
      public void setId(int id) {
          this.id = id;
      }
  
      public String getUsername() {
          return username;
      }
  
      public void setUsername(String username) {
          this.username = username;
      }
  
      public String getPassword() {
          return password;
      }
  
      public void setPassword(String password) {
          this.password = password;
      }
  
      public String getFirstName() {
          return firstName;
      }
  
      public void setFirstName(String firstName) {
          this.firstName = firstName;
      }
  
      public String getMiddleName() {
          return middleName;
      }
  
      public void setMiddleName(String middleName) {
          this.middleName = middleName;
      }
  
      public String getLastName() {
          return lastName;
      }
  
      public void setLastName(String lastName) {
          this.lastName = lastName;
      }
  
      @Override
      public Collection&lt;? extends GrantedAuthority&gt; getAuthorities() {
          Set&lt;GrantedAuthorityImpl&gt; authorities = new HashSet&lt;GrantedAuthorityImpl&gt;();
          for (Role role : roles) {
              for (Permission permission : role.getPermissions()) {
                  GrantedAuthorityImpl authority = new GrantedAuthorityImpl(PERMISSION_PREFIX + permission.getPermission());
                  authorities.add(authority);
              }
          }
          return authorities;
      }
  
      @Override
      public boolean isAccountNonExpired() {
          // TODO Auto-generated method stub
          return false;
      }
  
      @Override
      public boolean isAccountNonLocked() {
          // TODO Auto-generated method stub
          return false;
      }
  
      @Override
      public boolean isCredentialsNonExpired() {
          // TODO Auto-generated method stub
          return false;
      }
  
      @Override
      public boolean isEnabled() {
          // TODO Auto-generated method stub
          return true;
      }
  
  
      public String getPERMISSION_PREFIX() {
          return PERMISSION_PREFIX;
      }
  
      public Set&lt;Role&gt; getRoles() {
          return roles;
      }
  
      public void setRoles(Set&lt;Role&gt; roles) {
          this.roles = roles;
      }   
  
      //custom method
      public boolean hasPermission(String permission) {
  
          for (Role role : this.roles) {
              for (Permission securityPermission : role.getPermissions()) {
                  if (securityPermission.getPermission().equals(permission))
                      return true;
              }
          }
  
          return false;
      }
  
      //custom method for testing - to rmeove
      public boolean hasRole(String rle) {
  
          for (Role role : this.roles) {
              if (role.getRole().equals(rle))
                  return true;
          }
  
          return false;
      }
  
      public int getTenantId() {
          return tenantId;
      }
  
      public void setTenantId(int tenantId) {
          this.tenantId = tenantId;
      }
  }
  </code></pre>
  
  <p>The DAO class:</p>
  
  <pre><code>public interface IContactDao extends JpaRepository&lt;Contact, Long&gt;, QueryDslPredicateExecutor&lt;Contact&gt; {
  
      public Contact findOne(Predicate predicate);
  
      public Contact findById(int id);
  
      public Page&lt;Contact&gt; findAll(Predicate predicate, Pageable pageable);
  
      public Page&lt;Contact&gt; findAll(Pageable pageable);
  
      @SuppressWarnings("unchecked")
      public Contact save(Contact contact);   
  }
  </code></pre>
  
  <p>The persistence.xml file:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0"&gt;
      &lt;persistence-unit name="hibernatePersistenceUnit" transaction-type="RESOURCE_LOCAL"&gt;
          &lt;properties&gt;
              &lt;property name="hibernate.hbm2ddl.auto" value="update" /&gt;
              &lt;property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect" /&gt;
          &lt;/properties&gt;
          &lt;!-- &lt;mapping-file&gt;META-INF/orm.xml&lt;/mapping-file&gt;  --&gt;
      &lt;/persistence-unit&gt;
  &lt;/persistence&gt;
  </code></pre>
  
  <p>Image of Mysql 'contacts' table to show the TENANT_ENT_ID column:</p>
  
  <p><img src="https://i.stack.imgur.com/JGKuz.png" alt="enter image description here"></p>