配置数据库连接信息 - 8.0

Talend Open Studio 安装和升级指南 Linux 版

Version
8.0
Language
中文(简体)
EnrichDitaval
Linux
EnrichSubscriptionType
开源
Product
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Module
Talend ESB
Talend Studio
Content
安装和升级
适用产品...

Open Studio for ESB

步骤

  1. 打开 <TomcatPath>/conf/context.xml 文件并根据您的数据库服务器添加以下行:

    对于 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"/>

    对于 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"/>

    对于 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"/>

    对于 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"/>

    对于 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"/>

    对于 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. 检查以下文件中指定的数据库连接信息,并根据需要编辑它们:<TomcatPath>/webapps/sam-server-war/WEB-INF/logserver.properties