+ Reply to Thread
Results 1 to 2 of 2

SQL State=HY010 "Function Sequence error"

  1. SQL State=HY010 "Function Sequence error"

    Our jdbc code throws the SQL State = HY010 Function Sequence Error every once
    in a while. It happens while we are running high volume tests. In other
    words many interations of the same code simultaneously. We know the code
    works, so what's different about high volume? We are using jtds with the
    prepareSQL property set to the value of 2, which uses the sp_executesql
    stored proc to prepare
    and execute statements.

    Can anyone shed some light on what this error means and make some
    recommendations on how to avoid it?

  2. Re: SQL State=HY010 "Function Sequence error"

    I've seen something similar to this before with the old ODBC drivers. If I
    recall correctly, it occurred when the parameters were bound incorrectly or
    an attempt was made to execute the SQL statement before the parameters were
    bound. I also ran into this error when using the bulk copy API, although I
    can't recall the exact circumstances. Haven't one anything with JDBC, but
    you might be encountering a similar issue; it might be an issue with your
    JDBC drivers. I'd check to see if there's a patch or service pack available
    for your JDBC drivers - it might be a known issue.

    "Dave Michaud" Michaud@discussions.microsoft.com> wrote in message
    news:8B0384ED-DA6C-453B-AE7C-F57579788A70@microsoft.com...
    > Our jdbc code throws the SQL State = HY010 Function Sequence Error every
    > once
    > in a while. It happens while we are running high volume tests. In other
    > words many interations of the same code simultaneously. We know the code
    > works, so what's different about high volume? We are using jtds with the
    > prepareSQL property set to the value of 2, which uses the sp_executesql
    > stored proc to prepare
    > and execute statements.
    >
    > Can anyone shed some light on what this error means and make some
    > recommendations on how to avoid it?




+ Reply to Thread