CodecNotFoundException: Codec not found for requested operation: [date <-> java.util.Date]

Question

I am using below Datastax versions with Java 8:

<dependency>
      <groupId>com.datastax.cassandra</groupId>
      <artifactId>cassandra-driver-core</artifactId>
      <version>3.7.2</version>
    </dependency>

    <dependency>
      <groupId>com.datastax.cassandra</groupId>
      <artifactId>cassandra-driver-mapping</artifactId>
      <version>3.7.2</version> 
    </dependency>

My table has a Date column as below:

cass_table (                                                    
    data_source_id int,                                                                                                                                                                   
    company_id text,                                                              
    create_date date)

When I trying to save the data into C* table as below:

final IndustryCompany four = new IndustryCompany(1,1236, ProdUtils.today());
 industryCompanyRepository.save(one);


public static Date today() {
        return java.sql.Date.valueOf(new SimpleDateFormat(ProducerConstants.DATABASE_DATE_FORMAT).format(Calendar.getInstance().getTime()));
    }

Getting error:

Caused by: com.datastax.driver.core.exceptions.CodecNotFoundException: Codec not found for requested operation: [date <-> java.sql.Date]
    at com.datastax.driver.core.exceptions.CodecNotFoundException.copy(CodecNotFoundException.java:57) ~[cassandra-driver-core-3.7.2.jar:na]

What am I doing wrong here?

Alex Ott · Accepted Answer · 2019-07-19 12:37:20Z

1

You need to pass variable with com.datastax.driver.core.LocalDate type instead. See the documentation for mapping between Java type and CQL types. You can use LocalDate from JDK 8, or from Joda time package if you'll use so-called optional codec.

Another possibility is to write date<->java.sql.Date and register it for direct mapping.

answered Jul 19, 2019 at 12:37

Alex Ott

88.1k10 gold badges110 silver badges157 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

BdEngineer Over a year ago

thank you ... When I use version 4.0.0 instead of current version 3.7.2 to run github.com/lankydan/datastax-java-driver ... there are lot of errors... is there any samples/examples to use version 4.0.0 ???

Alex Ott Over a year ago

4.x is major rewrite of the Java driver, and it's not binary compatible. There is a separate part of manual regarding porting: docs.datastax.com/en/developer/java-driver/4.1/upgrade_guide And examples are in repository: github.com/datastax/java-driver/tree/4.x/examples

BdEngineer Over a year ago

thank you , what do you mean by "not binary compatible" ??

Alex Ott Over a year ago

That you can’t simply take your compiled code and use with new driver version, as there are API changes

BdEngineer · Accepted Answer · 2019-07-19 14:24:15Z

-1

Thanks a lot @Alex Ott As you suggested I did below

added another jar

 <dependency>
        <groupId>com.datastax.cassandra</groupId>
        <artifactId>cassandra-driver-extras</artifactId>
        <version>3.7.2</version>
    </dependency>

Before calling save() method i called this

public void registerCodecs() {
    CodecRegistry registry = this.session.getCluster().getConfiguration().getCodecRegistry();
    registry.register(LocalDateCodec.instance);
}

answered Jul 19, 2019 at 14:24

BdEngineer

3,2697 gold badges56 silver badges100 bronze badges

1 Comment

Ashraful Islam Over a year ago

you can look into my answer stackoverflow.com/a/45815737/2320144

Collectives™ on Stack Overflow

CodecNotFoundException: Codec not found for requested operation: [date <-> java.util.Date]

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related