Setting the datasource configuration file - 7.0

Data Service and Routing Examples

Version
7.0
Language
English (United States)
Product
Talend Data Fabric
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development > Designing Routes
Design and Development > Designing Services

Procedure

  1. Set the database connection details in the MySQL datasource configuration file named datasource-mysql.xml in the <TalendRuntimePath>/add-ons/datasources/dataservice folder.
    <bean id="mysqlDataSource" class="com.mysql.jdbc.jdbc2.optional.
    MysqlConnectionPoolDataSource">
        <property name="url" value="jdbc:mysql://localhost:3306/root"/>
        <property name="user" value="root"/>
        <property name="password" value=""/>
    </bean>
    
    <bean id="dataSource" class="org.apache.commons.dbcp.datasources.
    SharedPoolDataSource" destroy-method="close">
        <property name="connectionPoolDataSource" ref="mysqlDataSource"/>
        <property name="maxActive" value="20"/>
        <property name="maxIdle" value="5"/>
        <property name="maxWait" value="-1"/>
    </bean>
    
    <service ref="dataSource" interface="javax.sql.DataSource">
        <service-properties>
             <entry key="osgi.jndi.service.name" value="jdbc/sample"/>
        </service-properties>
    </service>
  2. Copy the configuration file to the deploy folder within the Talend Runtime container directory. The datasource alias jdbc/sample will be used in the MySQL database components when configuring the Job in the Studio. You can also change it as needed.