#96 Problem retrieving result set for Sybase 12.5

Squirrel SQL
Core (461)
Jason Lin

Everytime when i try to submit a custom SQL using SQl
tab, it stays at "Building output..." prompt and never
goes anywhere? any help is appreciated.


  • Colin Bell

    Colin Bell - 2003-02-05
    • status: open --> open-rejected
  • Colin Bell

    Colin Bell - 2003-02-05

    Logged In: YES

    There is a known problem with some versions of
    Sybase/JConnect where setMaxRows will lock up the JDBC
    connection. Theres some info here

    Either change your version of jConnect (4.5 seems to work
    better than 5.5) or uncheck the "Contents - limit rows" and
    "SQL - Limit rows" check boxes in the SQL tab on the New
    Session Properties dialog.

  • Colin Bell

    Colin Bell - 2003-02-11
    • status: open-rejected --> closed-rejected
  • KosherJava

    KosherJava - 2003-03-05

    Logged In: YES

    I'm having the same problems.
    Just a suggestion, why dont you just loop the the RS 100
    times for Sybase istead of using setMaxRows ?

  • KosherJava

    KosherJava - 2003-05-30

    Logged In: YES

    Shouldnt there be a way of setting this per alias? When I
    use Sybase I do not want to limit the row numbers (if I do I
    am limited to one query before I freeze on the second one),.
    On the other hand when I open DB2 I would like to have the
    rows limited by default


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks