One Star mft
One Star

I need to change connection shared to dedicated in toracleinput.

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:
"jdbcSmiley Surprisedracle: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.
5 REPLIES

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

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

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

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

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

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

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

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.

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);