You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-10-25 09:04:43

SDaria
Member
2 posts

SDaria said:

[resolved] Use postgres for storage

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:postgresql://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  [PhaseInterceptorChain] Application {}TMDMService#{}putDataModel has thrown exception, unwinding now: java.rmi.RemoteException: Unable to create/update the Data Model test; 
[Caused by]: Could not create storage test with data model test.
[Caused by]: Could not create storage for container test (MASTER) using data model test.
[Caused by]: java.lang.RuntimeException: Could not create storage class loader
[Caused by]: Could not create storage class loader
[Caused by]: Could not generate Hibernate configuration
[Caused by]: 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

Last edited by SDaria (2016-10-25 11:51:57)

Offline

#2 2016-10-26 03:21:05

xdshi
Talend Team


xdshi said:

Re: [resolved] Use postgres for storage

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


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy