cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Neal Criscuolo" <n...@wildpear.com>
Subject Interbase connection
Date Mon, 04 Dec 2000 21:49:55 GMT
I'm trying to connect to an Interbase database using connection pooling and I'm having problems.


My cocoon properties looks like this:

### Interbase FOO database
processor.xsp.pool.database.foo.driver=interbase.interclient.Driver
processor.xsp.pool.database.foo.url=jdbc:interbase://localhost/f:/foo/database/Foo.gdb
processor.xsp.pool.database.foo.username=sysdba
processor.xsp.pool.database.foo.password=masterkey
processor.xsp.pool.database.foo.maxConnections=1
processor.xsp.pool.database.foo.expiryTime=3600000

# These are the supported jdbc-drivers and their adaptors.
# These properties are used by the DBFactory.
processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantDB,DBPostgres,DBSybase,DBInformix,DBInterbase
processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver
processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.instantdb.jdbc.idbDriver
processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
processor.xsp.pool.database.adaptor.DBInformix=com.informix.jdbc.IfxDriver
processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver
processor.xsp.pool.database.adaptor.DBInterbase=interbase.interclient.Driver

This is my xml page:

<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<xsp:page
  language="java"
  xmlns:sql="http://www.apache.org/1999/SQL"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core"
  xmlns:request="http://www.apache.org/1999/XSP/Request"
>
  <page title="SQL Search Results">
     <sql:execute-query>
            <sql:use-connection>foo</sql:use-connection>
            <sql:skip-rows>0</sql:skip-rows>
            <sql:max-rows>50</sql:max-rows>
            <sql:null-indicator>y</sql:null-indicator>
            <sql:count-attribute>BOB</sql:count-attribute>
            <sql:doc-element>ROWSET</sql:doc-element>
            <sql:row-element>ROW</sql:row-element>
            <sql:tag-case>preserve</sql:tag-case>
            <sql:id-attribute>ID</sql:id-attribute>
            <sql:query>
               SELECT ca_id, ca_title
               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: _$372 signature: (Ljava/lang/String;Ljava/lang/String;I)V)
Expecting to find unitialized object on stack
 at interbase.interclient.SQLException.(SQLException.java:65)
 at interbase.interclient.InvalidOperationException.(InvalidOperationException.java:66)
 at interbase.interclient.InvalidArgumentException.(InvalidArgumentException.java:54)
 at interbase.interclient.SQLDialectException.(SQLDialectException.java:51)
 at interbase.interclient.RecvMessage.createSQLException(RecvMessage.java:689)
 at interbase.interclient.RecvMessage.createSQLWarning(RecvMessage.java:704)
 at interbase.interclient.RecvMessage.makeSQLWarning(RecvMessage.java:578)
 at interbase.interclient.RecvMessage.get_WARNINGS(RecvMessage.java:534)
 at interbase.interclient.Connection._$126173(Connection.java:409)
 at interbase.interclient.Connection._$45044(Connection.java:331)
 at interbase.interclient.Connection.(Connection.java:285)
 at interbase.interclient.Driver.connect(Driver.java:204)
 at 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 org.apache.turbine.util.db.pool.ConnectionPool.getNewConnection(ConnectionPool.java:197)
 at org.apache.turbine.util.db.pool.ConnectionPool.getConnection(ConnectionPool.java:153)
 at org.apache.turbine.util.db.pool.DBBroker.getConnection(DBBroker.java:161)
 at org.apache.turbine.util.db.pool.DBBroker.getConnection(DBBroker.java:135)
 at org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery(XSPSQLLibrary.java:99)
 at _F_._Inprise._AppServer._html._public_html._sql._nuntio.populateDocument(_nuntio.java:112)
 at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
 at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:494)
 at org.apache.cocoon.Engine.handle(Engine.java:359)
 at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
 at com.sun.server.ServletState.callService(ServletState.java:226)
 at com.sun.server.ServletManager.callServletService(ServletManager.java:938)
 at com.sun.server.ProcessingState.invokeTargetServlet(ProcessingState.java:423)
 at com.sun.server.http.HttpProcessingState.execute(HttpProcessingState.java:79)
 at com.sun.server.http.stages.Runner.process(Runner.java:79)
 at com.sun.server.ProcessingSupport.process(ProcessingSupport.java:294)
 at com.sun.server.Service.process(Service.java:205)
 at com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.java:374)
 at com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.java:166)
 at com.sun.server.HandlerThread.run(HandlerThread.java:192)

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

Regards
Neal Criscuolo

Mime
View raw message