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

Configuring a Connection


We also need to create a database connection to run an XSQL query. By default Oracle XSQL Pages use Oracle JDBC data sources configured in the J2EE web application environment. The factory element in the connection-manager element in XSQLConfig.xml sets the XSQL Pages to use the JDBC data sources.

<connection-manager>
…
<factory>
oracle.xml.xsql.XSQLOracleDatasourceConnectionManager
</factory>
</connection-manager>

XSQL pages also have the provision to use XSQLConfig.xml-based named connections by setting the connection-manager factory class in XSQLConfig.xml as follows:

<factory>oracle.xml.xsql.XSQLConnectionManagerFactoryImpl</factory>

If third-party JDBC data sources are to be used in an XSQL page set the connection‑manager factory class in XSQLConfig.xml as follows:

<factory> oracle.xml.xsql.XSQLDatasourceConnectionManager</factory>

JDeveloper 10.1.3.3 provides three different methods to create a database connection...