Postgres Error method org.postgresql.jdbc.PgConnection.createClob() is not implemented

Question

When I invoke createClob method using connection object as shown below:

Clob clob = con.createClob();

Following exception is thrown:

Caused by: java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc.PgConnection.createClob() is not yet implemented.
        at org.postgresql.Driver.notImplemented(Driver.java:659)
        at org.postgresql.jdbc.PgConnection.createClob(PgConnection.java:1246)
        at org.apache.commons.dbcp2.DelegatingConnection.createClob(DelegatingConnection.java:868)
        at org.apache.commons.dbcp2.DelegatingConnection.createClob(DelegatingConnection.java:868)

I`m using database PostgreSQL 9.6.2 with JDK8 and using commons-dbcp2 connection pool, And added following Postgres dependency in pom.xml

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.1.1</version>
</dependency>

In class org.postgresql.jdbc.PgConnection, createClob implementation is as shown below which is throwing the exception:

@Override
public Clob createClob() throws SQLException {
    checkClosed();
    throw org.postgresql.Driver.notImplemented(this.getClass(), "createClob()");
}

What is the solution or workaround to overcome this issue? Or How can we set CLOB data in Postgres queries?

KeyMaker00 · Accepted Answer · 2019-05-18 16:17:02Z

38

TL;DR

Set spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true in your application.yml or,
Set hibernate.jdbc.lob.non_contextual_creation=true in your persistence.xml

It's a known error in JBoss community.

This error appears in former versions and new version with Spring-Boot 2.0.0.RC1 as well and higher.

Solution:

Update your postgressql-driver with a newer backward compatible version.
- Set spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true in your application.yml or,
- Set hibernate.jdbc.lob.non_contextual_creation=true in your persistence.xml
If it's not working see this trick below:

The solution is to add this line in your property file (or something similar if your are not using spring)

spring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults= false

So, your application.yml should looks like:

spring:
    application:
      name: employee-service

    datasource:
      url: jdbc:postgresql://localhost:5432/db_development
      platform: POSTGRESQL
      username: ...
      password: ...

    jpa:
      hibernate:
        ddl-auto: create-drop
        dialect: org.hibernate.dialect.PostgreSQL9Dialect
        show_sql: true
      properties.hibernate.temp.use_jdbc_metadata_defaults: false


server:
  port: 8080

Reference:

https://o7planning.org/en/11661/spring-boot-jpa-and-spring-transaction-tutorial

hibernate with c3p0: createClob() is not yet implemented

Thanks to Binakot for his comment bellow. I have updated the post.

edited May 18, 2019 at 16:17

answered Feb 3, 2018 at 19:45

KeyMaker00

6,5222 gold badges56 silver badges50 bronze badges

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

2 Comments

TheConstructor Over a year ago

If you are using Java-configuration add org.hibernate.cfg.AvailableSettings#NON_CONTEXTUAL_LOB_CREATION as key to your JpaPropertyMap and "true" as the value.

Binakot Over a year ago

You can set non_contextual_creation in application.yml too (not only in persistence.xml): spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true

AgentP · Accepted Answer · 2019-09-07 06:49:44Z

4

put this in to application.properties

spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true

edited Sep 7, 2019 at 6:49

AgentP

7,3694 gold badges39 silver badges59 bronze badges

answered Sep 7, 2019 at 5:29

superup

2,2671 gold badge16 silver badges13 bronze badges

Comments

Craig Ringer · Accepted Answer · 2017-05-11 10:45:13Z

1

PostgreSQL doesn't really have "CLOB". Just use setString(String) or setObject(...) with Types.STRING.

answered May 11, 2017 at 10:45

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Comments

Arthur Kazemi · Accepted Answer · 2019-10-03 03:39:22Z

1

using spring-boot 2.1.9.RELEASE I added the following and it worked

spring:
  jpa:
    properties.hibernate.temp.use_jdbc_metadata_defaults: false
    database-platform: org.hibernate.dialect.PostgreSQL94Dialect

answered Oct 3, 2019 at 3:39

Arthur Kazemi

1,1101 gold badge11 silver badges11 bronze badges

Collectives™ on Stack Overflow

Postgres Error method org.postgresql.jdbc.PgConnection.createClob() is not implemented

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related