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