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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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="jdbc0683p000009MA5A.pngracle: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 ?

Labels (2)
5 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

Thanks Sabrina, i will do it.
Anonymous
Not applicable
Author

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