Categories
|
Apache
DBHelperVendor: Visit DBHelper Website Email: Website: http://ca.geocities....uo2003/dbhelper.html SourceCode: link Description:A productivity tool to help you work with databases inside IDEA. This tool is targeted on the Java developers,
who are also stored procedure developers. Key features include:
1) Adding two new file types IDEA can recognize:
a. SQL – The SQL script file
b. DIA – The database schema diagram file
2) Basic syntax highlighting – Supporting keywords, single line comments, /** **/ style multi-line comments, strings and number. The keyword is updated dynamically based on the database you are working with.
3) Code completion:
a. Supporting basic completion: Hit Ctrl + Space lists all the objects in the current database and narrows down as the user typing
b. Correlation name completion: When the user hits ‘.’, it will resolve the correlation name and pops up the suggestions, such as catalogs, schemas, table columns and stored procedures. It can also resolve SQL correlation name, temp tables, declared variables and parameters (works for SQL iAnywhere or ASE T-SQL format)
4) Run SQL script inside IDEA editor – At any time, the user can highlight a block SQL script or run the whole SQL script in IDEA editor and the result will show in the DBHelper output panel.
5) View Database schema as diagram – At any time, the user can select multiple tables or a type of tables and view the schema in a graphical diagram. The diagram can be saved as DIA format or copied as image.
6) Update table data – The user can view the data of any table and insert/delete/update the table data.
7) Support multiple databases via standard JDBC interface, tested databases are:
a. Sybase SQL Anywhere (tested on version 9.x)
b. Sybase ASE (tested on version 12.x)
c. MySQL (tested on version 5.x)
d. SQL Server (tested on version 2000)
e. Oracle (tested on 9i)
Extra database meta data can be supported by adding plugin jars to DBHelper (Implementing IMetaProvider interface, see ASA user meta extension sample)
8) It is designed to be extended using Velocity templates. (Velocity is an open source apache project for generating text content based on a simple template). Uses can add templates to generate customized content based on the database meta data, such as generating XML data based on resultset, or JDBC call to retrieve the resultset from the database. There are some templates come with this release as examples.
9) SQLConsole is newly added to support users that primarily don’t write lots of stored procedures and only want to run some simple queries inside IDEA. Users can open SQLConsole in DBOutput tool window and run any SQL queries. Of course syntax highlighting and SQL code completion are also available in the SQLConsole.
10) Query Manager: Users can create new or update queries in DBOutput tool window Saved Queries tab.
Recent change notes:1) Add Ctrl+Shift+Space for smart SQL completion 2) Add feature to copy database connection profile 3) Add feature to run any Velocity template 4) DBHelper can support editting sql files with different file extension, not just .sql. 5) Add feature to hide a database profile 6) Support the new IDEA 7.xGeneral usage instructions:The plugin zip file includes the documentation.Full documentation URL:
http://ca.geocities.com/davidhuo2003/dbhelper.html
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Comments:
Bad version number in .class file [Plugin: DBHelper]: Bad version number in .class file [Plugin: DBHelper]
com.intellij.diagnostic.PluginException: Bad version number in .class file [Plugin: DBHelper]
at com.intellij.openapi.components.impl.ComponentManagerImpl$ComponentsRegistry.a(ComponentManagerImpl.java:46)
I hope this gets fixed soon.
Plugin DBHelper failed to initialize and will be disabled: com/intellij/highlighter/custom/impl/CustomFileType
I hope this gets fixed soon.
Plugin DBHelper failed to initialize and will be disabled: com/intellij/ide/highlighter/custom/impl/CustomFileType
I keep getting the following error:
Plugin DBHelper failed to initialize and will be disabled: com/intellij/highlighter/custom/impl/CustomFileType
Seems like its a high level IntelliJ plugin architectural issue and its reported to Jetbrains
http://www.jetbrains.net/jira/browse/IDEA-15304
http://code.google.com/p/libraryfinder/issues/detail?id=11
Seems like its a high level IntelliJ plugin architectural issue and its reported to Jetbrains
http://www.jetbrains.net/jira/browse/IDEA-15304
http://code.google.com/p/libraryfinder/issues/detail?id=11
Seems like its a high level IntelliJ plugin architectural issue and its reported to Jetbrains
http://www.jetbrains.net/jira/browse/IDEA-15304
http://code.google.com/p/libraryfinder/issues/detail?id=11
Is this plugin opensource?
Where to get the latest source version?
Thank you for your quick response.
Also one more feature request:
It would be very convenient to save all filters (now on every prject open to see only intrested scheme I have to set table filter again).
Thanks a lot for it:)
But I constantly recieving message "ORA-01490: invalid ANALYZE command" by selecting any table (from keyboard or by mouse clicking) in the DB Tree. And due to popuping alert it's very dificult to select several tables:)
Plugin version - 1.1.0030
DB - Oracle 8i
Also some feautes request :))
Is any way to see table diagram only for few selected tables - not for whole schema? I'am selecting only 2 tables from list but geting all tables on diagram (but I suspect, this is only due to previous error).
Also it would be very usefull to be able to order (manualy, of course) tables by some tabs/packages/modules/etc (for example, like in Rational Rose), because it's very hard to understand diagram, when there are hundred tables on it :)
java.lang.NumberFormatException: For input string: "4294967295"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:459)
at java.lang.Integer.parseInt(Integer.java:497)
at oracle.jdbc.driver.OracleResultSetMetaData.getPrecision(OracleResultSetMetaData.java:331)
at dbhelp.db.model.ResultModel.loadResultSet(ResultModel.java:82)
at dbhelp.db.SQLCommander.createTableModel(SQLCommander.java:270)
at dbhelp.db.SQLCommander.execute(SQLCommander.java:243)
at dbhelp.db.SQLCommander$SQLRunner.run(SQLCommander.java:128)
at java.lang.Thread.run(Thread.java:595
I use a Oracle 9i DB.
I've put 4 stars because I never put 5 stars...
Some dialogs could be closed when pushing the escape key (like pushing the cancel button).
The user interface isn't ideal, which is the reason I'm not giving it 5 stars yet. It's a very 'technical' interface, not focused on usability and user-friendlyness.
I suggest you find an internet forum that focuses on user interfaces, and ask them to critique some screenshots and workflow descriptions.
jdbc:mysql://localhost/mysql
My input into making it better:
- Couldn't get started with it without reading help. Steps involved are totaly non-intuitive. I'd expect plugin setup to be where all Idea's plugin setups are. I'd prefer much easier database setup and more obvious interface.
And give me a way to name those databases! If I have 5 databases using same driver...
- Had to resize database information window to make it usable.
- I'd prefer standard Idea interface for adding databases (you know, the list, +, -, Copy etc.)
- switching between databases worked one time out of 10. All other times no message, nothing happens.
- couldn't make it show Mysql database structure at all. Queries worked though.
- generally I'd prefer much better error reporting. Throwing exeptions is much better than silently ignoring my actions! Exceptions could be fixed!
So many times I click something - and nothing happens.
Best luck with your plugin!
"The SQL Query Plugin has a more intuitive UI." --- ???
Could you give me more detail information so that I can improve DBHelper?
Do you mean it is hard to run SQL statement or something else? I need a little help here.
Especially dynamic creation of DB scheme)
Thanks.