Hibernate issue after upgrading to Oracle 12c database

Questions and answers regarding general SQL and backend databases

Hibernate issue after upgrading to Oracle 12c database

Postby LXS » Mon Oct 30, 2017 1:54 pm

Hi,

we've updated a customers database from Oracle 11g to Oracle 12c.
The Servoy Server is on Servoy 7.4.8
Now it seems that the Hibernate version in Servoy 7.4.8 does not know or support Oracle 12:

Code: Select all
2017-10-30 12:39:41,606 WARN [main] org.hibernate.dialect.resolver.StandardDialectResolver - unknown Oracle major version [12] [ ]
2017-10-30 12:39:45,594 WARN [pool-1-thread-1] org.hibernate.dialect.resolver.StandardDialectResolver - unknown Oracle major version [12] [ ]
2017-10-30 12:39:45,657 WARN [pool-1-thread-1] org.hibernate.dialect.resolver.StandardDialectResolver - unknown Oracle major version [12] [ ]
2017-10-30 12:39:45,718 WARN [pool-1-thread-1] org.hibernate.dialect.resolver.StandardDialectResolver - unknown Oracle major version [12] [ ]


Stackoverflow says that there is a property "databasePlatform" which should be set to "org.hibernate.dialect.Oracle10gDialect":
https://stackoverflow.com/questions/304 ... ne-dialect

Does anybody has the same issue?
Where can i find / set this property?
Or is it possible to update the hibernate lib in Servoy?

Thank you very much!
Alex
Alexander Stefan
Dr. Maison & Partner GmbH
www.servoy-plugins.de
www.maison-partner.de
LXS
 
Posts: 110
Joined: Thu Mar 01, 2007 12:00 am

Re: Hibernate issue after upgrading to Oracle 12c database

Postby patrick » Mon Oct 30, 2017 3:14 pm

Are you sure you are using the very correct JDBC driver for the database version?
Patrick Ruhsert
Servoy DACH
patrick
 
Posts: 3622
Joined: Wed Jun 11, 2003 10:33 am
Location: Munich, Germany

Re: Hibernate issue after upgrading to Oracle 12c database

Postby LXS » Mon Oct 30, 2017 3:22 pm

Hi Patrick,

yes, i think so.
I've downloaded the JDBC driver from the following page:

http://www.oracle.com/technetwork/datab ... 10062.html

I've put ojdbc8.jar and orai18n.jar in the servoy/drivers folder.

Do you know what hibernate version Servoy 7.4.8 uses?

Alex
Alexander Stefan
Dr. Maison & Partner GmbH
www.servoy-plugins.de
www.maison-partner.de
LXS
 
Posts: 110
Joined: Thu Mar 01, 2007 12:00 am

Re: Hibernate issue after upgrading to Oracle 12c database

Postby LXS » Mon Oct 30, 2017 4:18 pm

The Servoy server starts, but now i've tried to import a solution in the empty repository.
It ends with the following message:

Code: Select all
2017-10-30 15:14    http-8080-1    ERROR    com.servoy.j2db.util.Debug    Throwable        
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Geschlossene Ergebnismenge: getStatement
     at com.servoy.j2db.server.Za.Za.Za(Za.java:1460)
     at com.servoy.j2db.server.Zc.Zk.Za(Zk.java:101)
     at com.servoy.j2db.server.Zc.Zj.importBlobs(Zj.java:720)
     at com.servoy.j2db.server.Zc.Zdb.Za(Zdb.java:184)
     at com.servoy.j2db.server.Zc.Zdb.importFromJarFile(Zdb.java:303)
     at com.servoy.j2db.server.servlets.ConfigServlet.Zi(ConfigServlet.java:122)
     at com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:3083)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620)
     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: Geschlossene Ergebnismenge: getStatement
     at oracle.jdbc.driver.InsensitiveScrollableResultSet.ensureOpen(InsensitiveScrollableResultSet.java:109)
     at oracle.jdbc.driver.InsensitiveScrollableResultSet.getStatement(InsensitiveScrollableResultSet.java:252)
     at com.servoy.extensions.oraclefix.OracleLobHandler.updateOracleBlob(OracleLobHandler.java:55)
     at com.servoy.j2db.server.Za.Za.Za(Za.java:341)
     ... 20 more
2017-10-30 15:14    http-8080-1    ERROR    com.servoy.j2db.util.Debug    Throwable        
java.sql.SQLException: Kein Transaktion aktiv
     at com.servoy.j2db.datasource.Zo.rollback(Zo.java:33)
     at com.servoy.j2db.util.Utils.rollback(Utils.java:1598)
     at com.servoy.j2db.server.Zc.Zk.importingDone(Zk.java:105)
     at com.servoy.j2db.server.Zc.Zdb.Za(Zdb.java:380)
     at com.servoy.j2db.server.Zc.Zdb.importFromJarFile(Zdb.java:303)
     at com.servoy.j2db.server.servlets.ConfigServlet.Zi(ConfigServlet.java:122)
     at com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:3083)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620)
     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
     at java.lang.Thread.run(Unknown Source)


So it's not possible to import the solution.

Are there no other developers using Oracle 12c?
Alexander Stefan
Dr. Maison & Partner GmbH
www.servoy-plugins.de
www.maison-partner.de
LXS
 
Posts: 110
Joined: Thu Mar 01, 2007 12:00 am

Re: Hibernate issue after upgrading to Oracle 12c database

Postby LXS » Mon Oct 30, 2017 5:21 pm

I think something goes wrong in the oraclelobfix.jar - but what?
Alexander Stefan
Dr. Maison & Partner GmbH
www.servoy-plugins.de
www.maison-partner.de
LXS
 
Posts: 110
Joined: Thu Mar 01, 2007 12:00 am

Re: Hibernate issue after upgrading to Oracle 12c database

Postby LXS » Mon Oct 30, 2017 6:08 pm

Hmm... now i've tried the Oracle 11g Release 2 (11.2.0.4) jdbc driver and importing the solution is possible.

Download link:
http://www.oracle.com/technetwork/apps- ... 90769.html

Obviously, it's not the proper jdbc driver for my Oracle 12.2.0.1.0 database, but it seems that it works.

I think the latest ojdbc8.jar driver does not work right with Servoy 7.4.10.
So can you have a look on it?
Alexander Stefan
Dr. Maison & Partner GmbH
www.servoy-plugins.de
www.maison-partner.de
LXS
 
Posts: 110
Joined: Thu Mar 01, 2007 12:00 am


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 3 guests

cron