cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: Cocoon 1.7.4 SQL Processor with MS Access and Bean -> jdbc Error
Date Wed, 26 Jul 2000 20:25:20 GMT
On Wed, 26 Jul 2000, Dominik Enkelmann wrote:

> 1) accessing one or more jsp pages which access a bean with session-scope.
>    The bean opens a connection to an MS Access database (jdbc:odbc)and holds
>    it open until finalization.
> 
> 2) I switch from the jsp pages to a XML page which involves the SQL
> Processor
> 
> 3) The page fails with the following exception:
> 
> java.sql.SQLException: General error
> 	at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(Unknown Source)
> 	at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(Unknown Source)
> 	at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(Unknown Source)
> 	at sun.jdbc.odbc.JdbcOdbcConnection.close(Unknown Source)
> 	at
> org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.processQuery(XSPSQ
> LLibrary.java:222)
> 	at
> _C_._tomcat._webapps._protocol._protocolDisplay.populateDocument(_protocolDi
> splay.java:138)
> 	at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
>       ...
> 
> I found that the error only happens when the bean is connected to the
> database.
> But how can a indipendent opened connection influence the close() on the
> page's
> connection? Any ideas???

i'm afraid not. i would suggest that you try this methodology with a real
database and a real driver and see what you get - the sun jdbc/odbc driver
is infamous for having threading problems - to say nothing of access's
ability to support multiple connections simultaneously.

- donald


Mime
View raw message