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 JDBC DataSource Resource Configuration Options

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.

Example

See the Example: JDBC Connection Pooling Servlet for an example of implementing a JDBC connection pool in DataDirect XQuery®.

Prev: "Deploying on Tomcat"

Next: "Deploying on BEA WebLogic Platform"