[midPoint] 3.0 SNAPSHOT and Postgres

[Viliam Repan]

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 list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint

-- 
Ing. Viliam Repán(
Evolveum, s.r.o.

tel: +421 910 797978
mail: vilo.repan at evolveum.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20140509/7a0f69c7/attachment.htm>