Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Overview of this book

Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface

JDBC 4.0 Version


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...