[resolved] Use postgres for storage

Anonymous — Tue, 25 Oct 2016 09:04:43 GMT

Hi. I'm new to Talend and using Talend Open Studio MDM 6.2.0. I want to use postgres for MDM SQL Storage and tried to follow helpcenter (Mdm sql storage)

0) Tried cnange mdm.conf
db.default.datasource=Postgres-Default
Got errors Error creating bean with name 'defaultXmlServer', Data source 'Postgres-Default' can not be found in configuration.
1) Changed MDM\conf\datasources.xml (mdm.conf default)
<dialect>Postgres</dialect>
<connection-driver-class>org.postgresql.Driver</connection-driver-class>
<connection-url>jdbc ostgresql://localhost:5432/testdatabase;DB_CLOSE_ON_EXIT=FALSE</connection-url>
<fulltext-index-directory>C:\MDM\data\indexes\PostgreSQL</fulltext-index-directory>

2) Created model and container "test", tried deploy and got error
INFO Application {}TMDMService#{}putDataModel has thrown exception, unwinding now: java.rmi.RemoteException: Unable to create/update the Data Model test;
: Could not create storage test with data model test.
: Could not create storage for container test (MASTER) using data model test.
: java.lang.RuntimeException: Could not create storage class loader
: Could not create storage class loader
: Could not generate Hibernate configuration
: Not supported database type POSTGRES; nested exception is:
com.amalto.core.util.XtentisException: Unable to create/update the Data Model test
Full log in attachment
Can postgres be used as sql storage? How it can be done?
UPD Found answer.

localhost.2016-10-25.log_20161025-0110.log
localhost.2016-10-25_.log.log

Re: [resolved] Use postgres for storage

Anonymous — Wed, 26 Oct 2016 03:21:05 GMT

Hello,
We see that this topic has been set as resolved. Could you please share your solution with us?
Best regards
Sabrina

topic [resolved] Use postgres for storage in Talend Data Catalog

[resolved] Use postgres for storage

Re: [resolved] Use postgres for storage