IntelliJ IDEA 11: New and Noteworthy in Database Realm
There are many little things in database and SQL area that got attention in yesterday's IntelliJ IDEA 11 release but now I just want to highlight the major ones. Data Sources view got a new look and now includes stored procedures both from DDL scripts and real databases. The existing SQL dialects support has been redesigned with two new dialects introduced: H2 and MS Transact-SQL. So the list of
Find Table/Column Usages Searches Database Schema
In IDEA 10.5 "Find Usages" (Alt-F7) results for tables and columns include database schema usages, i.e. references in indices, primary and foreign keys, see screenshot below: Develop with pleasure!
Database Table Editor in IntelliJ IDEA 10
IntelliJ IDEA X features a simple database table editor and viewer. You can add and remove rows, sort by specific column and choose columns to display just by pressing F4 on a table in the Data Sources view. If you find the console-like way better than the GUI way, you can still run all those delete from... and insert into... statements in the Database console. Try this in the latest IntelliJ
Hibernate Criteria API Supported in IntelliJ IDEA X
Since IntelliJ IDEA X property names can be completed and navigated. Unrecognized properties are highlighted by the corresponding inspection. The screenshot says it all in a visual manner. Download IntelliJ IDEA X EAP build and try this feature.
Getting External Libraries Easily
JARs of many frameworks and their dependencies get updated too often now. But you do not want to turn your project into a Maven project just because of this? Then this feature is just for you. In IntelliJ IDEA 10 you can search for & download libraries with dependencies for any framework published on some public maven repository. Minimum Maven experience is required. Just click 'Attach Classe
Full-featured IntelliJ IDEA Editor for Injected Language Fragments
You probably know about IntelliJ IDEA's language injection feature. Right? IntelliJ IDEA X takes it even further. Now you can edit fragments of code injected in literals in a designated full featured editor with all your changes immediately reflected in the original code. You do not see all other code around the injected fragment. There's no need to worry about code escaping. No modal popups. J
JPA Console is Available in IntelliJ IDEA 10
In IntelliJ IDEA 10 a new JPA Console is added to existing Hibernate and Database consoles. Now you can run and test your JPA queries in a target environment of your application. Both Hibernate and JPA consoles are available if applicable. Note the new "Run Query in Console" Intention Action that is now available on all the supported types of queries: JPA QL, Hibernate QL and SQL. It allows you
Database Access Improved
The latest IntelliJ IDEA 9.0.2 EAP contains a big number of Database-related functionality changes: Database Console now has its own toolwindow New console-like UI that keeps input and output in one place and retains the highlighting for execution history Keyboard shortcuts for all Console actions are now configurable Per-result Page Up, Page Down and Refresh actions Complete support for In-
Drag’n’Drop in Database Diagram
Since IntelliJ IDEA 9.0.2 Database Diagram supports drag-and-drop for adding more tables to the view. The screenshot below shows the way to access the diagram if you somehow missed the What's New in 9.0 page. You can try this right now in the latest EAP.
JPA 2.0 Typesafe Criteria API and Annotation Processing Howto
Maia build subsystem now recognizes Java Annotation Processors. Most of JPA 2.0 implementations are expected to make use of the Pluggable Annotation Processing API to automatically generate static metamodel classes. Here is a list of steps required to generate JPA 2.0 metamodel and keep it up-to-date with Hibernate Static Metamodel Generator. For the simplicity in this sample project the processor
Find Action Saves Time
Instead of wasting your time searching the menus and toolbars in an attempt find out that action you need right now, use the Find Action command (Ctrl+Shift+A) to quickly locate what you need. It works just like Go to Class: