Hibernate issue after upgrading to Oracle 12c database

Classic Servoy
1

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:

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

2

Are you sure you are using the very correct JDBC driver for the database version?

3

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

4

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

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?

5

I think something goes wrong in the oraclelobfix.jar - but what?

6

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?