[ome-devel] Error(?) in OMERO 4.4.2 psql profile file

[Luca Lianas]

Hi Josh,
thanks for the advice, I restored the psql profile file to the "git state"
and used the -D... flag and everything worked fine.

Thanks,

Luca

2012/8/28 Josh Moore <josh at glencoesoftware.com>

>
> On Aug 28, 2012, at 3:50 PM, Luca Lianas wrote:
>
> > Hi everyone,
>
> Hi Luca,
>
>
> > 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.
> > 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
> >
> > ...
> >
> > BUILD FAILED
> > /opt/omero_4.4/build.xml:272: The following error occurred while
> executing
> > this line:
> > /opt/omero_4.4/components/antlib/resources/global.xml:367: The following
> > error occurred while executing this line:
> > /opt/omero_4.4/components/model/build.xml:86:
> > org.hibernate.HibernateException: Dialect class not found:
> > ome.tools.hibernate.PostgresqlDialect
> > ...
> >
> > I checked the psql profile file and changed the
> >
> > omero.db.dialect=ome.tools.hibernate.PostgresqlDialect
> >
> > line to
> >
> > omero.db.dialect=org.hibernate.dialect.PostgreSQLDialect
> >
> > like it was in the 4.3 version of OMERO. After this correction the
> > build-schema command was able to successfully complete the task.
> > 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)?
>
> 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:
>
>         ./build.py build-schema \
>             -Domero.db.dialect=org.hibernate.dialect.PostgreSQLDialect
>
> which I should hard-code in components/model/build.xml before importing
> the other config files.
>
>
> > Thanks,
> > Luca
>
>
> Sorry for the confusion,
> ~Josh




-- 
Luca Lianas
Data Fusion - Healthcare Flows
CRS4 - Centro di Ricerche, Sviluppo e Studi Superiori della Sardegna
POLARIS, Edificio 1, 09010 PULA (CA - Italy)


Phone: 070/9250266
Email: luca.lianas at crs4.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-devel/attachments/20120829/1a8435a8/attachment-0001.html>