Configure the database connection information

Talend MDM Platform Installation Guide for Solaris

EnrichVersion
6.5
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
Talend CommandLine
Talend DQ Portal
Talend Identity and Access Management
Talend Activity Monitoring Console
Talend Data Stewardship
Talend SAP RFC Server
Talend Repository Manager
Talend Runtime
Talend Installer
Talend Log Server
Talend ESB
Talend MDM Web UI
Talend Artifact Repository
Talend MDM Server
Talend JobServer
Talend Administration Center
Talend Data Preparation
Talend Studio

Procedure

  1. Open the <TomcatPath>/conf/context.xml file and add the following lines, according to your database server:

    For H2:

    <Resource name="jdbc/datasource" auth="Container"
    type="javax.sql.DataSource" username="sa" password=""
    driverClassName="org.h2.Driver"
    url="jdbc:h2:tcp://localhost/~/test"
    maxActive="8" maxIdle="30" maxWait="10000"/>

    For Derby:

    <Resource name="jdbc/datasource" auth="Container"
    type="javax.sql.DataSource" username="test" password="test"
    driverClassName="org.apache.derby.jdbc.ClientDriver"
    url="jdbc:derby://localhost:1527/db;create=true"
    maxActive="8" maxIdle="30" maxWait="10000"/>

    For MySql:

    <Resource name="jdbc/datasource" auth="Container"
    type="javax.sql.DataSource" username="test" password="test"
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/test"
    maxActive="8" maxIdle="30" maxWait="10000"/>

    For DB2:

    <Resource name="jdbc/datasource" auth="Container"
    type="javax.sql.DataSource" username="db2admin" password="qwaszx"
    driverClassName="com.ibm.db2.jcc.DB2Driver"
    url="jdbc:db2://localhost:50000/TEST"
    maxActive="8" maxIdle="30" maxWait="10000"/>

    For SQLServer:

    <Resource name="jdbc/datasource" auth="Container"
    type="javax.sql.DataSource" username="test" password="test"
    driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1029;instanceName=sqlexpress;databaseName=Test"
    maxActive="8" maxIdle="30" maxWait="10000"/>

    For Oracle:

    <Resource name="jdbc/datasource" auth="Container"
    type="javax.sql.DataSource" username="xxx" password="xxx"
    driverClassName="oracle.jdbc.pool.OracleDataSource"
    url="jdbc:oracle:thin:@localhost:1521:XE"
    maxActive="8" maxIdle="30" maxWait="10000"/>
  2. Check the database connection information specified in the following file, and edit them if needed: <TomcatPath>/webapps/sam-server-war/WEB-INF/logserver.properties