|
Home:Learn XQuery:XQuery Examples:Connection Pooling:JBoss
Deploying DataDirect XQuery® on JBoss
This section describes the guidelines for deploying DataDirect XQuery® on an application server running
JBoss 4.x or 5.x.
- Install DataDirect XQuery® by copying the DataDirect XQuery® jar files
to JBoss_home/server/server_config/lib, where JBoss_home is your JBoss installation directory, and
server_config is your server configuration directory.
- In the JBoss_home/server/server_config/deploy directory, create a DataSource resource file named
ddxqexample-ds.xml.
The file name must end with the characters -ds.xml so that the JBoss server can recognize it as a DataSource resources file;
however, the file name can be prefixed with any set of characters.
For example:
<?xml version="1.0" encoding="UTF-8" ?>
<datasources>
<local-tx-datasource>
<jndi-name>DDXQExample</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:datadirect:xquery3://jdbcUrl=
{jdbc:xquery:sqlserver://localhost:1433;databaseName=ddxq_example}
</connection-url>
<driver-class>com.ddtek.xquery3.jdbc.XQueryDriver</driver-class>
<user-name>john</user-name>
<password>topsecret</password>
<check-valid-connection-sql>SELECT * FROM FOO</check-valid-connection-sql>
</local-tx-datasource>
</datasources>
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.ear by copying it into JBoss_home/server/server_config/deploy.
- Start JBoss.
- Open your Web browser and point it to:
http://myserver:8080/DDXQServlet/
JBoss supports different type of JDBC DataSource resources. With DataDirect XQuery, you must use either no-tx-datasource or local-tx-datasource.
The following table describes settings that are specific to
DataDirect XQuery®. Refer to your JBoss documentation for details.
| Parameter |
Description |
| user-name |
User name to log on the database. |
| password |
Password to log on the database. |
| connection-url |
Connection URL. |
| driver-class |
Must be com.ddtek.xquery3.jdbc.XQueryDriver. |
| new-connection-sql |
Cannot be set; if set it is ignored. In order to set an initialization string, use the appropriate DataDirect XQuery connection property. |
| track-statements |
No statements are tracked. |
| prepared-statement-cache-size |
Should not be used in the context of DataDirect XQuery. Use DataDirect XQuery’s query pooling to maximize performance.
|
| transaction-isolation |
Cannot be set. In order to change the default transaction isolation use the appropriate DataDirect XQuery connection property.
|
See the Example: JDBC Connection Pooling Servlet for an example of implementing a JDBC connection pool in DataDirect XQuery®.
| 
