Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#7 No Table browsing on Sybase ASE 12

closed
Colin Bell
None
5
2001-10-24
2001-10-16
Winston Ojeda
No

Setup:
- Squirrel SQL Client 1.0 production release
- Sybase Adaptive Server Enterprise/12.0.0.3/P/SWR 9646
- jConnect (TM) for JDBC(TM)/5.2(Build 20693)/P/EBF9007
- Java(TM) 2 Runtime Environment, Standard Edition
(build 1.3.1-b24)
- Java HotSpot(TM) Client VM (build 1.3.1-b24, mixed mode)

Can't seem to be able to browse user tables.
SQL and any other functions seem to to work OK. I can
even browse store procs. But 'Tables' leaf on the tree
is empty.
Message pane says:
com.sybase.jdbc2.jdbc.SybSQLException: '"'TABLE
'"' is not a valid type name.

Discussion

  • Colin Bell
    Colin Bell
    2001-10-17

    Logged In: YES
    user_id=233132

    I As part of the jConnect installation you should have run
    a script sql_server12.sql to create stored procedures to
    correctly return database metdata information. It sounds
    like this script wasn't run or an older version of it was
    used. Could you try rerunning this script and see if it
    makes a difference.

     
  • Colin Bell
    Colin Bell
    2001-10-17

    • assigned_to: nobody --> colbell
     
  • Winston Ojeda
    Winston Ojeda
    2001-10-17

    Logged In: YES
    user_id=351116

    It is my understanding that that script was run when ASE was
    first installed long time ago. I have checked
    sybsystemdb.procedures and infact there are at least 27
    sp_jdbc_... procs.
    Just want to point out that we also have a few other apps
    that make intensive use of jConnect and they all work fine.

    Thanks

     
  • Colin Bell
    Colin Bell
    2001-10-19

    Logged In: YES
    user_id=233132

    Can you please do the following.

    1. After shutting Squirrel down go to the .squirrel-sql
    directory within your user home (on Windows NT
    \winnt\profiles\<user_name>) and open prefs.xml in a text
    editor. Replace the entry <debugMode>false</debugMode> with
    <debugMode>true</debugMode>. Restart Squirrel and try
    browsing the tables again. When you get the error go to the
    file squirrel-sql.log in your .squirrel-sql directory and
    open it in a text editor. Scroll to the end and see if
    there is a stack trace and if so please paste it as a
    comment in this bug report.

    2. Click on the Database node in the object tree and
    display the metadata tab. Right click in the table and take
    the options Select All and Copy. Paste this data into a
    comment as well.

     
  • Winston Ojeda
    Winston Ojeda
    2001-10-19

    Logged In: YES
    user_id=351116

    My last reply blew up SourceForge, so I am including a file
    this time with your requested information.
    Let me know if you need anything else.
    BTW, I am running RH7.1 not Windoze ;)

     
  • Winston Ojeda
    Winston Ojeda
    2001-10-19

    Stack Dump

     
    Attachments
  • John Munsch
    John Munsch
    2001-10-19

    Logged In: YES
    user_id=37658

    I see this exact same error. My configuration is Windows
    2000 and there is an IBM AIX server running Sybase 12 or 12.5.

     
  • Colin Bell
    Colin Bell
    2001-10-22

    Logged In: YES
    user_id=233132

    From the stack trace it looks like jConnect is returning
    table types with trailing blanks E.G. "'TABLE '"
    (hopefully its isn't just formatting in the exception
    class). I've attached a modified version of Squirrel which
    will trim the blanks from the table types before it tries
    to use them. Could you untar squirrel-sql-test.tar.gz and
    replace your version of squirrel-sql.jar. Let me know if
    this works.

    If this doesn't work could you check standard output for
    Squirrel as this version should write out the table types
    and their lengths and paste them into this bug report.

     
  • Colin Bell
    Colin Bell
    2001-10-22

    Logged In: YES
    user_id=233132

    Okay, SF won't let me put up a file of this size. So... you
    can find the new version at
    http://www.users.bigpond.com/colbelloz/squirrel-sql-
    test.tar.gz

     
  • Winston Ojeda
    Winston Ojeda
    2001-10-22

    Logged In: YES
    user_id=351116

    OK. It works better. At least now I can see the tables ...but,
    there are still some errors dumped out and if I am supposed
    to be able to see the contents of the tables, I can't.
    Gut feel says is the quotes on the call for the table name.
    Check out the stack dump or below.

    Error in:
    com.bigfoot.colbell.squirrel.sessionsheet.objectstree.TablePanel$ContentsViewer
    com.sybase.jdbc2.jdbc.SybSQLException:
    "Processor"."dbo"."ExternalUpdate" not found. Specify
    owner.objectname or use sp_help to check whether the object
    exists (sp_help may produce lots of output).

    I am including another file with the whole STDOUT dump in
    case is of any help.

     
  • Winston Ojeda
    Winston Ojeda
    2001-10-22

    Logged In: YES
    user_id=351116

    SF puked the upload again.
    Trying for the second time.

     
  • Winston Ojeda
    Winston Ojeda
    2001-10-22

    Another Stack Dump

     
    Attachments
  • Winston Ojeda
    Winston Ojeda
    2001-10-22

    Logged In: YES
    user_id=351116

    Three times a charm.

     
  • Colin Bell
    Colin Bell
    2001-10-23

    Logged In: YES
    user_id=233132

    At least we're getting further.

    Can you confirm that Processor.dbo.ExternalUpdate is a
    valid db.owner.table on your system.

    If it is then what I suspect is happening is that the
    DatabaseMetaData.getIdentifierQuoteString() in jConnect is
    returning an incorrect value. I had a similar problem with
    the FreeTDS driver for MSSQL.

    I've uploaded yet another modified version of Squirrel at
    http://www.users.bigpond.com/colbelloz/alpha/squirrel-sql-
    test.tar.gz which should ignore the identifier quote string
    for jConnect. Give this one a go.

     
  • Winston Ojeda
    Winston Ojeda
    2001-10-23

    Logged In: YES
    user_id=351116

    Alright, this seemed to have done it!
    Thank you.
    All tables are browsable now and all tabs seem to be fully
    functional with the exception of RowId. In some tables, but
    not all, puts out this message:

    Error in:
    com.bigfoot.colbell.squirrel.sessionsheet.objectstree.TablePanel$RowIdViewer
    com.sybase.jdbc2.jdbc.SybSQLException: Attempt to insert
    NULL value into column 'DECIMAL_DIGITS', table '#bestinfo';
    column does not allow nulls. Update fails.

    Update? It isn't really trying to update anything on the DB
    is it ? ...Hope not. ;)

     
  • Colin Bell
    Colin Bell
    2001-10-24

    Logged In: YES
    user_id=233132

    Excellent (and what a relief).

    I'll be putting up another release tomorrow with this fix
    in as well as some Unix path fixes.

    Trust me, I'm not updating your database behind the
    scenes :) I took a quick look on DejaNews re the error
    message you're getting and a couple of other people have
    had similar problems. At a guess I'd say its an issue with
    the stored procedure that generates the RowID metadata.

    http://groups.google.com/groups?
    q=bestinfo+DECIMAL_DIGITS&hl=en&rnum=3&selm=A0DC550141AF7ED3
    0003D1A985256A57.0003D1BD85256A57%40webforums

    http://groups.google.com/groups?
    q=bestinfo+DECIMAL_DIGITS&hl=en&rnum=1&selm=3964932B.DBD036C
    6%40shift.co.za

    Thanks for your help getting Squirrel working with Sybase,
    its nice to cross another DBMS off the list. Give me a yell
    if you have any other issues or if theres some extra
    functionality you'd like to see.

    Col

     
  • Colin Bell
    Colin Bell
    2001-10-24

    • status: open --> closed