Posted on

Deploying a Weblogic DataSource at application Level

oracle weblogic book oracle weblogic books

Deploying an Oracle Weblogic Data Source at application level requires that you provide a file ending with –jdbc.xml suffix to your application, containing the Data Source definition. For example, if you are going to deploy your Data Source along with your EAR application, you will need to include the file newmodule-jdbc.xml file at the root of the EAR file. Here’s an Eclipse view of your application.

Continue reading Deploying a Weblogic DataSource at application Level

Posted on

Configuring Oracle Weblogic GridLink Datasource

oracle weblogic book oracle weblogic books

This Oracle Weblogic GridLink Data Source is an advanced high-availability solution which is specifically designed for Oracle RAC (Real Application Cluster).

In the earlier recipe we have learnt about the multi Weblogic Data Source option, which has the advantage to be a DB vendor agnostic solution; that being said, a multi Data Source has some limitations too.

Continue reading Configuring Oracle Weblogic GridLink Datasource

Posted on

Configuring Oracle Weblogic Multi Datasource

oracle weblogic book oracle weblogic books

An Oracle Weblogic Multi Data Source is an abstraction around a Data Source that provides load balancing or failover processing between the Data Sources associated with the multi data source. Oracle Weblogic Multi Data Sources are bound to the JNDI tree or local application context just like ordinary Data Sources are bound to the JNDI tree. Applications lookup a multi Data Source on the JNDI tree or in the local application context (java:comp/env) just like they do for Data Sources and then request a database connection.

Continue reading Configuring Oracle Weblogic Multi Datasource

Posted on

How to configure a Datasource with Oracle Weblogic

oracle weblogic book oracle weblogic books

Creating a Data Source using the Weblogic Console is the favorite choice for most developers.

1.       From the left panel, expand the “Services” tree option and choose “Data Sources”. The Summary page will display.

2.       From there, add a new Data source by choosing New | Generic Data Source.

oracle weblogic book oracle weblogic books

3.       In the next window, you will choose some basic properties for your Data Source such as the Name assigned to it, the JNDI name, used to retrieve the Data Source from your applications and the Database Type which we are connecting to:

oracle weblogic book oracle weblogic books

Once done, click Next. In the following screen you will select the JDBC Driver to be used for your database connections. For products like the Oracle SOA Suite, you will often need an XA driver.

Oracle WebLogic Server provides strong support for Oracle Real Application Cluster’s(RAC) features contained in Oracle Database 11g, minimizing database access time while allowing transparent access to rich pooling management functions that maximizes both connection performance and availability. Therefore if you are connecting to an Oracle RAC choose the Oracle Thin Driver for RAC.

oracle weblogic book oracle weblogic books

The WebLogic Type 4 JDBC drivers are installed with Oracle WebLogic Server in the<MW_HOME>/wlserver/server/lib folder. Driver class files are included in the Manifest’s classpath of weblogic.jar thus the drivers are automatically added to your classpath on the server.

If you selected an XA compatible driver, an intermediate screen will inform you that your data source will support global transactions and use the Two-Phase Commit to honor global transactions. Click Next to Continue.

Finally, in the following screen you will enter the Connection properties which will be used to set up your Data Source’s Connection pool. Provide the host name and the TCP port of the database, along with the database user name and password as shown by the following picture:

oracle weblogic book oracle weblogic books

The last screen will recap all the settings inserted so far and let you testing the database connection:

oracle weblogic book oracle weblogic books

Ok, now your Data Source has been added to the Data Source Summary screen. From there, we can define some specialized settings for our Data Source and target it to Weblogic servers. This is discussed in the next recipe.