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            //  \\
        \_\\  //_/      [EMAIL PROTECTED]          _\\()//_
         .'/()\'.     Phone: +48(600)341118     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]

Reply via email to