Java Reference
In-Depth Information
Integrating NetBeans with a Third Party
RDBMS
NetBeans comes with built-in integration with the JavaDB RDBMS system.
Additionally, it comes with JDBC drivers for other RDBMS systems such as MySQL
and PostgreSQL, as well as the JDBC-ODBC bridge driver to connect to RDBMS
systems that don't natively support JDBC or for which a JDBC driver is not
readily available.
Although the JDBC-ODBC bridge allows us to connect to most RDBMS systems
without having to obtain a JDBC driver, it is usually a better idea to obtain a JDBC
driver for our RDBMS. The JDBC-ODBC bridge does not offer the best performance
and there are JDBC drivers available for the vast majority of RDBMS systems.
In this section, we will create a connection to HSQLDB, an open source
RDBMS written in Java, to illustrate how to integrate NetBeans with
a third party RDBMS. The procedure is very similar for other RDBMS
systems such as Oracle, Sybase, SQL Server, and so on.
Adding a JDBC Driver to NetBeans
Before we can connect to a third party RDBMS, we need to add its JDBC driver to
NetBeans. To add the JDBC driver, we need to right-click on the
Drivers
node under
the
Databases
node in the
Services
tab.
