To create an XA Connection Pool:

1. Log into the GlassFish Admin Console. To do this, right-click your application server node, in the Services window under Servers, and choose View Admin Console.

   You can also open the Admin Console from your web browser using the correct URL. For example: http://localhost:4848.

2. In the navigation tree, expand the following nodes: Resources -> JDBC.

3. Select Connection Pools, and in the right panel, click the New button.

4. Under General Settings, specify a name (such as bpelseDBXA).

5. Set the Resource Type to javax.sql.XADataSource.

6. Set the database vendor to the appropriate database vendor (Derby, Oracle or MySQL). Click next.

   

7. From the New JDBC Connection Pool (Step 2 of 2) window, under Connection Validation, enable Allow Non Component Callers.

8. Under Additional Properties, specify the following properties for your database:

   • Derby:

     • ServerName -> machine-name

     • DatabaseName -> DatabaseName: bpelseDB;create=true

     • User -> bpelse_user

     • Password -> bpelse_user

   • Oracle:

     • URL -> jdbc:oracle:thin:@machine-name:port:sid

     • User -> bpelse_user

     • Password -> bpelse_user

   • MySQL:

     • URL -> jdbc:mysql://machine-name:port/databasename

     • User -> bpelse_user

     • Password -> bpelse_user

   If you did not use the default values, make sure that the ServerName, User, Password and DatabaseName values are those that you specified when you created the database.

9. Click Finish. The new user and database are created.

10. Click the connection pool name and click the Ping button to verify your database connection.

11. Click Finish.