[midPoint] 3.0 SNAPSHOT and Postgres

[Alexander Grzesik]

Hi Viliam
 
That fixes my problem
Thank you
Alexander
 
Von: midpoint-bounces at lists.evolveum.com [mailto:midpoint-bounces at lists.evolveum.com] Im Auftrag von Viliam Repan
Gesendet: Freitag, 9. Mai 2014 10:57
An: midPoint General Discussion
Betreff: Re: [midPoint] 3.0 SNAPSHOT and Postgres
 
Hi Alexander,

you've probably used https://wiki.evolveum.com/display/midPoint/Repository+Configuration#RepositoryConfiguration-PostgreSQL
to configure midpoint to use postgresql. I've just checked it and that page contains outdated data.
You should update your config.xml located in "midpoint.home" folder like this.

        <repository> 
            <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
            <embedded>false</embedded>
            <driverClassName>org.postgresql.Driver</driverClassName>
            <jdbcUsername>midpoint</jdbcUsername>
            <jdbcPassword>password</jdbcPassword>
            <jdbcUrl>jdbc:postgresql://localhost/midpoint</jdbcUrl>
            <hibernateDialect>com.evolveum.midpoint.repo.sql.util.MidPointPostgreSQLDialect</hibernateDialect>
            <hibernateHbm2ddl>validate</hibernateHbm2ddl>
        </repository>

I already updated wiki. Please let me know if there are any other problems.

Cheers,
Vilo
On 05/09/2014 10:33 AM, Alexander Grzesik wrote:
Hi,
 
I tried to change the current snapshot version to use a postgres DB instead of the embedded one. I created the Schema with the current sql files, but when I start midpoint it throws an error that it cannot create the sessionfactory.
The reason seems a problem in its hibernate schema definition: 
Caused by: org.hibernate.HibernateException: Wrong column type in public.m_object for column fullObject. Found: bytea, expected: oid
               at org.hibernate.mapping.Table.validateColumns(Table.java:374) ~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
 
Any tip what I can change to use the postgrs db?
Thanks
Alexander



_______________________________________________midPoint mailing listmidPoint at lists.evolveum.comhttp://lists.evolveum.com/mailman/listinfo/midpoint

-- Ing. Viliam RepáňEvolveum, s.r.o. tel: +421 910 797978mail: vilo.repan at evolveum.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20140509/84a0bf79/attachment.htm>