Hi Team,
Can anyone tell me if the other properties of the JDBC Adapter Connection is defined as below , what it means:
driverType=thin,server=dedicated.
TIA
Hi Team,
Can anyone tell me if the other properties of the JDBC Adapter Connection is defined as below , what it means:
driverType=thin,server=dedicated.
TIA
Hi Priyanka,
not sure about the server=dedicated part as I have never used this.
driverType=thin is the preferred setting when using oracle database with ojdbc driver jar instead of driverType=oci, which requires an additional native lib.
Regards,
Holger
Check oracle docs.
SERVER
Purpose
Use the parameter SERVER to instruct the listener to connect the client to a specific type of service handler.
Embed this parameter under the CONNECT_DATA parameter.
Values
dedicated to specify that client requests be served by dedicated server
shared to specify that client request be served by shared server
Note:
Shared server must be configured in the database initialization file in order for the client to connect to the database with a shared server process. See the Oracle Net Services Administrator’s Guide for configuration information.
Note:
The USE_DEDICATED_SERVER parameter in the sqlnet.ora file overrides this parameter.
Example
net_service_name=
(DESCRIPTION=
(ADDRESS=…)
(ADDRESS=…)
(CONNECT_DATA=
(SERVER_NAME=sales.us.acme.com)
(SERVER=dedicated)))
Interesting where did you get this setting from “server=dedicated”… the commonly used is -
Other Properties driverType=thin
HTH,
RMG