DBHelper

Skip to end of metadata
Go to start of metadata
Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
  1. Nov 03, 2006

    Anonymous

    I would like to request a feature. I'd like to be able to select a query from a properties file or java source file and paste it in the DBHelper editor window and have the tool remove all non-sql syntax from the text. For instance, from a java source file it would remove all double quotes, '+'s, '='s, etc... Also, something that would be really cool is if you could recognize parameters in the sql and popup a dialog when running the sql requesting values for the parameters. So, if the query has '?'s in it, when the sql is ran you would ask for values for all the '?'s and run the sql with those values.

    1. Nov 22, 2006

      The feature that you request is available in the latest build 10040. Try it. Thanks.

  2. Dec 01, 2006

    It would be nice if I could use SQL DDL as a source of database metadata: let me select a .sql file, parse all 'create table' statements, and use that for completion&validation.

    1. Dec 04, 2006

      This is a good idea. I will work on this feature. Thanks.

  3. Dec 01, 2006

    Another question: is the SQL support implemented using the new language API? Should I be able to inject it into other languages?

    1. Dec 04, 2006

      No. It is not because I want to make this plugin portal to other Java IDEs.

  4. Dec 12, 2006

    Anonymous

    Nice plugin!! Though I have a problem with the sql syntax completion. Indeed even when I untick "Use Full Object Name" and specify the database in the url, the autocomplete will fetch all the databases making it really time/memory consuming freezing my Idea.

    seb 

  5. Dec 29, 2006

    Anonymous

    2 comments:

    1) Nice to have: sql formatting.  You've already added the cleanup when pasting sql that may have non-sql characters in it (e.g. quotes and such), nice work.  It would also be nice to format the sql a bit, line stuff up so it is more readable.  Similar to what can be done for non-sql java code.

    2) Nice to have: show results in the split pane when doing an insert or update instead of (or in addition to) showing it in the output tab.

     Thanks.

    jason 

  6. Jan 10, 2007

    Congrats, very nice plugin!

    I would like wether the perfomance is going to get improved tho. Iwork on a very big database (1000+ Tables) and it keeps stopping the whole IDE when traversing in the DB tree.

    1. Jan 28, 2007

      Anonymous

      Which database are you using? Are these tables all under the same catalog or schema? If they're not, you can use filter catalog/schema on the database profile to improve the performance.

      1. Jan 30, 2007

        It's a IBM-DB2 Databasewith several Schemas. I tried adding filters but it doesn't seem to help at all. ( just right clicking to add the filter makes IDEA stop for about a minute)

  7. Oct 12, 2007

    Anonymous

    I really like this plugin, really helps to ease my life.

    I have a question regarding execution of several sql statements at once. I always get "wrong character" exceptions when trying to execute several statements divided by ";" at once. An example:

    drop sequence mapping_sequence;
    drop sequence order_key_sequence;
    CREATE SEQUENCE mapping_sequence START WITH 50000 INCREMENT BY 1 MINVALUE 1 NOMAXVALUE CACHE 20 NOCYCLE NOORDER;
    CREATE SEQUENCE order_key_sequence START WITH 200000 INCREMENT BY 1 MINVALUE 1 NOMAXVALUE CACHE 20 NOCYCLE NOORDER;

    Is there a way to execute such a script at once with DBHelper?

    Thank your for your help,

    Rick 

  8. May 24, 2008

    Anonymous

    Hi:

    I got the invalid  character in error message when execute the  error SQL , I am use postgreSQL8.3.1,and set the client encoding to UTF-8. so I think this problem may be is the encoding

    Then I want to got the source to build the plugins myself,but I can't find where to download the source of the plugin,I know the plugin is under Apache License and free to use. so is there any svn or cvs repository to checkout the source?

     Any suggestion would be appreciate!

     Thanks.

    ==================================== 

    hyysguyang

    email:hyysguyang@gmail.com