Connecting Netbeans to your Data Base

At this post we are going to see how to connect Netbeans IDE to your Database. In my case I work over Oracle SGBD, then I will access to this SGBD.

We will use the JDBC standar, java based for remote DDBB connections purposes.

Let’s see two base links for the purpose of this post::

  • This is a Netbenas wiki post where are written links to all SGBD drivers supported. Then, if you are searching for PosgreSQL, MySQL, M$, DB2,.. you can try it.
  • Here we have the Oracle JDBC driver. I can afirm that it would run for any Oracle version up to 9i.

In the second link I downloaded the driver in the file: ojdbc14.jar. The installation is at the tab Services –> clicking the right mouse button over Drivers –> New Driver …

We look for the driver downloaded in our system, and install it.

To create a new connection, we will do at tab Services –> clicking the right mouse button over DataBases –> New Connection …

We must make our connection URL with the following model:

jdbc:oracle:thin:@{HOST}:{PORT}:{SID}

You can probe the connection making queries in the front window:

Obviously, with a JDBC preinstalled in Netbeans as MySQL driver, would be easier create a connection. You can see a MySQL example at the image:

One thought on “Connecting Netbeans to your Data Base

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>