#328 2.1 final Oracle connection problem

2.1final
closed
Rob Manning
Core (461)
5
2006-01-20
2006-01-05
Alp Sehic
No

I'm trying to connect Oracle9i Enterprise Edition
Release 9.2.0.5.0 using Oracle JDBC driver 9.2.0.5.0,
so the process continues too long and SQuirrel can't
retrieve all the metadata (schemas, tables etc.), in
2.1 rc2 there were not such kind of problems, please
just check it out ...

Regards...

Discussion

  • Rob Manning
    Rob Manning
    2006-01-05

    • labels: 336290 --> Core
    • milestone: --> 2.1final
    • status: open --> pending
     
  • Rob Manning
    Rob Manning
    2006-01-05

    Logged In: YES
    user_id=1287991

    Yes, the behavior has changed in 2.1RC2 and 2.1final. Oracle
    has trouble with concurrent access to it's DatabaseMetaData.
    See this bug:

    https://sourceforge.net/tracker/index.php?func=detail&aid=1276957&group_id=28383&atid=393414

    So we have eliminated most concurrent access to
    DatabaseMetaData on the single connection. Obviously, this
    slows the down startup of the session window and most
    dramatically for Oracle. If you have a slow pipe (like a
    vpn) you may notice that it takes 30-60 seconds for the
    session window to appear (db schema object tree).
    During this time there are a number of database queries that
    are being done synchronously on the event thread. So the
    GUI looks like it's hung. This is another issue that we
    know about and are working on. For now, the best thing
    I can recommend to you is to get the latest JDBC driver and
    see if that helps connection time any. For me it has
    significant speedup. In my case I use the 10g driver
    against an Oracle 9i database server and it works great.

    Rob Manning

     
    • status: pending --> closed
     
  • Logged In: YES
    user_id=1312539

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).