Child pages
  • DBHelper
Skip to end of metadata
Go to start of metadata

Please read the user guide and watch the flash demos!

    1. DBHelper Flash Demo - Browse Database MetaData
    2. DBHelper Flash Demo - SQL Code Completion
    3. DBHelper Flash Demo - View Database Schema Diagram
    4. DBHelper Flash Demo - New Database Profile
    5. DBHelper Flash Demo - Run SQL Script
    6. DBHelper Flash Demo - Overview
    7. DBHelper Flash Demo - Find Usages
    8. DBHelper Flash Demo - Copy Table Using Templates
    9. DBHelper Flash Demo - Using Query Manager
    10. DBHelper User Guide
  • No labels

13 Comments

  1. 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. The feature that you request is available in the latest build 10040. Try it. Thanks.

  2. 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. This is a good idea. I will work on this feature. Thanks.

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

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

  4. 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. 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. 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. 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. 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. Anonymous

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

    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. 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