Disabling contextual LOB creation as createClob method threw error

Question

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

Update to this for using Hibernate 4 3 x   5 0 x - you could just set this property to true    lt prop key  hibernate jdbc lob non contextual creation  gt true lt  prop gt    to get rid of that error message  Same effect but without the  threw exception  detail  See LobCreatorBuilder source for details

User · Answer

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

User · Answer

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   lt property name  hibernate temp use jdbc metadata defaults  gt false lt  property gt

User · Answer

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

User · Answer

Just add below line in application properties  spring jpa properties hibernate temp use jdbc metadata defaults  false

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

Remove  Temporal annotations if you use it with java sql   classes

User · Answer

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

User · Answer

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

User · Answer

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    lt hibernate version gt 5 4 2 Final lt  hibernate version gt    and error was gone  Reason for error is already explained in posts above

User · Answer

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

[java] Disabling contextual LOB creation as createClob() method threw error

Examples related to java

Examples related to hibernate

Examples related to oracle10g

Examples related to clob