I am trying persist a new 'UserTopics' object and map the newly UserTopic in the 'Topic' table corresponded to multiple userId's.
I've no idea what I am doing wrong here. Below is the code I have and the exception.
My UserTopics entity:
@Entity
@Table(name="USERS_TOPICS")
public class UserTopics {
@Id
@GeneratedValue(strategy= GenerationType.IDENTITY)
@Column(name="TOPICUSER_ID")
private Integer id;
@Column(name="USER_ID")
private Integer userId;
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "TOPICS_TOPICS_ID")
private Topics topics;
// Getters and setters
and Topics entity:
@Entity
@Table(name="TOPICS")
public class Topics {
@Id
@GeneratedValue(strategy= GenerationType.IDENTITY)
@Column(name="TOPICS_ID")
private Integer id;
@Column(name="TOPICNAME")
private String topicName;
@OneToMany(mappedBy = "topics", cascade= {CascadeType.ALL,CascadeType.PERSIST})
private Set<UserTopics> userTopics;
//Getter and setters
In my service Class, I am trying to save the UserTopic like so:
@Service("userTopicsService")
@Transactional
public class UserTopicsServiceImpl implements UserTopicsService {
@Autowired
TopicsDao topicsDao;
@Override
public void createTopicc(int UserIdOne, int UserIdTwo) {
Set<UserTopics> userTopics = new HashSet<>();
Topics topic = new Topics();
topic.setTopicName(String.valueOf(UserIdOne+UserIdTwo));
UserTopics userTopicOne = new UserTopics();
userTopicOne.setUserId(UserIdOne);
userTopics.add(userTopicOne);
UserTopics userTopicTwo = new UserTopics();
userTopicTwo.setUserId(UserIdTwo);
userTopics.add(userTopicTwo);
topic.setUserTopics(userTopics);
topicsDao.saveTopic(topic);
}
//Other methods...
The exception below
18:58:54.434 [http-apr-8080-exec-9] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1048, SQLState: 23000
18:58:54.434 [http-apr-8080-exec-9] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Column 'TOPICS_TOPICS_ID' cannot be null
18:58:54.442 [http-apr-8080-exec-9] DEBUG org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Warning
java.sql.SQLWarning: Column 'TOPICS_TOPICS_ID' cannot be null
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:779)
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:707)
So the solution is:
Added cascade type to Topics object in the UserTopics entity as such:
@ManyToOne(fetch = FetchType.EAGER, cascade = CascadeType.ALL)
@JoinColumn(name = "TOPICS_TOPICS_ID")
private Topics topics;
while the code in my Service class which saves the new Topic and its children UserTopics is below.
Topics topic = new Topics();
topic.setTopicName(String.valueOf(UserIdOne+UserIdTwo));
Set<UserTopics> userTopics = new HashSet<>();
UserTopics userTopicOne = new UserTopics();
userTopicOne.setUserId(UserIdOne);
userTopicOne.setTopics(topic);
UserTopics userTopicTwo = new UserTopics();
userTopicTwo.setUserId(UserIdTwo);
userTopicOne.setTopics(topic);
userTopics.add(userTopicOne);
userTopics.add(userTopicTwo);
List<UserTopics> userTopicsList = new ArrayList<>();
userTopics.add(userTopicOne);
userTopics.add(userTopicTwo);
for(UserTopics next : userTopics) {
userTopicsDao.save(next);
}