JDBC for SQL Server - Herong's Tutorial Examples - v3.14, by Herong Yang
JDBC-ODBC Bridge Driver - Flat Text Files
This chapter provides tutorial notes on using JDBC-ODBC Bridge to access data stored in flat text files. Topics include creating tab delimited data files; creating and configuring DSN for flat data files; running queries on flat 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
Takeaways:
Table of Contents
JDBC (Java Database Connectivity) Introduction
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
Using Connection Pool with JDBC
JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
►JDBC-ODBC Bridge Driver - Flat Text Files
JDBC-ODBC Bridge Driver - MS Access