Neither WebLogic Server 9.x nor 10.x supports JDBC 4.0. In a later version of WebLogic server, we can avail the new features in JDBC 4.0. To use the JDBC 4.0 driver, we will modify the catalog.jsp
to get connected to the Oracle database from the WebLogic Server. Oracle database 11g JDBC drivers support JDBC 4.0, and can be downloaded from: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html. The JDBC 4.0 features can be used by adding the JDBC 4.0 JAR file, ojdbc6.jar
, to the server lib
directory, or to the classpath
variable of the startWebLogic
script. JDBC 4.0 has added support for setting client info properties on Connection
objects to identify connections that could bog down an application. Standard client info properties are ApplicationName, ClientUser
, and ClientHostname
. In the JDBC 4.0 version of the web application, set the standard client info properties on the Connection
object:
connection.setClientInfo("ApplicationName","OracleApp...