This is the Turbine list. Please ask on the Cocoon list.
Frank
----- Original Message -----
From: "Neal Criscuolo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 05, 2000 7:56 PM
Subject: InterBase connection
> 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]
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
