processor.xsp.pool.database.foo.password=3Dmasterkey

processor.xsp.pool.database.foo.maxConnections=3D1

processor.xsp.pool.database.foo.expiryTime=3D3600000

# These are the supported = jdbc-drivers and their=20 adaptors.

# These properties are used by the=20 DBFactory.

processor.xsp.pool.database.adaptor=3DDBWeblogic,DBOracle,DBInst= antDB,DBPostgres,DBSybase,DBInformix,DBInterbase

processor.xsp.pool.database.adaptor.DBWeblogic=3Dweblogic.jdbc.p= ool.Driver

processor.xsp.pool.database.adaptor.DBOracle=3Doracle.jdbc.drive= r.OracleDriver

processor.xsp.pool.database.adaptor.DBInstantDB=3Dorg.enhydra.in= stantdb.jdbc.idbDriver

processor.xsp.pool.database.adaptor.DBPostgres=3Dpostgresql.Driv= er

processor.xsp.pool.database.adaptor.DBInformix=3Dcom.informix.jd= bc.IfxDriver

processor.xsp.pool.database.adaptor.DBSybase=3Dcom.sybase.jdbc.S= ybDriver

processor.xsp.pool.database.adaptor.DBInterbase=3Dinterbase.inte= rclient.Driver

This is my xml page:

<?xml version=3D"1.0"?>

<?cocoon-process = type=3D"xsp"?>

<xsp:page
= language=3D"java"
=20 xmlns:sql=3D"http://www.apache.org/1999/SQL"
=20 xmlns:xsp=3D"http://www.apache.org/1999/XSP/Core"
=20 xmlns:request=3D"http://www.apache.org/1999/XSP/Request"
>

<page title=3D"SQL Search=20 Results">
     <sql:execute-query>           =20 <sql:use-connection>foo</sql:use-connection>
  &= nbsp;        =20 <sql:skip-rows>0</sql:skip-rows>
    &= nbsp;      =20 <sql:max-rows>50</sql:max-rows>
    &n= bsp;      =20 <sql:null-indicator>y</sql:null-indicator>
  &nb= sp;        =20 <sql:count-attribute>BOB</sql:count-attribute>
  = ;         =20 <sql:doc-element>ROWSET</sql:doc-element>
  &nbs= p;        =20 <sql:row-element>ROW</sql:row-element>
   &= nbsp;       =20 <sql:tag-case>preserve</sql:tag-case>
   &n= bsp;       =20 <sql:id-attribute>ID</sql:id-attribute>
   =         =20 <sql:query>
        &nbs= p;     =20 SELECT ca_id,=20 ca_title
          &= nbsp;   =20 FROM = CATEGORY
           = </sql:query>
= </sql:execute-query>

</page>

</xsp:page>

and the the error I get is:

java.lang.VerifyError: (class: interbase/interclient/ErrorKey, = method:=20 _$372 signature: (Ljava/lang/String;Ljava/lang/String;I)V) Expecting to = find=20 unitialized object on stack
at=20 interbase.interclient.SQLException.(SQLException.java:65)
at=20 interbase.interclient.InvalidOperationException.(InvalidOperationExceptio= n.java:66)
at=20 interbase.interclient.InvalidArgumentException.(InvalidArgumentException.= java:54)
at=20 interbase.interclient.SQLDialectException.(SQLDialectException.java:51) at=20 interbase.interclient.RecvMessage.createSQLException(RecvMessage.java:689= )
at=20 interbase.interclient.RecvMessage.createSQLWarning(RecvMessage.java:704)<= BR> at=20 interbase.interclient.RecvMessage.makeSQLWarning(RecvMessage.java:578) at=20 interbase.interclient.RecvMessage.get_WARNINGS(RecvMessage.java:534)
&= nbsp;at=20 interbase.interclient.Connection._$126173(Connection.java:409)
a= t=20 interbase.interclient.Connection._$45044(Connection.java:331)
at= =20 interbase.interclient.Connection.(Connection.java:285)
at=20 interbase.interclient.Driver.connect(Driver.java:204)
at=20 java.sql.DriverManager.getConnection(DriverManager.java:517)
at = java.sql.DriverManager.getConnection(DriverManager.java:177)
at = org.apache.turbine.util.db.pool.DB.getConnection(DB.java:129)
at= =20 org.apache.turbine.util.db.pool.ConnectionPool.getNewConnection(Connectio= nPool.java:197)
at=20 org.apache.turbine.util.db.pool.ConnectionPool.getConnection(ConnectionPo= ol.java:153)
at=20 org.apache.turbine.util.db.pool.DBBroker.getConnection(DBBroker.java:161)=
at=20 org.apache.turbine.util.db.pool.DBBroker.getConnection(DBBroker.java:135)=
at=20 org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery(XS= PSQLLibrary.java:99)
at=20 _F_._Inprise._AppServer._html._public_html._sql._nuntio.populateDocument(= _nuntio.java:112)
at=20 org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
&= nbsp;at=20 org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:49= 4)
at=20 org.apache.cocoon.Engine.handle(Engine.java:359)
at=20 org.apache.cocoon.Cocoon.service(Cocoon.java:167)
at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at = com.sun.server.ServletState.callService(ServletState.java:226)
a= t=20 com.sun.server.ServletManager.callServletService(ServletManager.java:938)=
at=20 com.sun.server.ProcessingState.invokeTargetServlet(ProcessingState.java:4= 23)
at=20 com.sun.server.http.HttpProcessingState.execute(HttpProcessingState.java:= 79)
at=20 com.sun.server.http.stages.Runner.process(Runner.java:79)
at=20 com.sun.server.ProcessingSupport.process(ProcessingSupport.java:294)
&= nbsp;at=20 com.sun.server.Service.process(Service.java:205)
at=20 com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.j= ava:374)
at=20 com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.j= ava:166)
at=20 com.sun.server.HandlerThread.run(HandlerThread.java:192)

Anybody have any ideas. If I change the database url in = cocoon.properties=20 to point to a non-existant db file the error remains unchanged. I = thought the=20 error could be caused by passing an invalid dialect code on connection. = If this=20 is true, how to pass a valid one?

Regards

Neal Criscuolo

------=_NextPart_000_000C_01C05E09.D9073A20--