#41 sql query crashes (sybase jconnect)

Squirrel SQL
closed-duplicate
Core (462)
5
2015-01-08
2002-06-20
Anonymous
No

Hi All,

When using sql-1.1beta4 version anytime that I execute
two sql queries sequentially

i.e. :
select * from TableName
<ctrl-enter>
select * from SecondTableName
<ctrl-enter>

Squirrel never returns any data for the second query
(the first returns just fine). If I hit the cancel
button, Squirrel freezes up and crashes. Both tables
are very small (each only has ~10 rows of data).

When I do the same thing using the 1.0final2 release
everything runs fine. It is very reproducable,
everytime I try the same result occurs.

On a side note, the final version of the client seems
very stable, and is great! Thanks so much for all of
your hard work.

Here is my config info:
- Sybase Database, using jconnect 5.5 as driver

Thanks again,
--Dennis

Discussion

  • Nobody/Anonymous

    Logged In: NO

    Just noticed that this is exactly the same situation that
    the user from bug report #565754 was having. I am running
    into the same problems that they were having.

    It seems like whenever you try to make a new SQL Query tab,
    it doesn't populate the result set.

    Any luck on this issue?
    Thanks,
    --Dennis

     
  • Colin Bell

    Colin Bell - 2002-07-02
    • assigned_to: nobody --> colbell
     
  • Colin Bell

    Colin Bell - 2002-07-02

    Logged In: YES
    user_id=233132

    Hi Dennis,

    Unfortunately 565754 was fixed by going to 1.1beta4.

    When it crashes do you get a stack trace either in standard
    output or in the squirrel log (in
    <home>/.squirrel-sql/logs)? If so could you attach it to
    this bug report.

    Which Java VM are you using?

    Col

     
  • Steven Bagshaw

    Steven Bagshaw - 2002-07-31

    Logged In: YES
    user_id=586995

    Hi,

    Just wanted to say I have a similar problem.

    Win 2000
    JDK 1.3.1
    Sybase ASE 12.5 - jconnect 5.5 driver
    Squirrel 1.1beta 5

    except I do not get anything at all when I run even a single
    SQL query. Hitting cancel doesn't do anything and I have to
    kill the program from Task Manager.

    If I browse the user tables and hit "contents" I can see all of
    the rows in the table successfully.

    Here's my log - the last line appears before this problem - I
    think it is when I initially connect, but everything else seems
    to work fine.

    Steve

    ---------------------------

    0 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    =============================================
    ==========
    0 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    =============================================
    ==========
    0 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    =============================================
    ==========
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    SQuirreL SQL Client Version 1.1beta5 started: Wed Jul 31
    11:26:31 EST 2002
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    Copyright (c) 2001 - 2002 Colin Bell
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    java.vendor: Sun Microsystems Inc.
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    java.version: 1.3.1
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    java.runtime.name: Java(TM) 2 Runtime Environment,
    Standard Edition
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    os.name: Windows 2000
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    os.version: 5.0
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    os.arch: x86
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    user.dir: C:\usr\Squirrel SQL Client
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    user.home: C:\Documents and Settings\steven
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    java.home: c:\usr\JBuilder6\jdk1.3.1\jre
    20 [main] INFO
    net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory -
    java.class.path: ;squirrel-
    sql.jar;lib\fw.jar;lib\log4j.jar;lib\nanoxml-
    2.1.jar;c:\sybase\ASEP_Win32
    \3pclass.zip;c:\sybase\ASEP_Win32
    \monclass.zip;c:\sybase\Sybase Central 3.2
    \java\swingall.jar;c:\usr\jdk1.1.8
    \lib\classes.zip;c:\sybase\jConnect-5_5\classes\jconn2.jar
    1492 [main] WARN
    net.sourceforge.squirrel_sql.client.db.DataCache - Could not
    find JDBC driver class for InstantDB:
    org.enhydra.instantdb.jdbc.idbDriver
    1502 [main] WARN
    net.sourceforge.squirrel_sql.client.db.DataCache - Could not
    find JDBC driver class for Oracle Thin Driver:
    oracle.jdbc.driver.OracleDriver
    1502 [main] WARN
    net.sourceforge.squirrel_sql.client.db.DataCache - Could not
    find JDBC driver class for InterClient:
    interbase.interclient.Driver
    1502 [main] WARN
    net.sourceforge.squirrel_sql.client.db.DataCache - Could not
    find JDBC driver class for Oracle OCI Driver:
    oracle.jdbc.driver.OracleDriver
    1502 [main] WARN
    net.sourceforge.squirrel_sql.client.db.DataCache - Could not
    find JDBC driver class for Mimer SQL: com.mimer.jdbc.Driver
    1502 [main] WARN
    net.sourceforge.squirrel_sql.client.db.DataCache - Could not
    find JDBC driver class for Microsoft MSSQL Server JDBC
    Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
    1502 [main] WARN
    net.sourceforge.squirrel_sql.client.db.DataCache - Could not
    find JDBC driver class for Sunopsis XML:
    com.sunopsis.jdbc.driver.xml.SnpsXmlDriver
    1512 [main] WARN
    net.sourceforge.squirrel_sql.client.db.DataCache - Could not
    find JDBC driver class for PostgreSQL: org.postgresql.Driver
    1522 [main] WARN
    net.sourceforge.squirrel_sql.client.db.DataCache - Could not
    find JDBC driver class for MMMySQL Driver:
    org.gjt.mm.mysql.Driver
    22903 [Thread-2] ERROR
    net.sourceforge.squirrel_sql.fw.sql.SQLConnection -
    java.lang.NoSuchMethodException

     
  • Colin Bell

    Colin Bell - 2002-08-15

    Logged In: YES
    user_id=233132

    I've made some changes which hopefully should fix this
    problem. These will be available in the next release
    1.1beta6 which should be out in about a weeks time.

    If they don't fix the problem there is a new option on the
    File menu called "Dump Application" I'd like you to run
    after you have opened a connection to the Sybase database.
    This will dump some of the internal structures of SQuirreL
    to a text file. Could you attach the text file to this bug
    report.

    Thanks
    Col

     
  • Colin Bell

    Colin Bell - 2002-08-26

    Logged In: YES
    user_id=233132

    1.1beta6 has just been released.

    Col

     
  • Brendan Grainger

    Logged In: YES
    user_id=4905

    Hi,

    I had the same problem with the jconnect 5.5 driver. Have you
    tried the jconnect 4.5 driver? I am not having the problem
    when I use that driver.

    I am using Squirrel 1.1 beta 6.

    Brendan

     
  • Colin Bell

    Colin Bell - 2002-09-13

    Logged In: YES
    user_id=233132

    I've finally got a copy of Sybase (11.0.3.3-2) and installed
    it on Linux last night along with jconnect 4.2 and
    everything seems okay. I'm going to try 4.5, 5.2 and 5.5 next.

    Its looking like the driver doesn't support having 2
    statements active at the same time on the same connection.
    Now that I've got a copy of Sybase I can start actually testing.

    Col

     
  • Colin Bell

    Colin Bell - 2002-09-16

    Logged In: YES
    user_id=233132

    Unfortunately I'm not able to duplicate your problems.
    Everything works for me with every version of jConnect.

    I did find a comment in an Internet search about the
    setMaxRows feature which could sometimes freeze jConnect.
    Could you try opening a connection to your Sybase server in
    Squirrel and before issuing any SQL (or displaying the
    contents of a table in the tree) go into the SQL tab in the
    session properties dialog (Session properties item on the
    Session menu) and uncheck both "Contents - limit rows" and
    "SQL - limit rows" and then try your queries.

    Col

     
  • Colin Bell

    Colin Bell - 2002-09-25
    • status: open --> closed-duplicate
     
  • Colin Bell

    Colin Bell - 2002-09-25

    Logged In: YES
    user_id=233132

    I'm going to close this bug as it is essentially a duplicate
    of 586371

     

Log in to post a comment.

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

Sign up for the SourceForge newsletter:





No, thanks