View RSS Feed

My Java Tips

  1. Using PostgreSQL JDBC driver

    by , 11-12-2011 at 05:45 PM (My Java Tips)
    PostgreSQL is a popular open source object-relational database management system that is being used for small and medium sized applications. We have two options to connect to PostgreSQL. One is to use odbc/jdbc connection and the other is to use PostgreSQL JDBC driver. In this post, I will write about how to use PostgreSQL JDBC driver to connect to PostgreSQL database.


    First of all, you will need PostgreSQL database driver. It can be downloaded from
    http://jdbc.postgresql.org/download.html ...
    Categories
    JDBC
  2. Types of JDBC drivers

    by , 11-11-2011 at 05:44 PM (My Java Tips)
    There are 4 different types of JDBC drivers that can be used in Java database applications. Which driver to use, depends on the requirements and available resources. I will briefly talk about each driver.


    Type 1 is JDBC-OBC bridge driver. It is pure Java and is include in java.sql.*. The client needs ODBC driver manager and ODBC driver for data source. It is ideal in situations, when ODBC driver is available for the database and is already installed on the client machine.
    ...