Talend ESB : Oracle connectivity issue - Karaf

[Anonymous]

 Hello All,

we've a subscription version of talend 6.1.1. I recently developed a web service involving rest components and toracleoutput component. Goal is to receive a json message via rest and insert the data into a Oracle database. in studio everything works fine, issues are with deployment. I deployed this job into Talend runtime and we started to see initially oracle.jdbc.OracleDriver cannot be found. After consulting with Talend support and all, we were advised to place the ojdbc6.jar  under /runtime/lib/deploy folder which automatically installed the bundle karaf. 

471 | Active | 80 | 0.0.0      | odjbc6.jar

later we were told to create a datasource-oracle.xml file and place it in the same directory (/runtime/lib/deploy) to put in all the database related info . Redeployed my job and initiated the web service.

Now I see invalid username / password. Logon denied.

quick overview of my job - trestrequest -> textractjson -> tmap -> toracleoutput (datasource alias checked referring to datasource-oracle.xml - jdbc/dev) -> tjavaflex

                                            |

                                           tjava - > tresponse 

                                         logcatcher - > tsendemail

toracleinput is set as repository getting its values from context variable that are defined . I created db connection under metadata and exported the values as context. attached sample datasource-oracle.xml

let me know how should i proceed to make this work.

Thanks

Arun

[Anonymous]

Hi Arun,

Did you set the datasource configuration file correctly?

Could you please have a look at this document about:TalendHelpCenter:Configuring datasource in Talend Runtime for V 6.1?

Best regards

Sabrina

[Anonymous · Accepted solution]

Actually whatever I've done so far is good. the issue was with userid i'm using for database connection. It didn't enough privileges to create a jdbc connection and thus it failed. Apart from that all the setup and datasources I configured are good. We can close this post.

Thanks

Arun