Encountering PSQLException when trying to get entry from Postgres database

239 Views Asked by At

I have an entity class below. As an important that, user_config column keeps JSON based user configuration so that I had to annotate the variable with @Lob.

  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  private Long id;

  @Column(name = "user_name")
  @NotNull
  private String userName;

  @Lob
  @Column(name = "user_config")
  @NotNull
  private String userConfig;

I am trying to get a bunch of entries over the JPA repository from the database below:

@Repository
public interface UserConfigRepository extends CrudRepository<UserConfig, Long> {
  List<UserConfig> findByUserName(String userName);
}

Finally, I have an exception below:

Caused by: org.postgresql.util.PSQLException: Bad value for type long : "some user info"
    at org.postgresql.jdbc.PgResultSet.toLong(PgResultSet.java:2894)
    at org.postgresql.jdbc.PgResultSet.getLong(PgResultSet.java:2101)
    at org.postgresql.jdbc.PgResultSet.getClob(PgResultSet.java:447)
    at org.postgresql.jdbc.PgResultSet.getClob(PgResultSet.java:434)
    at com.zaxxer.hikari.pool.HikariProxyResultSet.getClob(HikariProxyResultSet.java)
    at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:44)
    at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:243)
    at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:329)
    at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:3087)
    at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1877)
    at org.hibernate.loader.Loader.hydrateEntityState(Loader.java:1805)
    at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1778)
    at org.hibernate.loader.Loader.getRow(Loader.java:1626)
    at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:743)
    at org.hibernate.loader.Loader.getRowsFromResultSet(Loader.java:1042)
    at org.hibernate.loader.Loader.processResultSet(Loader.java:993)
    at org.hibernate.loader.Loader.doQuery(Loader.java:962)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352)
    at org.hibernate.loader.Loader.doList(Loader.java:2857)
    ... 102 more 

Could you please assist me to fix this error?

PS:SpringBoot Version:2.3.2.RELEASE

0

There are 0 best solutions below