I'm trying to connect to an Interbase 6.0 database using Turbine connection
pooling shipped with Cocoon 1.8 and I'm having problems.
The relevant 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/databa
se/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,DBPostgr
es,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.i
dbDriver
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 sql 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.j
ava:66)
at
interbase.interclient.InvalidArgumentException.(InvalidArgumentException.jav
a: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(ConnectionPo
ol.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(XSPSQ
LLibrary.java:99)
at
_F_._Inprise._AppServer._html._public_html._sql._foo.populateDocument(_foo.j
ava: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. Is this a
dialect code problem? Is there an effective way to debug/trace?
Regards
Neal Criscuolo
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
