I’m unable to get Cassandra write at the same time as Postgres read ride. The connection seems to start but ultimately leads to SQLFeatureNotSupportedException. Here are the diffs going from a working sample project with H2 to Postgres. Port 5431 is intentional.
Removing username and pass from persistence.xml helped. But I’m still unable to persist new entries into the DB.
22:46:13.825 [error] org.hibernate.engine.jdbc.spi.SqlExceptionHelper [] - ERROR: column "sequence_offset" is of type bigint but expression is of type bytea
Hint: You will need to rewrite or cast the expression.
Position: 50
Location: File: parse_target.c, Routine: transformAssignedExpr, Line: 591
Server SQLState: 42804
...
Caused by: org.postgresql.util.PSQLException: ERROR: column "sequence_offset" is of type bigint but expression is of type bytea
Hint: You will need to rewrite or cast the expression.
Position: 50
Location: File: parse_target.c, Routine: transformAssignedExpr, Line: 591
Server SQLState: 42804