WebLogic 6 Data Sources Configuration

The follow configuration works with all our Oracle drivers.

  1. Start the console of the WebLogic Server with a shortcut or in the browser with: http://localhost:7001/console/index.jsp.
  2. Create a pool (in the node JDBC drivers) with the following characteristics:
    Name: OraclePool
    URL: jdbc:inetora:<HOST>:1521:<SID>
    Driver classname: com.inet.ora.OraDriver
    Properties: user=scott<enter>
                password=tiger


    Open the connections tab and verify that the min pool size is 2, the max pool size at least 10 and the increment is 2.

  3. Activate the pool in your target in the tab “Targets”.
  4. Create a data source with the following characteristics:
    Name: OracleDS
    JNDI Name: jdbc/Oracle
    Pool Name: OraclePool
  5. Activate the pool in your target in the tab “Targets”
  6. Add the jar file Auguro.jar to the classpath. Shut down the WebLogic Server, visit the start script of your application server configuration and add the file Auguro.jar to the end of the classpath

(for example wlserver6/config/examples/startExamplesServer.cmd – wlserver6 is located in the root of your weblogic installation directory).

  1. Start your application server again, it should now recognize the data source jdbc/Oracle. If you now create a mapping in weblogic-ejb-jar.xml:
    <resource-description>
        <res-ref-name>jdbc/DefaultDS</res-ref-name>
        <jndi-name>jdbc/Oracle</jndi-name>
    </resource-description>


    then your application can use this data source by calling:

    dbName = "java:comp/env/jdbc/DefaultDS";
    if(ic == null) ic = new javax.naming.InitialContext();
    javax.sql.DataSource ds = (javax.sql.DataSource) ic.lookup(dbName);

Known problems

  • If you get the error “resource not available”, please make sure that your pool size is large enough.
 

© Copyright 1996 - 2024, i-net software; All Rights Reserved.