In this chapter, we will cover:
- Setting up with MySQL
- Setting up with PostgreSQL
- Setting up with Apache Derby/Java DB
- Setting up with Oracle
- Setting up with Microsoft Access
- The built-in SQL editor
NetBeans provides a great deal of integration with different services including databases.
It is possible to configure the IDE to work with commercial and open source Databases; even competing products from other vendors come integrated with NetBeans out-of-the-box.
With the built-in SQL editor and SQL Explorer NetBeans, your basic SQL needs will be satisfied.
Going further, NetBeans itself comes with bundled drivers for both MySQL and PostgreSQL. If you wish to use Java DB during pre-production, or just a lightweight database is needed, configuring it with NetBeans is very easy. The driver for Java DB comes bundled with both GlassFish server and Java SDK 6.
However, let's not forget that it is also possible to configure the IDE with support for other drivers. In this chapter, we will configure NetBeans with Oracle Corporation Databases and Microsoft Access. This can be done by finding the vender-supplied JDBC driver.
Forget third-party tools, forget over complicated configurations. It is that easy.
It doesn't stop there either. NetBeans provides database integration with different development frameworks, such as JSF, Swing Application Framework, and JPA.