setting up JDBC connection pool in Talend ESB container

[Anonymous]

Hi,

I'm trying to setup my REST services jobs to use JDBC connection pooling when deployed on Talend ESB runtime (Karaf).

I've followed the instructions in the documentation guide here

From the docs I've run the following:

1. place the SQL Server JDBC driver in ./runtime/deploy/sqljdbc42.jar
2. feature:install tesb-datasource-sqlserver
3. feature:list | grep sqlserver  
   tesb-datasource-sqlserver | 6.2.1 | x | Started | tesb-6.2.1 |
4. edited ./runtime/etc/org.talend.esb.datasource.sqlserver.cfg 
   dataSource.url=jdbc:sqlserver://MYHOST:1433;databaseName=MYDB
   dataSource.user=MYUSER
   dataSource.password=MYPASS
   datasource.pool.maxActive=20
   datasource.pool.maxIdle=5
   datasource.pool.maxWait=30000
5. Actually I'm not sure where the JDBC Driver class name is set above! It should be "com.microsoft.sqlserver.jdbc.SQLServerDriver". Anyway!
6. bundle:list | grep MSSQL
   355 | Active | 80 | 0.8.0 | OPS4J Pax JDBC MSSQL Driver Adapter
7. bundle:refresh 355
8. bundle:restart 355

Now, I have a job that sets the data source alias on my MSSQLServerConnection:

But when I deploy my job, the bundle stays in "GracePeriod" state. 

When I look at the logs I see that the job is waiting on a dependency with the following error message:

2017-05-04 18:25:59,919 | INFO | ool-491-thread-1 | BlueprintContainerImpl | 16 - org.apache.aries.blueprint.core - 1.6.1 | Bundle demo.rest1/0.5.0.SNAPSHOT is waiting for dependencies [(&(osgi.jndi.service.name=ds-sqlserver)(objectClass=javax.sql.DataSource))] 

What's the dependency feature that needs to be started??

I'm feeling Karaf has not started the ds-sqlserver connection pool!!!

[David_Beaty]

Hi @Brian Johnson​ 

Used your instructions above to install connection pooling for a SQL Server instance running the Talend Runtime 7.3.1 Open Source.

So helpful

Thanks

David