This section describes how to run CREATE TABLE statement with the ODBC flat text file driver.
With my DSN, HY_FLAT, connected to an empty directory, I want to try to create a table
through JDBC-ODBC to see if the ODBC driver will create a file or not.
Here is my test Java program:
/**
* OdbcFlatCreateTable.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class OdbcFlatCreateTable {
public static void main(String [] args) {
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:HY_FLAT");
// Creating a database table
Statement sta = con.createStatement();
int count = sta.executeUpdate(
"CREATE TABLE User (UserID INT, FirstName VARCHAR(20),"
+ " LastName VARCHAR(20), BirthDate Date)");
System.out.println("Table created.");
sta.close();
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}
The above program gave me an exception:
Exception: [Microsoft][ODBC Text Driver] Cannot modify the design
of table 'User'. It is in a read-only database.
Ok. Microsoft ODBC Text Driver only manages flat text files as a read-only database.
