<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Hi everyone,</span><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
we are going to upgrade our OMERO.biobank installation to the 4.4.2 version so I'm doing some tests in order to check if the upgrade can be performed safely. <br>After successfully building the server, I launched the ./build.py build-schema command and the hdm2ddl tool wasn't able to complete the task and returned the following exception<br>
<br>...<br><div>_generate-schema:</div><div>Executing Hibernate Tool with a Hibernate Annotation/EJB3 Configuration</div><div>1. task: hbm2ddl (Generates database schema)</div><div>An exception occurred while running exporter #2:hbm2ddl (Generates database schema)</div>
<div>To get the full stack trace run ant with -verbose</div><div>org.hibernate.HibernateException: Dialect class not found: ome.tools.hibernate.PostgresqlDialect</div><div><br></div><div>BUILD FAILED</div><div>/opt/omero_4.4/build.xml:272: The following error occurred while executing this line:</div>
<div>/opt/omero_4.4/components/antlib/resources/global.xml:367: The following error occurred while executing this line:</div><div>/opt/omero_4.4/components/model/build.xml:86: org.hibernate.HibernateException: Dialect class not found: ome.tools.hibernate.PostgresqlDialect</div>
<div><span style="white-space:pre-wrap"> </span>at org.hibernate.dialect.Dialect.instantiateDialect(Dialect.java:295)</div><div><span style="white-space:pre-wrap"> </span>at org.hibernate.dialect.Dialect.getDialect(Dialect.java:284)</div>
<div><span style="white-space:pre-wrap"> </span>at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:121)</div><div><span style="white-space:pre-wrap"> </span>at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:91)</div>
<div><span style="white-space:pre-wrap"> </span>at org.hibernate.tool.ant.Hbm2DDLExporterTask.execute(Hbm2DDLExporterTask.java:45)</div><div><span style="white-space:pre-wrap"> </span>at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToolTask.java:186)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)</div><div><span style="white-space:pre-wrap"> </span>at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)</div>
<div><span style="white-space:pre-wrap"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div><div><span style="white-space:pre-wrap"> </span>at java.lang.reflect.Method.invoke(Method.java:597)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Target.execute(Target.java:390)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Target.performTasks(Target.java:411)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Project.executeTargets(Project.java:1212)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.taskdefs.SubAnt.execute(SubAnt.java:302)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.taskdefs.SubAnt.execute(SubAnt.java:221)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)</div><div><span style="white-space:pre-wrap"> </span>at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)</div>
<div><span style="white-space:pre-wrap"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div><div><span style="white-space:pre-wrap"> </span>at java.lang.reflect.Method.invoke(Method.java:597)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)</div>
<div><span style="white-space:pre-wrap"> </span>at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)</div><div><span style="white-space:pre-wrap"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div>
<div><span style="white-space:pre-wrap"> </span>at java.lang.reflect.Method.invoke(Method.java:597)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:398)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)</div><div><span style="white-space:pre-wrap"> </span>at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)</div>
<div><span style="white-space:pre-wrap"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div><div><span style="white-space:pre-wrap"> </span>at java.lang.reflect.Method.invoke(Method.java:597)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Target.execute(Target.java:390)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Target.performTasks(Target.java:411)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Project.executeTarget(Project.java:1329)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Project.executeTargets(Project.java:1212)</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Main.runBuild(Main.java:801)</div><div><span style="white-space:pre-wrap"> </span>at org.apache.tools.ant.Main.startAnt(Main.java:218)</div><div><span style="white-space:pre-wrap"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div><span style="white-space:pre-wrap"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</div><div><span style="white-space:pre-wrap"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div>
<div><span style="white-space:pre-wrap"> </span>at java.lang.reflect.Method.invoke(Method.java:597)</div><div><span style="white-space:pre-wrap"> </span>at omero.startAnt(omero.java:285)</div><div><span style="white-space:pre-wrap"> </span>at omero.main(omero.java:313)</div>
<div><br></div><div>I checked the psql profile file and changed the<br><div><br></div><div>omero.db.dialect=ome.tools.hibernate.PostgresqlDialect</div><div><br></div><div>line to<br><br>omero.db.dialect=org.hibernate.dialect.PostgreSQLDialect</div>
</div><div><br></div><div>like it was in the 4.3 version of OMERO. After this correction the build-schema command was able to successfully complete the task.<br>Is there an error in the psql profile file or did I do something wrong when I built the server (simply using the ./build.py command)?</div>
<div><br></div><div>Thanks,</div><div><br></div><div>Luca</div></div><div><br></div>-- <br>Luca Lianas<br><div>
<span>Data Fusion - Healthcare Flows</span><br>
CRS4 - Centro di Ricerche, Sviluppo e Studi Superiori della Sardegna<br>
POLARIS, Edificio 1, 09010 PULA (CA - Italy)<br>
<br>
<br>
Phone: 070/9250266<br>
Email: <a href="mailto:luca.lianas@crs4.it" target="_blank">luca.lianas@crs4.it</a><br>
</div>
<br>