cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From o...@kompuart.pl (Leszek Gawron)
Subject Re: ESQL problem - current cocoon HEAD
Date Thu, 09 Jan 2003 09:48:48 GMT
On Thu, Jan 09, 2003 at 10:39:42AM +0100, Torsten Curdt wrote:
> Leszek Gawron wrote:
> >I'm using cocoon to communicate with MS SQL Server via MS JDBC driver (Java
> >1.3). After switching to current HEAD I get an error message that did not
> >exist in my previous version:
> >
> >org.apache.cocoon.ProcessingException: Exception in
> >ServerPagesGenerator.generate(): java.lang.RuntimeException: Error 
> >executing
> >statement:      select id, ope_opeid from gemini_users where device_id =
> >'ouzo'    : java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> >JDBC]0 is not a valid row parameter value for the ResultSet.Absolute 
> >method.
> >
> >Is this a bug or a matter of configuration?
> >        ouzo
> >
> 
> Do you use the limit feature?
No I don't.

Shouldnt JdbcEsqlQuery.getResultRows() look like this (just a guess - I'm not
experienced with jdbc):

public void getResultRows() throws SQLException {
    	if ( getSkipRows() > 0 )
        	getResultSet().absolute(getSkipRows());
        setPosition(getSkipRows());
    }

current version does not check getSkipRows() for zero equality

I'm checking that now but rebuild takes a lot of time
	ouzo
	
-- 
            __
         | /  \ |        Leszek Gawron            //  \\
        \_\\  //_/      ouzo@vip.net.pl          _\\()//_
         .'/()\'.     Phone: +48(600)341118     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message