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?

Try uncommenting the following

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

This should work.

Regards

Kumar

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