How to exclude jdbc driver from job build

Anonymous — Sun, 26 Jun 2016 21:22:19 GMT

My talend DI job contains PostgresqlConnection component. Assembled DI job includes the postgresql jdbc driver. But the jdbc driver already is installed in the Talend ESB container. How to exclude jdbc driver from build job?
I use Talend DI 6.1.1.

Re: How to exclude jdbc driver from job build

Anonymous — Mon, 27 Jun 2016 14:25:53 GMT

You will want to use the shared destination approach and then define your postgress data source for the ESB container.

Re: How to exclude jdbc driver from job build

Anonymous — Mon, 27 Jun 2016 15:52:05 GMT

I use the shared destination approach:
   - define "Data source alias" in section Data source on component tPostgresql Connection, use options "Use exists connection" in component tPostgresqlOutput;
- create shared pool in Talend ESB container.

File $TALEND_ESB_RUNTIME/container/deploy/datasource_ctlproc_owner.xml

<?xml version="1.0" encoding="UTF-8"?>
<blueprint xmlns="">
<bean id="dataSource" class="org.postgresql.ds.PGPoolingDataSource">
<property name="user" value="ctlproc_owner"/>
<property name="password" value="pw"/>
<property name="serverName" value="10.18.40.121"/>
<property name="databaseName" value="ctlproc_db"/>
<property name="portNumber" value="5432"/>
<property name="initialConnections" value="3"/>
<property name="dataSourceName" value="ctlprocownerPgDS"/>
</bean>

<service interface="javax.sql.DataSource" ref="dataSource">
<service-properties>
    <entry key="osgi.jndi.service.name" value="jdbc/ctlprocowner_pg_ds"/>
    <entry key="datasource.name" value="ctlprocownerPgDS"/>
</service-properties>
</service>
</blueprint>

But jdbc driver contains in deploy jar.

topic Re: How to exclude jdbc driver from job build in Talend Studio

How to exclude jdbc driver from job build

Re: How to exclude jdbc driver from job build

Re: How to exclude jdbc driver from job build