Derby/JavaDB management in 11 - start, stop, browse tables, etc.
Hi Folks. Happily returning to IDEA (11.0.2) after a sabbatical, and I've started working with GlassFish (3.1.1) in the IDE. I'm able to run/deploy my app, but I noticed that IDEA does not automatically start Derby for my project, which I've set up with the JPA facet. I've found the Data Sources tab, and I know about the ij program, but does IDEA have a database management feature to start and stop the server, create and drop tables, etc? Thank you -- matt
Please sign in to leave a comment.
Hello.
There is no special support for starting and stopping a database. You can create some batch or shell scripts and configure external tools for them (see Settings / External Tools). I did so.
Accessing a database via SQL, and thus, creating-dropping-updating-querying tables is certainly supported. Keywords are "database console". See http://www.jetbrains.com/idea/webhelp/accessing-data-sources-via-the-database-console.html and around.
Regards,
Alexander.
Thanks, Alexander! I read your excellent online help last night, and got caught up on this. Much appreciated -- matt