Identify two data source attributes that, if set properly can help avoid situations in which the application…

Your server includes an application that users a generic JDBC data source to connect to a
database. However, the network connection between the server and the database is not
100%reliable.
Identify two data source attributes that, if set properly can help avoid situations in which the
application fails due to a failed JDBC connection.

Your server includes an application that users a generic JDBC data source to connect to a
database. However, the network connection between the server and the database is not
100%reliable.
Identify two data source attributes that, if set properly can help avoid situations in which the
application fails due to a failed JDBC connection.

A.
Statement CacheType

B.
Pool ReserveMode

C.
TestTableName

D.
Test ConnectionMode

E.
TestConnectionson Reserve

Explanation:
http://docs.oracle.com/middleware/1213/wls/JDBCA/ds_tuning.htm

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

kiruba

kiruba

correct Ans: C,E

Reply

nebz

nebz

Answers : C/ E/

Test Table Name

The name of the database table to use when testing physical database connections. This name is required when you specify a Test Frequency and enable Test Reserved Connections.

Test Connections On Reserve

Enables WebLogic Server to test a connection before giving it to a client. (Requires that you specify a Test Table Name.)

The test adds a small delay in serving the client’s request for a connection from the pool, but ensures that the client receives a viable connection.

Source : http://docs.oracle.com/cd/E13222_01/wls/docs90/ConsoleHelp/pagehelp/JDBCjdbcdatasourcesjdbcdatasourceconfigconnectionpooltitle.html

Reply