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.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Microsoft SQL Server Express Edition

 Microsoft JDBC Driver for SQL Server

 Microsoft JDBC Driver - Query Statements and Result Sets

 Microsoft JDBC Driver - DatabaseMetaData Object

 Microsoft JDBC Driver - DDL Statements

 Microsoft JDBC Driver - DML Statements

 SQL Server - PreparedStatement

 SQL Server CLOB (Character Large Object) - TEXT

 SQL Server BLOB (Binary Large Object) - BLOB

 JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

JDBC-ODBC Bridge Driver - Flat Text Files

 JDBC-ODBC - Creating DSN for Flat Test File

JDBC-ODBC - Connecting to Flat Text Files

 JDBC-ODBC - Getting Flat File Driver Info

 JDBC-ODBC - CREATE TABLE in Flat Text Files

 JDBC-ODBC - Listing Tables with meta.GetTables()

 JDBC-ODBC - Tab Delimited Flat File Data

 JDBC-ODBC - ODBC Configuration for Flat Files

 JDBC-ODBC - Executing Queries on Flat Files

 JDBC-ODBC - Missing Flat Data Files

 JDBC-ODBC Bridge Driver - MS Access

 JDBC-ODBC Bridge Driver - MS SQL Server

 Archived Tutorials

 References

 Full Version in PDF/EPUB