In your web browser, log into the Sun Java System Application Server Administrator Console. For example:
http://localhost:4848, username:admin, password: adminadmin
Add Oracle JDBC driver classes to the application server classpath.
See the Sun Java System Application Server documentation for details on how to add the classes to the application server's classpath. One method is to navigate to Application Server > JVM Settings > Path Settings and specify the path to the jar file (including the jar file name) in the Classpath Suffix box. You must restart the application server before you continue.
In the navigation tree, expand the Resources -> JDBC nodes, and select Connection Pools.
In the right panel, click the New button.
Under General Settings, specify a name (such as bpelseDB).
Set the Resource Type to javax.sql.XADatasource.
Set the database vendor to Oracle and click Next.
Under Connection Validation, enable Allow Non Component Callers by selecting the Enabled check box.
Under Additional Properties, specify the URL, User, and Password, as follows.
You can use the following values, or choose your own for user, password and URL.
URL: jdbc:oracle:thin:@machine-name:port:sid
User: bpelse_user
Password: bpelse_use
Click Finish, click the connection pool name and click the Ping button.
This verifies your database connection.
Click Finish to prepare for creating a new JDBC resource.