9 Replies Latest reply: Dec 3, 2010 10:24 AM by Brian Jeffries-Oracle RSS

    30EA2 - QueryBuilder not available

    user8102971
      Hi,
      QB is not available for me. I use 10g2. SQLD writes:
      "Text is not a valid, single SELECT statement.
      QB-ERROR: Parsing error:
      Failed to parse SQL query.
      Invalid SELECT statement.
      Unexpected token "select" at line 2, pos 1. - com.adbs.querybuilder.QueryBuilder.setSyncSQL(QueryBuilder.java:571)
      Query Builder disabled."
      Petr
        • 1. Re: 30EA2 - QueryBuilder not available
          Barry McGillin
          What are you doing for this? Can you paste the query you are trying in this?
          I've just tested on 10gr2 and it looks fine to me.
          Thanks
          B
          • 2. Re: 30EA2 - QueryBuilder not available
            user8102971
            Hi,
            I did'nt anything - only cliked to QueryBuilder tab...
            It must be some predefined query.
            Petr
            • 3. Re: 30EA2 - QueryBuilder not available
              user8768362
              Can you, sqldev developers, make, that the query builder parses the statement, which you have marked in the worksheet?
              • 4. Re: 30EA2 - QueryBuilder not available
                user8102971
                Hi,
                I haven't any select in worksheet. Error message appears without my interaction.
                Petr
                • 5. Re: 30EA2 - QueryBuilder not available
                  Brian Jeffries-Oracle
                  Hi Petr -

                  I have tested this on several different Oracle and third party databases and on both Linux and Windows(XP) and cannot replicate this.

                  I notice you said "I haven't any select in worksheet"

                  The work sheet and query builder are tightly coupled. Everything in the worksheet (selected or not) is passed to the query builder when you switch tabs. Do you have anything at all in the work sheet?

                  Future release will include extra detail in pop up error message so we can all see what QB is trying to parse.E.g.,
                  Text is not a valid, single SELECT statement.
                  Parsing error:
                  Failed to parse SQL query.
                  Invalid SELECT statement.
                  Unexpected token "select" at line 2, pos 1.
                  Query Builder disabled.
                  ----------------------------------------
                  select * from employees;
                  select * from departments;
                  
                  ----------------------------------------
                  Brian Jeffries
                  SQL Developer Team

                  Edited by: bjeffrie on Nov 30, 2010 4:20 PM (added signature)
                  • 6. Re: 30EA2 - QueryBuilder not available
                    Brian Jeffries-Oracle
                    We spent quite some time going around and around on how this should work and decided that keeping the work sheet and query builder locked in sync was the clearest approach.

                    That said, you can add this feature request to the SQL Developer Exchange. If it gets enough votes from the community, it could be added to an upcoming release.

                    If you do, please be precise on what should happen for as many use cases as possible. For example:
                    When going from the work sheet with nothing selected, does that mean QB should reset to 'empty' or should it remember its previous state?
                    When going from QB to the work sheet with nothing selected, does that mean QB SQL should be appended at the end of the document? Inserted at current cursor position?
                    When going from QB to the work sheet with something selected, does that mean the new QB SQL replaces the selection?
                    For error reporting, should line number be relative to the selection (2nd selected line) or the work sheet (9th line in editor)?
                    etc.

                    Brian Jeffries
                    SQL Developer Team
                    • 7. Re: 30EA2 - QueryBuilder not available
                      user8102971
                      Hi,
                      I understand this - if I wrote in Worksheet more than 1 select, this error appears. No select statement in worksheet was selected.
                      QueryBuilder works only if in Worksheet is 1 select statement.
                      I use Worksheet continuously whole day, I add continuously selects. In this case I can't use QueryBuilder, right?

                      One info on QB:
                      The table connectors (lines with arrows) in the QB are being displayed incorrectly as their endings do not touch the tables joined. They end somewhere in the middle of the way between the tables.
                      Petr

                      Edited by: user8102971 on 30.11.2010 23:15

                      Edited by: user8102971 on 30.11.2010 23:25

                      Edited by: user8102971 on 30.11.2010 23:32
                      • 8. Re: 30EA2 - QueryBuilder not available
                        Brian Jeffries-Oracle
                        Hi Petr -

                        Yes, if you want to have multiple select statements in the worksheet, then the query builder for that work sheet will not be usable.
                        You can, however, open a second work sheet to copy single queries to/from and use the query builder there.

                        Bug 10359393: AQB: LINE DRAWING ALGORITHM ISSUES
                        Steps to reproduce:
                        1. Drop two related tables on diagram
                        (E.g., employees, departments from hr)
                        2. Drag right hand border of left hand table to the left to make the box
                        narrower.
                        Issue 1: The link lines stop following the box edge at the point it starts
                        cutting off the longest field name.
                        3. Drag the lower right hand corner of the left hand table up to make a
                        scroll bar appear then right to cover the occurrences indicators on the link
                        lines.
                        Issue 2: The link line algorithm does not appear to take in to account the
                        scroll bar.

                        Brian Jeffries
                        SQL Developer Team
                        • 9. Re: 30EA2 - QueryBuilder not available
                          Brian Jeffries-Oracle
                          Bug 10359393: AQB: LINE DRAWING ALGORITHM ISSUES
                          Fixed. Will be in next release.

                          Brian Jeffries
                          SQL Developer Team