Skip to main content Skip to complementary content

Installing the DataSource in an OSGi container

About this task

Once the corresponding JDBC driver installed in the Talend Runtime Container, type in the following command on the console:

feature:install tesb-datasource-<Database>

The corresponding DataSource will be installed into the container and a configuration file named org.talend.esb.datasource.<Database>.cfg will be created in the <Talend.runtime.dir>/container/etc folder.

For example, to install the Derby DataSource:

Procedure

  1. Execute the following command:
    feature:install tesb-datasource-derby
  2. On the Talend Runtime Container console, execute the list command, you will find the installed bundles and configuration of Derby driver:
    [225] [Active] [       ] [ ] [60] Apache Derby 10.8 (10.8.1000002.1095077)
    [226] [Active] [Created] [ ] [60] Service Activity Monitoring :: Datasource-derby ()
    The org.talend.esb.datasource.derby.cfg configuration file has been created into the <Talend.runtime.dir>/container/etc folder. In this configuration file, the Database settings can be configured dynamically. For example, the default properties of org.talend.esb.datasource.derby.cfg are:
    datasource.server=localhost
    datasource.port=1527
    datasource.database=db
    datasource.createdatabase=create
    datasource.user=test
    datasource.password=test

Results

Here is a table with the DataSource information for other databases which work with the Talend Runtime Container:

DataSource Name

Database

Database, Driver Version

Feature

ConfigFile

ds-derby Derby 10.8, 10.8.1.2 tesb-datasource-derby org.talend.esb.datasource.derby.cfg
ds-h2 H2 Engine 1.3, 1.3.165 tesb-datasource-h2 org.talend.esb.datasource.h2.cfg
ds-mysql MySQL 5.x 5.1, 5.1.18 tesb-datasource-mysql org.talend.esb.datasource.mysql.cfg
ds-mysql8 MySQL 8.x 8.0, 8.0.27 tesb-datasource-mysql-8 org.talend.esb.datasource.mysql8.cfg
ds-oracle Oracle 11.2.0, 11.2.0.2.0 tesb-datasource-oracle org.talend.esb.datasource.oracle.cfg
ds-db2 IBM DB2 9.7, 9.7 tesb-datasource-db2 org.talend.esb.datasource.db2.cfg
ds-sqlserver SQL Server 2008R2, 3.0 tesb-datasource-sqlserver org.talend.esb.datasource.sqlserver.cfg
ds-postgresql PostgreSQL 9.2 tesb-datasource-postgresql org.talend.esb.datasource.postgresql.cfg
Information noteNote: Other driver versions may work but have not been tested. For more information on software prerequisites, see the Talend Installation and Upgrade Guide .

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!