topic I need to change connection shared to dedicated in toracleinput. in Talend Studio

I need to change connection shared to dedicated in toracleinput.

Anonymous — Mon, 30 Sep 2013 16:07:50 GMT

Hi,
I need to change from oracle connection shared (mts) to dedicated in toracleinput.
In tnsnames.ora we can use:
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.12)(PORT = 1521))
(CONNECT_DATA =
(SERVER=DEDICATED)
(SERVICE_NAME=db)
)
)
In jdbcthin we can use:
"jdbc racle:thin:@(description=(address_list=
(address=(protocol=tcp)(port=1610)(host=10.10.10.12))
(connect_data=(SERVER=DEDICATED)(INSTANCE_NAME=db))
)";
But I don´t use tnsnames. I Only use a toracleinput configuration.
So, How can I put "SERVER=DEDICATED" as a parameter in toracleinput ?

Can someone help me?
Thanks
Marcio.

Re: I need to change connection shared to dedicated in toracleinput.

Anonymous — Mon, 30 Sep 2013 16:42:07 GMT

add it in "additional jdbc parameters" in your tOracleInput's Advanced Settings sub-tab.

Re: I need to change connection shared to dedicated in toracleinput.

Anonymous — Mon, 30 Sep 2013 18:24:05 GMT

Ok, but do you know how is the correct string.

Re: I need to change connection shared to dedicated in toracleinput.

Anonymous — Mon, 30 Sep 2013 18:32:38 GMT

Ok, but do you know how is the correct string ?

Re: I need to change connection shared to dedicated in toracleinput.

Anonymous — Tue, 01 Oct 2013 19:08:47 GMT

About :
Question: "How can I put "SERVER=DEDICATED" as a parameter in toracleinput ?"
Answer: "add it in "additional jdbc parameters" in your tOracleInput's Advanced Settings sub-tab."
Question: "Ok, but do you know: how is the correct string to write in "additional jdbc parameters" ?"

Can someone help me?
Thanks
Marcio.

Re: I need to change connection shared to dedicated in toracleinput.

Anonymous — Tue, 01 Oct 2013 20:12:50 GMT

sure, try entering this in the additional jdbc parameters text box. Since this is just off the top of my head, I may be incorrect--
if the code below does not work, please refer to the Oracle jdbc docs for the proper string:
http://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html

connect_data=(SERVER=DEDICATED);