One Star

Adding connection properties/parameters to a JDBC connection

Hi everybody,
I have to add a special property to ma Oracle connection: SetBigStringTryClob=true.
Do you know where i can add that in a talend studio database connection?
Thanks,
Regards,
Philippe
3 REPLIES
Seventeen Stars

Re: Adding connection properties/parameters to a JDBC connection

hi,
Have you tried in the "string of connection" (when you create a new metadata databade connection) !?
One Star

Re: Adding connection properties/parameters to a JDBC connection

We already tries that, and it doesn't work.
This is because the generated database connection code use the following function :
java.sql.DriverManager.getConnection(url_tOracleConnection_1,
dbUser_tOracleConnection_1,
dbPwd_tOracleConnection_1);
But it should use this one to allow the use of custom connection properties :
java.sql.DriverManager.getConnection(,
);
Should we develop a custom component or is there another way to do it?
Thanks regards.
Employee

Re: Adding connection properties/parameters to a JDBC connection

Hello,
You can open a feature request on our bugtracker
Regards,