Geek Answers Handbook

Is it Hibernate, PostgreSQL or Spring Download: An unexpected error trying to evaluate the level of JDBC support REF_CURSOR: null

When using the PostgreSQL JDBC driver in my project, I get a strange error: "An unexpected error trying to evaluate the level of JDBC support REF_CURSOR: null"

This makes my application freeze at startup for between eighty and three hundred seconds. After starting, everything works fine. I am using the following driver version:

(Gradle Dependency Style) 'Org.postgresql: PostgreSQL: 9.3-1102-jdbc41

My application is a Spring boot application, and freezes when this application starts.

I saw an error after turning on the Hibernate log. The full magazine is in the following paste.

http://pastebin.com/CAjSyQw9

After it gets to the last line of the magazine in this paste, the application freezes from eighty to three hundred seconds, usually an average of about 100 seconds. The application still works fine and works as expected.

Does this type of error occur with the JDBC driver?

There is a similar SO question on this here .

Change 1:

Something really strange seems to be happening on lines 69 and 70 of my pasta. It looks like my specified dialect org.postgresql.Dialect is changing to some MySQL stuff.

[org.hibernate.dialect.Dialect] : [MySQL5] -> [org.hibernate.dialect.MySQL5Dialect] (replacing [org.hibernate.dialect.MySQL5Dialect])
2014-10-16 08:05:50.561 DEBUG 36916 --- [ost-startStop-1] o.h.b.r.s.internal.StrategySelectorImpl  : Registering named strategy selector [org.hibernate.dialect.Dialect] : [MySQL5InnoDB] -> [org.hibernate.dialect.MySQL5InnoDBDialect] (replacing [org.hibernate.dialect.MySQL5InnoDBDialect])
+4
source share
3 answers

. ... er... , System, .

- , Hibernate Postgresql . , , SQL- . System Hibernate Postgresql.

-Dhibernate.temp.use_jdbc_metadata_defaults=false

, - .

+7

Java-, , REF_CURSOR JDBC 4.2, , , 4.0

- "supportsRefCursors" null, .

Hibernate JDBC ?

, . SQL - , .

0

.

Spring , :

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

.

0

More articles:


All Articles