I am facing issue with date datatype, following is my table schema
CREATE TABLE user ( name text, id text, date date, division text, PRIMARY KEY ((name, id, date), name)
now my backend is spring boot with following library's
compile group: 'com.datastax.oss', name: 'java-driver-core', version: '4.9.0' compile group: 'com.datastax.cassandra', name: 'cassandra-driver-extras', version: '3.10.2' compile group: 'com.datastax.cassandra', name: 'cassandra-driver-mapping', version: '3.2.0'
i am converting LocalDate to cassandra LocalDate
def cassandraLocalDate = com.datastax.driver.core.LocalDate.fromYearMonthDay(today.year, today.monthValue, today.dayOfMonth)
but still getting this error
com.datastax.oss.driver.api.core.type.codec.CodecNotFoundException: Codec not found for requested operation: [DATE <-> com.datastax.driver.core.LocalDate]
don't know what am i doing wrong here. would highly appriciate any help with this.
Thanks & Regards