Adding Sybase JDBC driver to NetBeans 6.5

NetBeans 6.5 includes JDBC drivers for Postgresql and Mysql, two most popular opensource databases. Database integration in NetBeans is done is such way that it is possible to create database connection and use it in built-in SQL client or JPA modelling/programming.

In order to use databases more common in enterprise world, we need to add a JDBC driver to NetBeans.

In this example we will add and configure Sybase database connection.

We’ll use official Sybase driver, available from

http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect

Step 1. Open Services view and navigate to Databases -> Drivers

sybase-jdbc-1

Step 2. Right click on Drivers and select “New Driver…”

sybase-jdbc-2

Step 3. We will get dialog with information about new JDBC driver.

sybase-jdbc-3

Step 4. In the upper part of dialog, we’ll choose a .jar file that contains Sybase JDBC driver, in this case it’s name is jconn3.jar. After choosing .jar files, we need to press ‘Find’ button to list all classes that implement java.sql.Driver and we’ll choose com.sybase.jdbc3.jdbc.SybDriver. We’ll also give a name to the driver configuration.

sybase-jdbc-4

Step 5. Now we have a new driver installed. In order to use the driver, we need to create a database connection. Do the right click on new driver’s name and choose ‘Connect Using…’:

sybase-jdbc-5

Step 6. In this step we’ll provide database username and password. We can choose to save password. NetBeans help has more information about security of such action.

sybase-jdbc-6

Step 7. We need to provide JDBC url. It is vendor and driver specific – on the image bellow I used Sybase URL format:

sybase-jdbc-7

Step 8. We also need to choose a schema that we’re connecting to.

sybase-jdbc-8

We’re done! New Sybase connection is ready. It can be used in JPA applications or in built-in SQL client.

11 responses to “Adding Sybase JDBC driver to NetBeans 6.5

  1. Very Helpful. Many thanks

  2. Difficult to understand …..

  3. do you know if it works with jdk 1.6

  4. You can use
    com.sybase.jdbc.SybDriver in Driver Class

    • newsintegrator

      Hi,

      I remember that there was a reason to use com.sybase.jdbc3 package – was it related with XA transactions or something else, I don’t know exactly. I worked with Sybase only in J2EE/JEE context and it worked for me. I will try to find exact reason and post it here.

  5. Difficult to understand the schema part. When Database is already given using the URL, why do we have to select the schema?

  6. very usefull thanx

  7. Thanks, it was helpful for me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s