JDBC errors when running server - Roman book, WebLogic

Discussions

EJB programming & troubleshooting: JDBC errors when running server - Roman book, WebLogic

  1. I get the following error when running WebLogic server after installing and compiling
    the file from the Roman book per the instructions.
    <Thu Nov 16 15:27:21 PST 2000:<E> <JDBC Pool> Failed to create connection pool "ejbPool"
    Thu Nov 16 15:27:21 PST 2000:<E> <JDBC Pool> weblogic.common.ResourceException: weblogic.common.ResourceException:
    Could not create pool connection. The DBMS driver exception was:
    DriverManager failed with 'No suitable driver' while trying to create
    a Connection for the 'ejbPool' pool. This indicates that the URL, jdbc:cloudscape:ejbdatabase
    is not supported by the Driver COM.cloudscape.core.JDBCDriver
    <
    SETTING in env.bat file
    c:\ejb\ejbdatabase\ejb_sequence_jdbc.jar (fails)
    or
    c:\ejb\ejbdatabase (fails)
    or
    c:\ejb (fails)

    SETTINGS IN weblogic.properties file
    # JDBC Connection Pooling for our cloudscape database used in the EJB examples.
    # Also, add a security ACL for using the JDBC pool.
    weblogic.jdbc.connectionPool.ejbPool=\
           url=jdbc:cloudscape:ejbdatabase,\
           driver=COM.cloudscape.core.JDBCDriver,\
           initialCapacity=1,\
           maxCapacity=2,\
           capacityIncrement=1,\
           props=user=none;password=none;server=none
    weblogic.allow.reserve.weblogic.jdbc.connectionPool.ejbPool=guest

    java.system.property.cloudscape.system.home=c:/ejb (fails)
    or
    java.system.property.cloudscape.system.home=c:/ejb/ejbdatabase
    or
    java.system.property.cloudscape.system.home=
    c:/ejb/ejbdatabase/ejb_sequence_jdbc.jar (fails)

    What is the missing connection here?

  2. Try uncommenting the following

    # Add a TXDataSource for the connection pool:
    weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.demoPool=ejbPool

    This should work.

    Regards

    Kumar
  3. This didn't quite fix the problem. I'm not sure where I should insert the code you mentioned. See below.# EDROMAN
    # JDBC Connection Pooling for our cloudscape database used in the EJB examples.
    # Also, add a security ACL for using the JDBC pool.
    weblogic.jdbc.connectionPool.ejbPool=\
           url=jdbc:cloudscape:ejbdatabase,\
           driver=COM.cloudscape.core.JDBCDriver,\
           initialCapacity=1,\
           maxCapacity=2,\
           capacityIncrement=1,\
           props=user=none;password=none;server=none
    weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.demoPool=ejbPool,\
    weblogic.allow.reserve.weblogic.jdbc.connectionPool.ejbPool=guest

    If you or someone else has the code from Romans book and Weblogic server running correctly on Win2000, could you please send a working copy of the env file and the weblogic.properties file to: william dot blackmon at getmusic dot com

    Thanks,
    Bill