Disabling contextual LOB creation as createClob() method threw error

Java Problem Overview

I am using Hibernate 3.5.6 with Oracle 10g. I am seeing the below exception during initialization but the application itself is working fine. What is the cause for this exception? and how it can be corrected?

Exception
Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException

Info
Oracle version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 JDBC driver: Oracle JDBC driver, version: 11.1.0.7.0

Java Solutions

Solution 1 - Java

Disable this warning by adding property below.

For Spring application:

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

Normal JPA:

hibernate.temp.use_jdbc_metadata_defaults=false

Solution 2 - Java

As you noticed, this exception isn't a real problem. It happens during the boot, when Hibernate tries to retrieve some meta information from the database. If this annoys you, you can disable it:

hibernate.temp.use_jdbc_metadata_defaults false

Solution 3 - Java

Looking at the comments in the source:

> Basically here we are simply checking > whether we can call the > java.sql.Connection methods for LOB > creation added in JDBC 4. We not only > check whether the java.sql.Connection > declares these methods, but also > whether the actual java.sql.Connection > instance implements them (i.e. can be > called without simply throwing an > exception).

So, it's trying to determine if it can use some new JDBC 4 methods. I guess your driver may not support the new LOB creation method.

Solution 4 - Java

In order to hide the exception:

For Hibernate 5.2 (and Spring Boot 2.0), you can either use the use_jdbc_metadata_defaults property that the others pointed out:

# Meant to hide HHH000424: Disabling contextual LOB creation as createClob() method threw error 
spring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults: false

Or, if you want to not have any side effects from the above setting (there's a comment warning us about some Oracle side effects, I don't know if it's valid or not), you can just disable the logging of the exception like this:

logging:
   level: 
      # Hides HHH000424: Disabling contextual LOB creation as createClob() method threw error 
      org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl: WARN

Solution 5 - Java

To get rid of the exception

INFO - HHH000424: Disabling contextual LOB creation as createClob() method threw error :java.lang.reflect.InvocationTargetException

In hibernate.cfg.xml file Add below property

<property name="hibernate.temp.use_jdbc_metadata_defaults">false</property>

Solution 6 - Java

Update to this for using Hibernate 4.3.x / 5.0.x - you could just set this property to true:

<prop key="hibernate.jdbc.lob.non_contextual_creation">true</prop>

to get rid of that error message. Same effect but without the "threw exception" detail. See LobCreatorBuilder source for details.

Solution 7 - Java

Just add below line in application.properties

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

Solution 8 - Java

As mentioned in other comments using

hibernate.temp.use_jdbc_metadata_defaults = false

...will fix the annoying message, but can lead to many other surprising problems. Better solution is just to disable contextual LOB creation with this:

hibernate.jdbc.lob.non_contextual_creation = true

This will cause Hibernate (in my case, its 5.3.10.Final) to skip probing the JDBC driver and just output following message:

HHH000421: Disabling contextual LOB creation as hibernate.jdbc.lob.non_contextual_creation is true

So far it looks like this setting doesn't cause any problems.

Solution 9 - Java

Updating JDBC driver to the lastest version removed the nasty error message.

You can download it from here:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Free registration is required though.

Solution 10 - Java

If you set:

hibernate.temp.use_jdbc_metadata_defaults: false

it can cause you troubles with PostgreSQL when your table name contains reserved word like user. After insert it will try to find id sequence with:

select currval('"user"_id_seq');

which will obviously fail. This at least with Hibernate 5.2.13 and Spring Boot 2.0.0.RC1. Haven't found other way to prevent this message so now just ignoring it.

Solution 11 - Java

When working with Spring boot 2.1.x this warning message appears when starting up the application.

As indicated here, maybe this problem didn't show up in earlier versions because the related property was set to true by default and now it is false:

https://github.com/spring-projects/spring-boot/issues/12007

In consequence, solving this is as simple as adding the following property to the spring application.property file.

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

Solution 12 - Java

The problem occurs because of you didn't choose the appropriate JDBC. Just download and use the JDBC for oracle 10g rather than 11g.

Solution 13 - Java

I am using hibernate 5.3.17 and it works fine by adding given properties

hibernate.default_entity_mode=dynamic-map
hibernate.temp.use_jdbc_metadata_defaults=true
hibernate.jdbc.lob.non_contextual_creation = true

Thanks

Solution 14 - Java

I hit this error when my web app was started in Linux by user logged in with insufficient access rights. This error

> org.hibernate.engine.jdbc.internal.LobCreatorBuilder - HHH000424: > Disabling contextual LOB creation as createClob() method threw error : > java.lang.reflect.InvocationTargetException

usually preceded by other errors / exceptions, especially from your application server i.e for Tomcat: > org.apache.catalina.LifecycleException: Failed to initialize component ...

or > java.lang.UnsatisfiedLinkError: ... cannot open shared object file: No such file or directory

Solution:

Stop your web apps current instance.
Login with super user or those with sufficient access rights i.e root
Restart your web app or call previous function again.

Solution 15 - Java

For anyone who is facing this problem with Spring Boot 2

by default spring boot was using hibernate 5.3.x version, I have added following property in my pom.xml

<hibernate.version>5.4.2.Final</hibernate.version>

and error was gone. Reason for error is already explained in posts above

Solution 16 - Java

Remove @Temporal annotations if you use it with java.sql.* classes.

Solution 17 - Java

Check if you are not on a VPN. I had the same issue but realized the db I was connecting to remote!

Content Type	Original Author	Original Content on Stackoverflow
Question	GiriByaks	View Question on Stackoverflow
Solution 1 - Java	Narayan Yerrabachu	View Answer on Stackoverflow
Solution 2 - Java	jpkrohling	View Answer on Stackoverflow
Solution 3 - Java	Steve K	View Answer on Stackoverflow
Solution 4 - Java	Vlad Dinulescu	View Answer on Stackoverflow
Solution 5 - Java	UdayKiran Pulipati	View Answer on Stackoverflow
Solution 6 - Java	Torsten Krah	View Answer on Stackoverflow
Solution 7 - Java	Rupesh Patil	View Answer on Stackoverflow
Solution 8 - Java	Jacek Prucia	View Answer on Stackoverflow
Solution 9 - Java	Boris Brodski	View Answer on Stackoverflow
Solution 10 - Java	kettunen	View Answer on Stackoverflow
Solution 11 - Java	migueldoctor	View Answer on Stackoverflow
Solution 12 - Java	sami	View Answer on Stackoverflow
Solution 13 - Java	S K	View Answer on Stackoverflow
Solution 14 - Java	peterong	View Answer on Stackoverflow
Solution 15 - Java	Shailesh Chandra	View Answer on Stackoverflow
Solution 16 - Java	Amr El-Demerdash	View Answer on Stackoverflow
Solution 17 - Java	logixplayer	View Answer on Stackoverflow