Weblogic & Oracle

Discussions

EJB programming & troubleshooting: Weblogic & Oracle

  1. Weblogic & Oracle (7 messages)

    Hi
      When i start weblogic it says that

    "...Mon Mar 05 17:17:49 EST 2001:<E> <JDBC Pool> Failed to create connection pool "oraclePool"
    java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver .....".
    But ora\Jdbc\lib\classes111.zip is very much there in the classpath.
    In weblogic.properties file i set the parameters like this..
    "....weblogic.jdbc.connectionPool.oraclePool=\
         url=jdbc:oracle:thin:@tnt,\
         driver=oracle.jdbc.driver.OracleDriver,\....."

    What may be the reason.Can any one give solution urgently.
    Thanks,
    Rambabu.

    Threaded Messages (7)

  2. Weblogic & Oracle[ Go to top ]

    classes12.zip shall be in classpath
  3. Weblogic & Oracle[ Go to top ]

    can you send the full prop. file where you have specified the pool .
  4. Weblogic & Oracle[ Go to top ]

    If you use WebLogic Application Server 6.0 and Oralce 8.1.6 or 8.1.7. It should very simple.

    Actually if you set up your Oracle database properly. After you use your java.util.dbping Username password DatabaseURL to test connection successful, You get all the message back. You should able to connect to Oralce database.

    You should not do anything special if you understand how it works!

    I makes this connection work last weekend in Windows 2000.

    Contact me if you have problem... :)


    Bin Tan
    bin_tan at softworks dot com.au
  5. Weblogic & Oracle[ Go to top ]

    Hi Bin,
       At our development environment we are using ORACLE7.3 && WEBLOGIC5.1.%ORA_HOME%\Classes111.zip,Classes102 is very much there in the class path.Still facing the same problem.
    Thanks.
  6. Weblogic & Oracle[ Go to top ]

    Post your startWebLogic.cmd. This needs to include classes12.zip in the pre-classpath.
  7. Weblogic & Oracle[ Go to top ]

    put the oracle driver classpath into your
    "startWebLogic.cmd" file.
  8. Weblogic & Oracle[ Go to top ]

    Hi Rajiv,
    Here is the proerties(EJB Demo && JDBC) file.
    I tried by changing url,driver..etc,still the same problem _
    # THE WEBLOGIC PROPERTIES FILE
    # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
    # WEBLOGIC EJB DEMO PROPERTIES
    # -------------------------------------------------
    # CLUSTER USERS: Note that ALL EJB deployment should be done in the
    # *per-cluster* properties file ONLY.
    #
    # See WebLogic Demo Connection Pool below for a connection pool
    # to use with these examples.
    #
    # Deploys EJBeans. Uncomment the appropriate lines below and
    # modify DBMS-related info and paths to match your particular installation:

    weblogic.ejb.deploy=\
    c:/weblogic/myserver/hello.jar, \
            c:/weblogic/myserver/user.jar

    # C:/weblogic/myserver/hello.jar
    # C:/weblogic/myserver/ejb_basic_beanManaged.jar, \
    # C:/weblogic/myserver/ejb_basic_containerManaged.jar, \
    # C:/weblogic/myserver/ejb_basic_statefulSession.jar, \
    # C:/weblogic/myserver/ejb_basic_statelessSession.jar, \
    # C:/weblogic/myserver/ejb_extensions_finderEnumeration.jar, \
    # C:/weblogic/myserver/ejb_extensions_readMostly.jar, \
    # C:/weblogic/myserver/ejb_subclass.jar, \
    # C:/weblogic/myserver/jolt_ejb_bankapp.jar
    #
    # Servlet used by the EJB basic beanManaged example
    # Uncomment to use:
    #weblogic.httpd.register.beanManaged=\
    # examples.ejb.basic.beanManaged.Servlet
    #
    # Add a list of users (set the password with weblogic.password.[username]=XXX)
    # to set an ACL for this servlet:
    #weblogic.allow.execute.weblogic.servlet.beanManaged=user1,user2,etc
    #weblogic.password.user1=user1Password
    #weblogic.password.user2=user2Password
    # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
    # WEBLOGIC JDBC DRIVER PROPERTIES
    # ------------------------------------------------
    # Enables JDBC driver logging and sets the file name for the log
    # The weblogic.jdbc.logFile is placed in the per-server
    # directory (default is "myserver")
    weblogic.jdbc.enableLogFile=false
    weblogic.jdbc.logFileName=jdbc.log



    # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
    # WEBLOGIC JDBC CONNECTION POOL MANAGEMENT
    # ------------------------------------------------
    # CLUSTER USERS: Note that ALL JDBC connection pools should be set up
    # in the *per-cluster* properties file ONLY.
    #
    # For creating JDBC connection pools. This example shows a connection
    # pool called "oraclePool" that allows 3 T3Users "guest," "joe," and "jill"
    # to use 4 JDBC connections (with a potential for up to 10 connections,
    # incremented by two at a time, with a delay of 1 second between each
    # attempt to connect to the database), to an Oracle database server called
    # "DEMO." If more than 4 connections are opened, after 15 minutes, unused
    # connections are dropped from the pool until only 4 connections remain open.
    # Every 10 minutes, any unused connections in the pool are tested and
    # refreshed if they are not viable.

      weblogic.jdbc.connectionPool.oraclePool=\
           url=jdbc:oracle:thin:@206.34.212.247:1521:ORCL,\
           driver=oracle.jdbc.driver.OracleDriver,\
           loginDelaySecs=1,\
           initialCapacity=4,\
           maxCapacity=10,\
           capacityIncrement=2,\
           allowShrinking=true,\
           shrinkPeriodMins=15,\
           refreshMinutes=10,\
           testTable=dual,\
           props=user=web_data;password=web_password;server=tnt

    # Get more details on each argument for this property in the
    # Administrators Guide on setting properties at:
    # http://www.weblogic.com/docs51/admindocs/properties.html
    #
    # Set up ACLs for this connection pool with the following:
    #weblogic.allow.reserve.weblogic.jdbc.connectionPool.oraclePool=\
    # guest
    #weblogic.allow.reset.weblogic.jdbc.connectionPool.oraclePool=\
    # joe,jill
    #weblogic.allow.shrink.weblogic.jdbc.connectionPool.oraclePool=\
    # joe,jill
    #
    # This property is an ACL that specifies the users who can
    # create dynamic connection pools:
    #weblogic.jdbc.connectionPoolcreate.admin=joe,jill
    #
    # Read more about setting up and using connection pools in the
    # developers guide for WebLogic JDBC at:
    # http://www.weblogic.com/docs51/classdocs/API_jdbct3.html#T5a
    # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
    # WEBLOGIC DEMO CONNECTION POOL PROPERTIES
    # -------------------------------------------------
    # CLUSTER USERS: Note that ALL JDBC connection pools should be set up
    # in the *per-cluster* properties file ONLY.
    #
    # This connection pool uses the sample Cloudscape database shipped
    # with WebLogic. Used by the EJBean, JHTML, JSP and JMS examples.
    # Uncomment to use:
    #weblogic.jdbc.connectionPool.demoPool=\
    # url=jdbc:cloudscape:demo,\
    # driver=COM.cloudscape.core.JDBCDriver,\
    # initialCapacity=1,\
    # maxCapacity=2,\
    # capacityIncrement=1,\
    # props=user=none;password=none;server=none
    #
    # Add a TXDataSource for the connection pool:
    #weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.demoPool=demoPool
    #
    # Add an ACL for the connection pool:
    #weblogic.allow.reserve.weblogic.jdbc.connectionPool.demoPool=everyone
    # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

    Thanks.