Hi!
I'`m trying to deploy TMDMS with PostgreSQL datasource, so I added to my datasource.xml this part:
<datasource name="PostgreSQL-Default">
<master>
<type>RDBMS</type>
<rdbms-configuration>
<dialect>POSTGRES</dialect>
<connection-driver-class>org.postgresql.Driver</connection-driver-class>
<connection-url>jdbc:postgresql:<my_host_address>:<port>/TMDM_DB</connection-url>
<connection-username>mdm_master</connection-username>
<connection-password><my_password>==,Encrypt</connection-password>
<fulltext-index-directory>/usr/local/TOS_MDM-Server-20181026_1147-V7.1.1/data/indexes/PostgreSQL-Default</fulltext-index-directory>
<schema-generation>update</schema-generation>
<properties>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.default_schema">mdm_master</property>
</properties>
</rdbms-configuration>
</master>
<staging>
<type>RDBMS</type>
<rdbms-configuration>
<dialect>POSTGRES</dialect>
<connection-driver-class>org.postgresql.Driver</connection-driver-class>
<connection-url>jdbc:postgresql:<my_host_address>:<port>/TMDM_DB</connection-url>
<connection-username>mdm_staging</connection-username>
<connection-password><my_password>==,Encrypt</connection-password>
<schema-generation>update</schema-generation>
<properties>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.default_schema">mdm_staging</property>
</properties>
</rdbms-configuration>
</staging>
<system>
<type>RDBMS</type>
<rdbms-configuration>
<dialect>POSTGRES</dialect>
<connection-driver-class>org.postgresql.Driver</connection-driver-class>
<connection-url>jdbc:postgresql:<my_host_address>:<port>/TMDM_DB</connection-url>
<connection-username>mdm_system</connection-username>
<connection-password><my_password>==,Encrypt</connection-password>
<schema-generation>update</schema-generation>
<properties>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.default_schema">mdm_system</property>
</properties>
</rdbms-configuration>
</system>
</datasource>
and changed value db.default.datasource in my mdm.conf to PostgreSQL-Default
After starting embedded Tomcat, i found this in catalina.out:
java.lang.IllegalArgumentException: Not supported database type 'POSTGRES'
at com.amalto.core.storage.hibernate.DefaultStorageClassLoader.getDialect(Unknown Source)
at com.amalto.core.storage.hibernate.DefaultStorageClassLoader.generateHibernateConfiguration(Unknown Source)
and this in com.amalto.core.storage.hibernate.DefaultStorageClassLoader.java module:
protected String getDialect(RDBMSDataSource.DataSourceDialect dialectType) {
switch (dialectType) {
case H2:
// Default Hibernate configuration for Hibernate forgot some JDBC type mapping.
return H2CustomDialect.class.getName();
case MYSQL:
return "org.hibernate.dialect.MySQLDialect"; //$NON-NLS-1$
default:
throw new IllegalArgumentException("Not supported database type '" + dialectType + "'");
}
}
So, my question is - if anybody can help me with this?
Should I continue my attemts? Or this functionality is not supported?
