Hello,

We have a Connectio Pool defined for CloudScape. The connection pool is successfully created and we can see it in the Weblogic server5.1 with JDK1.2.

The weblogic.properties file consists of

#Connection Pool for CloudScape database for toursDB.
weblogic.jdbc.connectionPool.CloudscapeDBPool=\
       url=jdbc:cloudscape:CloudscapeDB,\
       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.CloudscapeDBPool=toursDBPool
#
# Add an ACL for the connection pool:
weblogic.allow.reserve.weblogic.jdbc.connectionPool.CloudscapeDBPool=everyone
#
# For servlet/Non-EJB JNDI look-up:
weblogic.jdbc.DataSource.CloudscapeDBDataSource=CloudscapeDBPool
#

Getting classcast exception with the following stmt(when it is called in the servlet).

javax.sql.DataSource ds = (javax.sql.DataSource ) jndiContext.lookup("CloudscapeDBDataSource");

The exception is as follows.
===========================
java.lang.ClassCastException
        at weblogic.certify.myservlet.GetCLAccountDetails(myservlet.java, Compil
ed Code)
        at weblogic.certify.myservlet.doGet(myservlet.java:103)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:105)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletCon
textImpl.java:742)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletCon
textImpl.java:686)
        at weblogic.servlet.internal.ServletContextManager.invokeServlet(Servlet
ContextManager.java:247)
        at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.jav
a:361)
        at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:261)

        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java, Compiled Code)