topic Re: Adding connection properties/parameters to a JDBC connection in Talend Studio

Adding connection properties/parameters to a JDBC connection

Anonymous — Sat, 16 Nov 2024 14:08:35 GMT

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

Re: Adding connection properties/parameters to a JDBC connection

Anonymous — Fri, 28 Nov 2008 11:46:44 GMT

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

Re: Adding connection properties/parameters to a JDBC connection

Anonymous — Fri, 28 Nov 2008 12:31:16 GMT

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.

Re: Adding connection properties/parameters to a JDBC connection

Anonymous — Fri, 28 Nov 2008 14:05:35 GMT

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