Re: [Sqlrelay-discussion] Cursor Error

[David M. <dav...@fi...>]

I recently put a fix in CVS that should fix this problem with MySQL.

A patch would be to modify src/connections/mysql/mysqlconnection.C and
change the openCursor method as follows:

bool mysqlcursor::openCursor(uint16_t id) {
    stmt=mysql_stmt_init(&mysqlconn->mysql);
    return sqlrcursor_svr::openCursor(id);
}

Give that a try, I think it will fix the problem.

David Muse
dav...@fi...

b-r...@ro... wrote:
> 	(This is a repost, since the original garnered no responses.)
>
> 	I've been working with the most recent version for a couple weeks,
> and for the most part, it functions quite well. However, periodically I
> get the following error:
>
> Failed to get a cursor id. A network error may have ocurred.
>
> 	Since I'm not going across the network, I know that is not the
> problem. However, there doesn't seem to be any other information out there
> on this error.
>
> 	The query (SELECT) itself is perfectly valid, and will execute if
> I simply rerun it. However, when it happens in a web script, an end user
> gets a script failure message on their browser, which isn't very elegant.
>
> 	My questions:
>
> 1) What is happening?
>
> 2) Is there a solution to the problem?
>
> 3) Is there a preferred kludge (such as checking for this specific error
> text and rerunning the query if found) if there is no solution? (I'm
> currently looping - if the error occurs, then I redo the query scratch.)
>
> 	Thanks.
>
> R
>
> ------------------------------------------------------------------------------
> Enter the BlackBerry Developer Challenge  
> This is your chance to win up to $100,000 in prizes! For a limited time, 
> vendors submitting new applications to BlackBerry App World(TM) will have
> the opportunity to enter the BlackBerry Developer Challenge. See full prize  
> details at: http://p.sf.net/sfu/Challenge
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com
>