|
Home:Learn XQuery:XQuery Examples:Connection Pooling:Tomcat
Deploying DataDirect XQuery® on Tomcat
This section describes the guidelines for deploying DataDirect XQuery® on an application server running
Tomcat 5.x or 6.x.
- Install DataDirect XQuery® by copying the DataDirect XQuery® jar files
to CATALINA_home/common/lib, where CATALINA_home is your Tomcat installation directory.
- Define your JDBC DataSource resource in CATALINA_home/conf/server.xml
For example:
<context path="/DDXQServlet" docBase="DDXQServlet.war">
<Resource name="jdbc/DDXQExample"
auth="Container"
type="javax.sql.DataSource"
username="john"
password="topsecret"
driverClassName="com.ddtek.xquery3.jdbc.XQueryDriver"
url="jdbc:datadirect:xquery3://jdbcUrl=
{jdbc:xquery:sqlserver://localhost:1433;databaseName=ddxq_example}"
initialSize="1"
accessToUnderlyingConnectionAllowed="true"
validationQuery="SELECT * FROM FOO" />
</context>
JDBC DataSource resource configuration options are described later in this section. Note, however, that the
accessToUnderlyingConnectionAllowed configuration parameter must be set to "true".
- Deploy the servlet DDXQServlet.war by copying it into CATALINA_home/webaps.
- Start Tomcat.
- Open your Web browser and point it to:
http://myserver:8080/DDXQServlet/
A JDBC DataSource resource can be configured with a number of options. The following table describes settings that are specific to
DataDirect XQuery®. Refer to your Tomcat documentation for details.
| Parameter |
Description |
| type |
Must be javax.sql.DataSource. |
| username |
User name to log on the database. |
| password |
Password to log on the database. |
| url |
Connection URL in the format jdbc:datadirect:xquery3://JdbcUrl={url}[;optionalProperty=value[;...]] See Configuring a Connection Through the JDBC Driver Manager in the DataDirect XQuery User's Guide and Reference for more information. |
| driverClassName |
Must be com.ddtek.xquery3.jdbc.XQueryDriver. |
| defaultReadOnly |
Not supported; do not use. |
| defaultTransactionIsolation |
Cannot be set. In order to change the default transaction isolation, use the appropriate DataDirect XQuery connection property. |
| defaultCatalog |
Cannot be set. In order to change the default catalog, use the appropriate DataDirect XQuery connection property. |
| validationQuery |
See Tomcat documentation. Note that this query can be anything. DataDirect XQuery will ping the database connection to check
the connection validity.
|
| poolPreparedStatements |
Should not be used in the context of DataDirect XQuery®. Use DataDirect XQuery’s query pooling to maximize performance.
|
| maxOpenPreparedStatements |
Should not be used in the context of DataDirect XQuery®. Use DataDirect XQuery’s query pooling to maximize performance.
|
| accessToUnderlyingConnectionAllowed |
MUST be set to true. |
See the Example: JDBC Connection Pooling Servlet for an example of implementing a JDBC connection pool in DataDirect XQuery®.
| 
