facebook

sort order for displayed tables of a db-connection

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #229772 Reply

    rateoty
    Member

    Hi,

    I have some connections which are established via oracle thin driver.
    when I open such a connection, I get a big heap of tables, which aren’t sorted (alphabetic order would be really nice..).
    Even more it seems, that lots of the tables are shown twice ore more, as I can’t imagine they do exist more than once in one schema.

    Is this a known bug, a new one or can I adjust this anywhere?

    Regards Jürgen

    #229796 Reply

    Riyad Kalla
    Member

    Can you please post all the information we request in the [URL=http://www.myeclipseide.com/PNphpBB2+file-viewtopic-t-393.html]Posting Guidelines[/URL] thread at the top of this forum? That will give us some context so that we can determine if this is an installation issue, a configuration problem, or a bug. Thanks.

    #229832 Reply

    rateoty
    Member

    soory, forgot that..

    >What operating system and version are you running?
    Windows 200 SP4
    >What Eclipse version and build id are you using? (Help > About Eclipse >Platform)
    Version: 3.0.2
    Build id: 200503110845
    >- Was Eclipse freshly installed for MyEclipse?
    no
    >- If not, was it upgraded to its current version using the update >manager?
    yes
    >- Are any other external plugins installed?
    yes
    >- How many plugins in the <eclipse>/plugins directory are like >org.eclipse.pde.*
    14
    >What MyEclipse version are you using? (Help > About Eclipse Platform > >Features)
    Version: 3.8.4
    Build id: 200501171200-3.8.4
    >What JDK version are you using to run Eclipse? (java -version)
    java version “1.4.2_07”
    >What JDK version are you using to launch your application server?
    1.4.2_07
    >What steps did you take that resulted in the issue?
    1) modified the drivers for Oracle OCI Driver
    point extra classpath to ojdbc14.jar
    2)create new database connection
    Driver: Oracle oci driver
    url:jdbc:oracle:thin:@localhost:12042:oms
    (since we’re using a ssh tunnel, it points to localhost)
    3)select “display default schema only”
    4)open connection
    5) click on “tables” in the schema
    >What application server are you using?
    bea weblogic 8.1 sp2
    >Are there any exceptions in the Eclipse log file? >(<workspace>/.metadata/.log)
    no

    regards Jürgen

    #229941 Reply

    Riyad Kalla
    Member

    Jurgen,
    I have filed this enhancement for us to look into later.

    #231161 Reply

    rateoty
    Member

    hello,

    as I encountered today, the problem was not a missing sort order. I connected to the database and checked “Display default schema only”. This has had no effect, as far as I can see – all schemas are shown, so lots of tables are shown more than once and one cannot see an alphabetical order.
    When I checked “Display the selected schemas” and there inserted only one schema, everything is fine – tables occur only once and in the expected order.
    Not sure, if the behaviour with default schema is a bug or just not what I thougt I understand.

    regards Jürgen

Viewing 5 posts - 1 through 5 (of 5 total)
Reply To: sort order for displayed tables of a db-connection

You must be logged in to post in the forum log in