
Observations, corrections, additional information, and miscellaneous comments welcomed on App.net or Twitter. On OS X, I found that only the FBDriver with this (and one other, older-style and therefore not recommended) path setup worked successfully.
IDEA DATAGRIP VS INTELLIJ DRIVER
Note that the driver choice and path configuration both matter. Then specify valid values for the User and Password fields from your existing configuration of the database.Ĭlick the Test Connection button and make sure the configuration works. With an alias, you would instead have: jdbc:firebirdsql://localhost:3050/the_alias 1 A full path might look like this on Windows: jdbc:firebirdsql://localhost:3050/C:/my_project/the_database.db Under Database URL, specify jdbc:firebirdsql://localhost:3050/ followed by either the full path to the database in question or a corresponding alias. Under JDBC driver files, browse to the location where you extracted the Jaybird driver files and select jaybird-full-.jar. In IDEA, in the database view, add a new data source: in the Database view (accessible via a menu button on the right side of the screen), right click and choose New -> Data Source. The extracted folder should include a file named jaybird-full-.jar ( is currently 2.2.4). (You can check your Java version by running java -version at the command line.) Extract the downloaded zip file.
IDEA DATAGRIP VS INTELLIJ DRIVERS
Note that steps 1–3 are fairly obvious the real point of interest is in steps 4 and 5, which took me the longest time to figure out.ĭownload the latest version of the Firebird Java drivers for your operating system and your Java version. Steps to configuring a database correctly for use with IDEA/etc.
IDEA DATAGRIP VS INTELLIJ UPDATE
I will update the post if and when I have confirmed that it does. This was all done on OS X 10.9, so I also make no guarantees that this works on other platforms, though the likelihood that it behaves the same on Linux is fairly good. I have tested on P圜harm 3.1 to confirm that. The underlying details are consistent, but the interface has changed. Note: the following apply to IntelliJ IDEA 12 and the associated platforms, but not to the IDEA 13 platform, which made substantial changes to how databases are configured. These setup tools should be applicable to any of JetBrains’ other Java-based IDEs which include database support (e.g. P圜harm, RubyMine, WebStorm, etc.). Eclipse and P圜harm are not as good.Setting up IntelliJ IDEA’s built-in database tools to work with FirebirdSQL requires a particular setup configuration, which I’m documenting here for public consumption. Android Studio is Google’s official platform so developing there has advantages, but it isn’t as good with other languages like Java. Even so, it has a wide range of powerful plugins that enable you to work with other environments easily. While it has significant support for Android, Intellij does not compare to Android Studio’s IDE for this. Java, Kotlin, Groovy, and Scala are the languages it supports. However, it is designed for intelligently enabling easier use. When compared to P圜harm Eclipse, Intellij Idea is comparatively slow. IDEA also automates other time-consuming tasks. It makes it so that you won’t have to do all the routine work. The software offers a robust system for filling in the basic coding that your program needs, which is superior to Eclipse. Developing code for a project needs to be no harder than it should be and that is IDEA’s goal.
