Oracle Waveset Installation

Create a JDBC Data Source

ProcedureTo Create a JDBC Data Source

  1. Expand the Services folder for the domain located in the navigation (left) pane.

  2. Expand the JDBC folder.

  3. Expand the Data Source folder.

  4. In the right pane (JDBC Data Sources), click Configure a new JDBC Data Source.

  5. Configure the JDBC Data Source as follows:




    Choose a unique name for this data source. This name is used as a reference throughout the WebLogic Console. For example, MyOraDataSource. 

    JNDI Name 

    Specify the JNDI name. This can be the same as the Data Source name. For example MyOraDataSource. 

    Honor Global Transactions  

    Select this check box (selected by default) if you want to enable global transactions using this data source (see WebLogic online help for more information concerning this option). In this example we keep the default. 

  6. Click Continue.

  7. Select the connection pool from part A. This allows an application to get a connection from the underlying connection pool.

  8. Click Continue.

  9. Select the servers on which you want deploy the new data source.

  10. Click Create.

    Note –

    The configuration steps are saved in your WebLogic config.xml file for a given domain. Changes to the XML file appear as:

    <JDBCConnectionPool DriverName="oracle.jdbc.driver.OracleDriver"
    Name="myOraConnPool" Password="{3DES}7Ne5r7/NaLfLyXYQGBHoYg=="
    Properties="user=myuser" Targets="myserver"
    TestTableName="SQL SELECT 1 FROM DUAL" URL="jdbc:oracle:thin:@my.hostname:1521:mydatabasename"/>
    <JDBCTxDataSource JNDIName="MyOraDataSource"
    Name="MyOraDataSource" PoolName="MyOraConnPool" Targets="myserver"/>