topic Re: How do I use connection pooling with tjdbcConnection? in Talend Studio

How do I use connection pooling with tjdbcConnection?

Anonymous — Sat, 16 Nov 2024 11:46:39 GMT

Dear talend forums,
Sorry in advance for any confusion, I am a talend novice.
I am looking to use a connection pool to access my database (H2) with a tjdbcInput component.
Under tjdbcConnection "there is a specify datasource alias" checkbox, which I then check and specify a name.
I then create a datasource.xml file which specifies connection pool parameters.
Where do I put this file? At what point does talend runtime read this?
Thank you very much, Jason

Re: How do I use connection pooling with tjdbcConnection?

atelesh — Mon, 20 Jan 2014 08:44:23 GMT

just put your datasource.xml into deploy folder of your runtime container and talend runtime instantiate datasource for you.
after that you can deploy your job with tJDBC* component.

Re: How do I use connection pooling with tjdbcConnection?

Anonymous — Mon, 20 Jan 2014 10:19:03 GMT

Thank you very much for replying.
Do I need to reference the bean in the talend job anywhere?
I have made the data source XML and put it in the deploy folder. My XML file looks like
<bean>
...
</bean>
<service ref="dataSource" interface="javax.SQL.data source">
<service-properties>
<entry key="OSGi.jndi.service.name value="datasource-h2">
</service a properties>
</service>
In my tjdbc component I checked "specify a data source alias" and wrote datasource-h2.
Am I missing anything else? I still get a " waiting for dependencies OSGi.jndi.service.name=datasource-h2."
Thank you very much!

Re: How do I use connection pooling with tjdbcConnection?

Anonymous — Tue, 21 Jan 2014 07:31:49 GMT

Try in lower case: key="osgi.jndi.service.name"