· 6 years ago · Jul 10, 2019, 10:40 AM
1CREATE table IF NOT EXISTS myks.users (
2 user_name text,
3 email text,
4 created_at timestamp,
5 updated_at timestamp,
6 PRIMARY KEY (user_name)
7);
8
9@Table(value = "users")
10public @Data class Users{
11 @PrimaryKey
12 @Column("user_name")
13 @CassandraType(type = DataType.Name.TEXT)
14 private String user_name;
15
16 @Column("email")
17 @CassandraType(type = DataType.Name.TEXT)
18 private String email;
19
20 @Column("created_at")
21 @CassandraType(type = DataType.Name.TIMESTAMP)
22 private Timestamp created_at;
23
24 @Column("updated_at")
25 @CassandraType(type = DataType.Name.TIMESTAMP)
26 private Timestamp updated_at;
27}
28
29@Repository
30public interface UsersRepository extends CrudRepository<Users, String> {
31}
32
33Users users = new Users();
34LocalDateTime ldt_created = LocalDateTime.now();
35LocalDateTime ldt_updated = ldt_created.plus(1000, ChronoUnit.MILLIS);
36Timestamp ts_created = Timestamp.valueOf(ldt_created);
37Timestamp ts_updated = Timestamp.valueOf(ldt_updated);
38users.setUser_name(krishna");
39users.setEmail("krishna@gmail.com");
40users.setCreated_at(ts_created);
41users.setUpdated_at(ts_updated);
42usersRepository.save(users);
43
44No converter found capable of converting from type [java.util.Date] to type [java.sql.Timestamp]