JDBC-ODBC - Connecting to Flat Text Files

JDBC for SQL Server - Herong's Tutorial Examples

∟JDBC-ODBC Bridge Driver - Flat Text Files

∟JDBC-ODBC - Connecting to Flat Text Files

This section describes how to connect to a DSN that represents data stored in flat text files in a directory.

After created the DSN, HY_FLAT, to represent flat text files in a directory, Now I can try to connect my Java program to those flat text files through JDBC-ODBC Bridge and DSN using the DriverManager.getConnection() method:

DriverManager.getConnection("jdbc:odbc:dsn_name");

Here is my sample program showing you how to connect to text files defined behind a DSN with JDBC-ODBC Bridge:

/* OdbcFlatConnection.java
 * Copyright (c) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
public class OdbcFlatConnection {
  public static void main(String [] args) {
    Connection con = null;
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;

// Connect with a url string
      con = DriverManager.getConnection("jdbc:odbc:HY_FLAT");
      System.out.println("Flat files connection ok.");
      con.close();

    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}

The output confirms that the connection method worked correctly:

herong> progra~1\java\jdk1.7.0_45\bin\javac
   OdbcFlatConnection.java

herong> progra~1\java\jdk1.7.0_45\bin\java OdbcFlatConnection
Flat files connection ok.