ClassCastException when storing UUIDS as VARCHAR in postgres

[lemona...@gmail.com]

I'm upgrading from Play 2.4.8 to 2.5.12 and upgrading the sbt-play-ebean plugin from 2.0.0 to 3.0.0 (ebean 6.18.1). Primary keys are stored as UUID in my java models, and VARCHAR in postgres.

Anytime I try to find or save an object I get the following exception ClassCastException:

java.lang.ClassCastException: java.lang.String cannot be cast to java.util.UUID

        at com.avaje.ebeaninternal.server.type.ScalarTypeUUIDNative.read(ScalarTypeUUIDNative.java:42)

        at com.avaje.ebeaninternal.server.type.ScalarTypeUUIDNative.read(ScalarTypeUUIDNative.java:17)

        at com.avaje.ebeaninternal.server.deploy.BeanProperty.read(BeanProperty.java:581)

        at com.avaje.ebeaninternal.server.deploy.id.IdBinderSimple.readSet(IdBinderSimple.java:169)

        at com.avaje.ebeaninternal.server.query.SqlTreeNodeBean.load(SqlTreeNodeBean.java:237)

        at com.avaje.ebeaninternal.server.query.CQuery.readNextBean(CQuery.java:431)

        at com.avaje.ebeaninternal.server.query.CQuery.hasNext(CQuery.java:512)

        at com.avaje.ebeaninternal.server.query.CQuery.readCollection(CQuery.java:543)

        at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:302)

        at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:94)

I understand that since 6.10.1 ebean has supported native UUIDs in postgres as well as VARCHAR, but for some odd reason it's trying to use ScalarTypeUUIDNative instead of ScalarTypeUUIDVarchar.

I can't be the first to come across this but I can't find this addressed anywhere online.

[Tim Dörnemann]

It's been a long time since the issue was posted, but has anyone run into the same problem and found a solution?

I'm facing the same issue when trying to upgrade from play 2.4 to 2.6. I'm also using Postgres, UUID in the Java model and varchar in the DB schema.

Thanks, Tim

[Rob Bygrave]

> upgrade from play 2.4 to 2.6

The Play version is somewhat irrelevant. What is relevant is the version of Ebean you are upgrading to.  

For current Ebean refer to: 

https://ebean-orm.github.io/apidoc/11/io/ebean/config/ServerConfig.html#setDbUuid-io.ebean.config.PlatformConfig.DbUuid-

ServerConfig.setDbUuid(...) is the configuration which sets the UUID mode to use.

Cheers, Rob.

--

---
You received this message because you are subscribed to the Google Groups "Ebean ORM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ebean+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Tim Dörnemann]

Great, thanks Rob -- problem solved.