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