>Home>Learn XQuery>XQuery Examples>Connection Pooling>IBM WebSphere Application Server Print

Deploying DataDirect XQuery® on IBM WebSphere Application Server

This section describes the guidelines for deploying DataDirect XQuery® on an application server running IBM WebSphere Application Server V6.1.

1. Start the WebSphere Administrative Console.
2. Install DataDirect XQuery® in WebSphere.


1. Browse to Resources < JDBC < JDBC Providers, and choose Create a New JDBC Provider.

The Create a New JDBC Provider window appears.




2. Specify the following properties with the values shown here:
• Database type — "User-defined"
• Implementation class name — "com.ddtek.xquery3.jdbc.XQueryConnectionPoolDataSource"
• Name — "DataDirect XQuery JDBC Provider"
3. Click Next.

The Database Classpath Information window appears.




4. Specify all the DataDirect XQuery jar files; these files are in the \lib directory of your DataDirect XQuery installation.
5. Click Next.
6. Approve the information entered in the previous step.
7. Click Next to complete the JDBC provider definition.
8. Next, create a JDBC DataSource resource.
9. Browse to Resources < JDBC < Data Sources, and choose Create a New JDBC Data Source.

The Create a Data Source window appears.




10. Specify the following properties with the values shown here:
• Data source name — "DDXQExample"
• JNDI name — "jdbc/DDXQExample"
11. Click Next.

The Enter database specific properties for the data source window appears.




12. Select the Select an existing JDBC provider radio button, and choose "DataDirect XQuery JDBC Driver".
13. Click Next and confirm the information you have just entered.
14. Next, set the properties for the DDXQExample on the Data sources configuration window.




15. Specify "DDXQExample" in the Name field on the Configuration tab, and then choose Custom properties.

The Custom properties window appears.




16. Add the required data source properties.


3. Deploy the servlet by browsing to Applications < Install New Application, and choose to deploy DDXQServlet.ear .
4. Open your Web browser and point it to http://myserver:9080/DDXQServlet/.

Example

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