Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to exclude jdbc driver from job build

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.

Labels (2)
2 Replies
Anonymous
Not applicable
Author

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

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.
0683p000009MFRS.png 0683p000009MFRX.png
0683p000009MFRc.png