Hi Josh,<div>thanks for the advice, I restored the psql profile file to the "git state" and used the -D... flag and everything worked fine.</div><div><br></div><div>Thanks,</div><div><br></div><div>Luca<br><br><div class="gmail_quote">
2012/8/28 Josh Moore <span dir="ltr"><<a href="mailto:josh@glencoesoftware.com" target="_blank">josh@glencoesoftware.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
On Aug 28, 2012, at 3:50 PM, Luca Lianas wrote:<br>
<br>
> Hi everyone,<br>
<br>
Hi Luca,<br>
<div class="im"><br>
<br>
> we are going to upgrade our OMERO.biobank installation to the 4.4.2 version<br>
> so I'm doing some tests in order to check if the upgrade can be performed<br>
> safely.<br>
> After successfully building the server, I launched the ./build.py<br>
> build-schema command and the hdm2ddl tool wasn't able to complete the task<br>
> and returned the following exception<br>
><br>
> ...<br>
><br>
</div><div class="im">> BUILD FAILED<br>
> /opt/omero_4.4/build.xml:272: The following error occurred while executing<br>
> this line:<br>
> /opt/omero_4.4/components/antlib/resources/global.xml:367: The following<br>
> error occurred while executing this line:<br>
> /opt/omero_4.4/components/model/build.xml:86:<br>
> org.hibernate.HibernateException: Dialect class not found:<br>
> ome.tools.hibernate.PostgresqlDialect<br>
</div>> ...<br>
<div class="im">><br>
> I checked the psql profile file and changed the<br>
><br>
> omero.db.dialect=ome.tools.hibernate.PostgresqlDialect<br>
><br>
> line to<br>
><br>
> omero.db.dialect=org.hibernate.dialect.PostgreSQLDialect<br>
><br>
> like it was in the 4.3 version of OMERO. After this correction the<br>
> 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<br>
> I built the server (simply using the ./build.py command)?<br>
<br>
</div>There's not an error in the psql but in the build system. At the point where you are generating the DB (components/model) the ome.tools.hibernate classes are not available since they're in components/server. Therefore, for anyone generating the schema, it's necessary to use:<br>
<br>
./build.py build-schema \<br>
-Domero.db.dialect=org.hibernate.dialect.PostgreSQLDialect<br>
<br>
which I should hard-code in components/model/build.xml before importing the other config files.<br>
<br>
<br>
> Thanks,<br>
> Luca<br>
<br>
<br>
Sorry for the confusion,<br>
~Josh</blockquote></div><br><br clear="all"><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>
</div>