org.bson.codecs.configuration.CodecConfigurationException: Can't find a codec for class java.sql.Timestamp.

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

Current Spark-Mongodb does not support 3.x mongo drivers. Use long instead of Date until it is upgraded.

tip

Current Spark-Mongodb does not support 3.x mongo drivers. Use long instead of Date until it is upgraded.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • {{java.sql.Timestamp}} is a subclass of {{java.util.Date}}, so I didn't expect any problems. {noformat} org.bson.codecs.configuration.CodecConfigurationException: Can't find a codec for class java.sql.Timestamp. at org.bson.codecs.configuration.CodecCache.getOrThrow(CodecCache.java:46) ~[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.configuration.ProvidersCodecRegistry.get(ProvidersCodecRegistry.java:63) ~[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.configuration.ProvidersCodecRegistry.get(ProvidersCodecRegistry.java:37) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.writeValue(DBObjectCodec.java:210) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.encodeMap(DBObjectCodec.java:220) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.writeValue(DBObjectCodec.java:196) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.encode(DBObjectCodec.java:128) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.encode(DBObjectCodec.java:61) ~[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:63) ~[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:29) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandMessage.writeTheWrites(UpdateCommandMessage.java:80) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandMessage.writeTheWrites(UpdateCommandMessage.java:42) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.BaseWriteCommandMessage.encodeMessageBodyWithMetadata(BaseWriteCommandMessage.java:129) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.RequestMessage.encodeWithMetadata(RequestMessage.java:160) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.WriteCommandProtocol.sendMessage(WriteCommandProtocol.java:212) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.WriteCommandProtocol.execute(WriteCommandProtocol.java:101) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandProtocol.execute(UpdateCommandProtocol.java:64) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandProtocol.execute(UpdateCommandProtocol.java:37) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:159) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:286) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.DefaultServerConnection.updateCommand(DefaultServerConnection.java:140) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.UpdateOperation.executeCommandProtocol(UpdateOperation.java:76) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation$1.call(BaseWriteOperation.java:141) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation$1.call(BaseWriteOperation.java:133) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:230) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:221) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation.execute(BaseWriteOperation.java:133) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation.execute(BaseWriteOperation.java:60) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.Mongo.execute(Mongo.java:782) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.Mongo$2.execute(Mongo.java:765) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.executeWriteOperation(DBCollection.java:333) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.updateImpl(DBCollection.java:495) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.update(DBCollection.java:455) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.update(DBCollection.java:432) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.update(DBCollection.java:522) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.updateMulti(DBCollection.java:552) ~[mongo-java-driver-3.2.0.jar:na] {noformat}
    via by Alexander Azarov,
  • {{java.sql.Timestamp}} is a subclass of {{java.util.Date}}, so I didn't expect any problems. {noformat} org.bson.codecs.configuration.CodecConfigurationException: Can't find a codec for class java.sql.Timestamp. at org.bson.codecs.configuration.CodecCache.getOrThrow(CodecCache.java:46) ~[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.configuration.ProvidersCodecRegistry.get(ProvidersCodecRegistry.java:63) ~[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.configuration.ProvidersCodecRegistry.get(ProvidersCodecRegistry.java:37) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.writeValue(DBObjectCodec.java:210) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.encodeMap(DBObjectCodec.java:220) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.writeValue(DBObjectCodec.java:196) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.encode(DBObjectCodec.java:128) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.encode(DBObjectCodec.java:61) ~[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:63) ~[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:29) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandMessage.writeTheWrites(UpdateCommandMessage.java:80) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandMessage.writeTheWrites(UpdateCommandMessage.java:42) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.BaseWriteCommandMessage.encodeMessageBodyWithMetadata(BaseWriteCommandMessage.java:129) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.RequestMessage.encodeWithMetadata(RequestMessage.java:160) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.WriteCommandProtocol.sendMessage(WriteCommandProtocol.java:212) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.WriteCommandProtocol.execute(WriteCommandProtocol.java:101) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandProtocol.execute(UpdateCommandProtocol.java:64) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandProtocol.execute(UpdateCommandProtocol.java:37) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:159) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:286) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.DefaultServerConnection.updateCommand(DefaultServerConnection.java:140) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.UpdateOperation.executeCommandProtocol(UpdateOperation.java:76) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation$1.call(BaseWriteOperation.java:141) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation$1.call(BaseWriteOperation.java:133) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:230) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:221) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation.execute(BaseWriteOperation.java:133) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation.execute(BaseWriteOperation.java:60) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.Mongo.execute(Mongo.java:782) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.Mongo$2.execute(Mongo.java:765) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.executeWriteOperation(DBCollection.java:333) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.updateImpl(DBCollection.java:495) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.update(DBCollection.java:455) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.update(DBCollection.java:432) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.update(DBCollection.java:522) ~[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.updateMulti(DBCollection.java:552) ~[mongo-java-driver-3.2.0.jar:na] {noformat}
    via by Alexander Azarov,
  • In 2.x we could put a {{Character}} inside a field value. This is no longer the case in 3.0. {code} BasicDBObject object = ... object.put("delimiter", '/'); ... List<DBObject> objectsToInsert = new ArrayList<>(); objectsToInsert.add(object); DBCollection collection = ... collection.insert(objectsToInsert, WriteConcern.ACKNOWLEDGED); {code} Raises the following exception {code} org.bson.codecs.configuration.CodecConfigurationException: Can't find a codec for class java.lang.Character. at org.bson.codecs.configuration.CodecCache.getOrThrow(CodecCache.java:46) at org.bson.codecs.configuration.ProvidersCodecRegistry.get(ProvidersCodecRegistry.java:63) at org.bson.codecs.configuration.ProvidersCodecRegistry.get(ProvidersCodecRegistry.java:37) at com.mongodb.DBObjectCodec.writeValue(DBObjectCodec.java:210) at com.mongodb.DBObjectCodec.encode(DBObjectCodec.java:128) at com.mongodb.DBObjectCodec.encode(DBObjectCodec.java:61) at com.mongodb.CompoundDBObjectCodec.encode(CompoundDBObjectCodec.java:48) at com.mongodb.CompoundDBObjectCodec.encode(CompoundDBObjectCodec.java:27) at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:63) at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:29) at com.mongodb.connection.InsertCommandMessage.writeTheWrites(InsertCommandMessage.java:99) at com.mongodb.connection.InsertCommandMessage.writeTheWrites(InsertCommandMessage.java:43) at com.mongodb.connection.BaseWriteCommandMessage.encodeMessageBody(BaseWriteCommandMessage.java:112) at com.mongodb.connection.BaseWriteCommandMessage.encodeMessageBody(BaseWriteCommandMessage.java:35) at com.mongodb.connection.RequestMessage.encode(RequestMessage.java:132) at com.mongodb.connection.BaseWriteCommandMessage.encode(BaseWriteCommandMessage.java:89) at com.mongodb.connection.WriteCommandProtocol.sendMessage(WriteCommandProtocol.java:170) at com.mongodb.connection.WriteCommandProtocol.execute(WriteCommandProtocol.java:73) at com.mongodb.connection.InsertCommandProtocol.execute(InsertCommandProtocol.java:66) at com.mongodb.connection.InsertCommandProtocol.execute(InsertCommandProtocol.java:37) at com.mongodb.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:155) at com.mongodb.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:219) at com.mongodb.connection.DefaultServerConnection.insertCommand(DefaultServerConnection.java:108) at com.mongodb.operation.InsertOperation.executeCommandProtocol(InsertOperation.java:76) at com.mongodb.operation.BaseWriteOperation$1.call(BaseWriteOperation.java:111) at com.mongodb.operation.BaseWriteOperation$1.call(BaseWriteOperation.java:106) at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:186) at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:177) at com.mongodb.operation.BaseWriteOperation.execute(BaseWriteOperation.java:106) at com.mongodb.operation.BaseWriteOperation.execute(BaseWriteOperation.java:58) at com.mongodb.Mongo.execute(Mongo.java:745) at com.mongodb.Mongo$2.execute(Mongo.java:728) at com.mongodb.DBCollection.executeWriteOperation(DBCollection.java:327) at com.mongodb.DBCollection.insert(DBCollection.java:323) at com.mongodb.DBCollection.insert(DBCollection.java:314) at com.mongodb.DBCollection.insert(DBCollection.java:284) at com.mongodb.DBCollection.insert(DBCollection.java:250) {code}
    via by Emmanuel Bernard,
  • Mongo Document Archives - BlogoSfera
    via by Unknown author,
  • How to save java.sql.date object in mongodb?
    via Stack Overflow by usman
    ,
    • org.bson.codecs.configuration.CodecConfigurationException: Can't find a codec for class java.sql.Timestamp. at org.bson.codecs.configuration.CodecCache.getOrThrow(CodecCache.java:46)[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.configuration.ProvidersCodecRegistry.get(ProvidersCodecRegistry.java:63)[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.configuration.ProvidersCodecRegistry.get(ProvidersCodecRegistry.java:37)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.writeValue(DBObjectCodec.java:210)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.encodeMap(DBObjectCodec.java:220)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.writeValue(DBObjectCodec.java:196)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.encode(DBObjectCodec.java:128)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBObjectCodec.encode(DBObjectCodec.java:61)[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:63)[mongo-java-driver-3.2.0.jar:na] at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:29)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandMessage.writeTheWrites(UpdateCommandMessage.java:80)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandMessage.writeTheWrites(UpdateCommandMessage.java:42)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.BaseWriteCommandMessage.encodeMessageBodyWithMetadata(BaseWriteCommandMessage.java:129)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.RequestMessage.encodeWithMetadata(RequestMessage.java:160)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.WriteCommandProtocol.sendMessage(WriteCommandProtocol.java:212)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.WriteCommandProtocol.execute(WriteCommandProtocol.java:101)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandProtocol.execute(UpdateCommandProtocol.java:64)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.UpdateCommandProtocol.execute(UpdateCommandProtocol.java:37)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:159)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:286)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.connection.DefaultServerConnection.updateCommand(DefaultServerConnection.java:140)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.UpdateOperation.executeCommandProtocol(UpdateOperation.java:76)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation$1.call(BaseWriteOperation.java:141)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation$1.call(BaseWriteOperation.java:133)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:230)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:221)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation.execute(BaseWriteOperation.java:133)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.operation.BaseWriteOperation.execute(BaseWriteOperation.java:60)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.Mongo.execute(Mongo.java:782)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.Mongo$2.execute(Mongo.java:765)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.executeWriteOperation(DBCollection.java:333)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.updateImpl(DBCollection.java:495)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.update(DBCollection.java:455)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.update(DBCollection.java:432)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.update(DBCollection.java:522)[mongo-java-driver-3.2.0.jar:na] at com.mongodb.DBCollection.updateMulti(DBCollection.java:552)[mongo-java-driver-3.2.0.jar:na]

    Users with the same issue

    Dunmer
    Dunmer6 times, last one,
    Alireza Mohamadi
    Alireza Mohamadi2 times, last one,
    rp
    rp1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    31 more bugmates