Error Deploying REST service in Karaf with Oracle Connection Pool

Highlighted

Error Deploying REST service in Karaf with Oracle Connection Pool

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="jdbcSmiley Surprisedracle: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 ?
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

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

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.
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

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

Thanks Sabrina, i will do it.
Moderator

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

Hi,
Feel free let me know if there is any further help we can give.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.