topic Error Deploying REST service in Karaf with Oracle Connection Pool in Talend Studio

Error Deploying REST service in Karaf with Oracle Connection Pool

Anonymous — Sat, 16 Nov 2024 11:42:16 GMT

Hi,
My blueprint :
<?xml version="1.0" encoding="UTF-8"?>
<blueprint xmlns="http://www.osgi.org/xmlns/blueprint/v1.0.0"
default-activation="lazy">
<bean id="oracleDSContract" class="oracle.jdbc.pool.OracleConnectionPoolDataSource">
<property name="connectionCachingEnabled" value="true" />
<property name="URL" value="jdbcracle:thin:@xxxxxxx:1521:xxxxx"/>
<property name="user" value="xxxx"/>
<property name="password" value="xxxx"/>
<property name="autoReconnect" value="true"/>
<property name="connectionCacheProperties">
<props>
<prop key="MinLimit">1</prop>
<prop key="MaxLimit">5</prop>
<prop key="InitialLimit">1</prop>
<prop key="ConnectionWaitTimeout">200</prop>
</props>
</property>
</bean>

<bean id="dataSourceContract" class="org.apache.commons.dbcp.datasources.SharedPoolDataSource" destroy-method="close">
<property name="connectionPoolDataSource" ref="oracleDSContract"/>
<property name="maxActive" value="100"/>
<property name="maxIdle" value="5"/>
<property name="maxWait" value="-1"/>
<property name="defaultAutoCommit" value="false"/>
</bean>

<service interface="javax.sql.DataSource" ref="dataSourceContract">
<service-properties>
<entry key="osgi.jndi.service.name" value="jdbc/oracleds"/>
</service-properties>
</service>
After deploying a Rest service in karaf and testing, I have this error message :
getService() returned null for {javax.sql.DataSource}={osgi.service.blueprint.compname=dataSourceContract, osgi.jndi.service.name=jdbc/oracleds, service.id=466}
however my setup is good. Mysql pool connection works well, however the bug arises with oracle.
Any Idea ?

Re: Error Deploying REST service in Karaf with Oracle Connection Pool

Anonymous — Thu, 27 Mar 2014 02:44:36 GMT

Hi,
Could you indicate the build version you're using? Talend ESB Standard Edition, Talend Open Studio for ESB or Talend Enterprise ESB?
Best regards
Sabrina

Re: Error Deploying REST service in Karaf with Oracle Connection Pool

Anonymous — Thu, 27 Mar 2014 07:56:54 GMT

Hi Sabrina,
I use Talend Platform Universal 5.4.1
In Karaf, all bundle installed are Ok :
Service Activity Monitoring :: Datasource-oracle (5.4.1)
datasource-mysql.xml (0.0.0)
Sun Microsystems' JDBC Driver for MySQL (5.1.26)
Apache ServiceMix :: Specs :: Stax API 1.0 (1.9.0)
Service Activity Monitoring :: Datasource-mysql (5.4.1)
LOGIN (0.1.0.SNAPSHOT)
CUSTOMER_WARRANTY (0.1.0.SNAPSHOT)
datasource-oracle.xml (0.0.0)
wrap_file_E__Talend_5.4.1_runtime_lib_ojdbc6.jar (0)
karaf@trun>
I haven't any bug with MYSQL (it works well).
The problem is with ORACLE.

Re: Error Deploying REST service in Karaf with Oracle Connection Pool

Anonymous — Thu, 27 Mar 2014 08:22:56 GMT

Hi,
Would you mind opening a ticket on Talend Support Portal our colleagues from support team can give you a remote assistance so that your issue is processed with priority.
Best regards
Sabrina

Re: Error Deploying REST service in Karaf with Oracle Connection Pool

Anonymous — Thu, 27 Mar 2014 08:33:58 GMT

Thanks Sabrina, i will do it.

Re: Error Deploying REST service in Karaf with Oracle Connection Pool

Anonymous — Thu, 27 Mar 2014 08:49:43 GMT

Hi,
Feel free let me know if there is any further help we can give.
Best regards
Sabrina