If a Java EE client application accesses a database directly, you must provide the database drivers on the client machine, and configure the data source provider (JDBC provider) and data sources. Instead of accessing the database directly, it is recommended that your client application access the database through an enterprise bean.
WebSphere Application Server and the Application Client for WebSphere Application Server do not provide client database drivers to be used directly from a Java EE client application. You can contact your database vendor to get client database driver code and licenses.
Data sources configured on the server and looked up on the client do not participate in global transactions.
Instead of accessing the database directly, it is recommended that your client application access the database through an enterprise bean. This technique eliminates the need to have database drivers on the client machine, because the database access is handled by the enterprise bean running on WebSphere® Application Server. It also enables the client application to take advantage of the pooling and additional database functions provided by the server.
For a current list of data source providers that are supported on WebSphere Application Server, see the WebSphere Application Server prerequisite Web site.
In this information ... | IBM Redbooks, demos, education, and more(Index) |