JDBC-ODBC - Tab Delimited Flat File Data

This section describes how to enter data in a flat text file as tab delimited columns.

To do further testing with the ODBC text file driver, I entered some data manually into two files in the directory connected to my DSN. My data is organized in columns with the tab character as the column delimiter.

1. C:\LOCAL\ODBC_FLAT_DB\User.txt:

ID	FirstName	LastName	BirthDate	AddressID
1	Christopher	Kleinerman	11-Aug-1989	5
2	Rosmarie	Kobylinski	01-Jul-1983	4
3	Alexander	Mendiola	12-Apr-1977	3
4	Danielle	Alexander	05-Nov-1979	2
5	R. Morgan	Van Houten	09-Sep-1985	1

2. C:\LOCAL\ODBC_FLAT_DB\Address.txt:

ID	StreetName	City
1	5 Baker Road	Bellevue
2	25 Bay St.	Hull
3	251 Main St.	W. York
4	99 Wade Ave	Paris
5	998 Forest	Portland

As you can see, these two files contain data for two related tables. The AddressID in the User.txt file links to the Address.txt file.

Last update: 2015.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Installing and Running Java DB - Derby

 Derby (Java DB) JDBC Driver

 Derby (Java DB) JDBC DataSource Objects

 Java DB (Derby) - DML Statements

 Java DB (Derby) - ResultSet Objects of Queries

 Java DB (Derby) - PreparedStatement

 MySQL Installation on Windows

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

 MySQL CLOB (Character Large Object) - TEXT

 MySQL BLOB (Binary Large Object) - BLOB

 Oracle Express Edition Installation on Windows

 Oracle JDBC Drivers

 Oracle - Reference Implementation of JdbcRowSet

 Oracle - PreparedStatement

 Oracle - JBDC CallableStatement

 Oracle CLOB (Character Large Object) - TEXT

 Oracle BLOB (Binary Large Object) - BLOB

 Microsoft SQL Server 2005 Express Edition

 Microsoft JDBC Driver for SQL Server - sqljdbc42.jar

 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

 Summary of JDBC Drivers and Database Servers

 Additional Tutorial Notes to Be Added

 Outdated Tutorials

 References

 PDF Printing Version