SQL Query Plugin
- Multiple open queries
- Load and save queries
- Editing of search results
- Support for creating URLs
- Connection properties saved in project workspace
- Export of results into XML, HTML or CSV files
- Browser for database structure (includes data types, procedures, functions, tables)
- Viewer for CLOB and BLOB values
- Show primary key columns in different color if supported by JDBC driver
- Save password options (requires installed SunJCE)
- Syntax highlighting
- Use of Variables in queries
- Show columns in different formats and fonts
- Possibility to add custom formats
- Group databases
- Tested for IDEA 657+
- Download zip file and copy the include jar file to IDEA_HOME\plugins\ks-sql\lib
- Copy JDBC driver (preferable JDBC 2.0 compatible driver) into IDEA_HOME\plubins\ks-sql\lib\ OR (presumably for recent versions of IDEA and/or the plugin) go into the plugin's settings, click the Miscellaneous tab, and add drivers via the GUI
The plugin was tested on the following databases. Feel free to update this list.
| Database | JDBC driver | Status | Description |
|---|
| Oracle 8+ | Oracle Thin driver | Ok | |
| MySQL 3.2x | Connector/J 2.x/3.x | Ok | |
| Sybase | jConnect 5.5 | No | Error during 'select' statements |
| DB2 7.2.5 | | Ok | |
| DB2 8.1 | | Ok | |
| MS SQLServer 2000 | iNet Opta 2000 driver | Ok | |
| Informix | | Ok | |
| MS Access | JDBC-ODBC bridge | Ok | No database metadata |
| Firebird v1.0.2 | FirebirdSQL (JayBird) | Ok | |
| Documentum | JDBC eConnector | kinda | works if your query does not use "repeated attributes" |
| PostgreSQL 7+ | | Ok | |
| DB2/400 | jt400 | Ok | tested with pre 1.0.8 |
| Cloudscape | Cloudscape RMI driver | OK | |
| Teradata | NCR Type 4 | Sort of | Queries work, schema browsing does not |
| HP Image | Minisoft | Ok | |
- Changes from version 1.3.6 to 1.3.7
- Added driver for AS/400 and Informix
- Allow refresh of result tables
- Changes from version 1.3.5 to 1.3.6
- Added driver for Postgresql
- Fixed default schema named for MySQL? and SQLServer
- Changes from version 1.3.4 to 1.3.5
- Browser:
- Prepend schema name if selecting tables within other schemas
- Show query text as tooltip of result tab
- Changes from version 1.3.3 to 1.3.4
- Bugfixes:
- Bugfix for 100% CPU usage during editing
- Added possibility to display columns in other fonts
- Remember selected formats, fonts, sort columns for last statements (option to save the information to the workspace)
- Sort database groups
- Convert all oracle.sql.Datum values to JDBC values
- Changes from version 1.3.1 to version 1.3.3
- Bugfixes:
- NPE if editing table cells
- Removed duplicate procedures
- Show procedure parameters
- Don't show 'Indices' node for tables of type 'VIEW'
- Changes from version 1.3.0 to version 1.3.1
- Bugfixes:
- NPE with DB2 databases
- State of browser window
- Use column format for 'Copy to Clipboard' action
- Browser:
- Performance improvement for loading tables
- Group tables by table type
- Show procedures, functions and types
- Result Table:
- Enabled sorting for more than one column
- Convert oracle.sql.TIMESTAMP into java.sql.Timestamp
- Added API for adding custom column formats
- Use user name for default schema
- Made describe case insensitive
- Show value of Auto-Commit in status bar
- Distinguish between 'Empty password' and 'No password'
- Possibility to execute statement without parsing
- Changes from version 1.2.3 to version 1.3.0
- Changed structure of data in workspace
- Fixed bug: Opening dialogs outside of event thread
- Added database groups
- Moved database browser into separate tool window
- Save queries into workspace
- Copy query parts from browser window to query window
- Show update statements in message tab if editing a result table
- Confirmation dialogs for 'Commit', 'Rollback' and 'Close all connections'
- Changes from version 1.2.2 to version 1.2.3
- Bugfix for in some cases not displayed result table
- Changes from version 1.2.1 to version 1.2.2
- Bugfixes
- Enabled Character Encoding for MySQL driver (Thanks to Sergey Bervinov)
- Display strings in different encodings
- Changes from version 1.2.0 to 1.2.1
- Bugfixes
- Added driver for Firebird database (Thanks to Sergey Bervinov)
- Changes from version 1.1.0 to 1.2.0
- Bugfixes
- Configurable String to indicate NULL values
- Load BLOB objects if class is located in project classpath
- Option to save passwords as free text
- Possibility to calculate column sums
- Use of variables in queries
- Improved copying of Java source strings
- Changes from version 1.0.10 to 1.1.0
- Bugfix for Sybase FAKE_METADATA
- Result Table:
- Changes from version 1.0.9 to 1.0.10
- Bugfixes for metadata
- Result Table:
- Option to display dates with time
- Fit columns to data and/or header
- Query Panel:
- Display multiple results
- Rename queries
- Changes from version 1.0.8b to 1.0.9
- Bugfixes
- Connections:
- Default option for auto-commit
- Query:
- Syntax highlighting for editor pane
- Result Table:
- Context menu with 'Copy to Clipboard' and 'Mark as primary key column'
- IDEA Editor:
- Added action in editor popup 'Send to SQLPlugin'
- Changes from version 1.0.7b to 1.0.8b
- Bugfixes
- ResultTable:
- Editing of table and writing back to database
- Commit button, Rollback button
- Configurable if primary keys columns should be highlighted
- Configurable number of rows loaded
- Query:
- Take back partial execution option
- Execute queries in separate thread
- Add option to cancel queries
- Support keyword 'describe'
- Driver:
- Support for JDBC-ODBC Bridge
- Support for Microsoft SQLServer
- Support for Sybase
- Option 'Auto-Commit' configurable
- Browser:
- Configuration:
- 'Save Password' option for all connections
- Changes from version 1.0.6b to 1.0.7b
- Bugfixes
- Main:
- Button to refresh all connections
- Connection properties:
- 'Save Password' option (requires Sun-JCE)
- Result table:
- Viewer for CLOB and BLOB (Java objects) values
- Show primary key columns in different color (MySQL only)
- Queries:
- Execute selected text only
- Save and load queries
- Export:
- Align items in HTML export
- Save last export path
- Drivers:
- Modified MySQLDriver to work with older versions of MySQL Connector/J
- Added support for other drivers
-- StefanStiller - 05 Mar 2004
|
|
