Test data sample in test1.txt:

ID	FIRST_NAME	LAST_NAME	SEX	COUNTRY	PROVINCE	CITY	STREET_NAME	STREET_NAME2	POSTCODE

232503	Tom	Cat	M	US	NJ	NJ	9 Wall Rd		1001

232504	Tom2	Cat2	M	US	NJ	NJ	9 Wall Rd		1001



Test code in testText17.java:

import java.sql.*;

import java.util.Properties;



public class testText17 {



    public void run() throws Exception {

        Connection oDBCon;

        PreparedStatement oStmt;

        ResultSet oRS;

        Properties oProperties;



        // Connect.

        System.out.println(new java.util.Date() + " connecting");

        oProperties = new Properties();

        oProperties.put("_CSV_Header", "true");

        oProperties.put("_CSV_Separator", "\t");

        oProperties.put("_CSV_Quoter", "");

        oProperties.put("charSet", "UTF-8");

        Class.forName("com.hxtt.sql.text.TextDriver");

        oDBCon = DriverManager.getConnection("jdbc:csv:/C:/Temp", oProperties);

        oDBCon.setAutoCommit(false);



        // Query text file.

        System.out.println(new java.util.Date() + " selecting data");

        //oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\"");

        oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\" WHERE ID IN(232503, 232788, 232679)");

        //oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\" WHERE ID >= '232503' AND STREET_NAME LIKE '%straat' ORDER BY ID");

        for (int nIndex = 1; nIndex <= oStmt.getMetaData().getColumnCount(); nIndex++) {

            System.out.println(oStmt.getMetaData().getColumnName(nIndex));

        }



        oRS = oStmt.executeQuery();

        while (oRS.next()) {

            System.out.println(oRS.getString(1) + " " + oRS.getString(2) + " " + oRS.getString(3) + " " + oRS.getString(4) + " " + oRS.getString(5) + " " + oRS.getString(6) + " " + oRS.getString(7) + " " + oRS.getString(8) + " " + oRS.getString(9) + " " + oRS.getString(10));

        }

        oRS.close();

        oStmt.close();



        System.out.println(new java.util.Date() + " updating data");

        // oStmt = oDBCon.prepareStatement("UPDATE \"test1.txt\" SET STREET_NAME = 'XXX' || STREET_NAME || 'XXX' WHERE ID IN(232503, 232788, 232679)");

        oStmt = oDBCon.prepareStatement("UPDATE \"test1.txt\" SET STREET_NAME = CONCAT('XXX', STREET_NAME) WHERE ID IN(232503, 232788, 232679)");

        oStmt.executeUpdate();

        oStmt.close();



        System.out.println(new java.util.Date() + " selecting updated data");

        oStmt = oDBCon.prepareStatement(

            "SELECT * FROM \"test1.txt\" WHERE ID IN(232503, 232788, 232679)");

        oRS = oStmt.executeQuery();

        while (oRS.next()) {

            System.out.println(oRS.getString(1) + " " + oRS.getString(2) + " " +

                               oRS.getString(3) + " " + oRS.getString(4) + " " +

                               oRS.getString(5) + " " + oRS.getString(6) + " " +

                               oRS.getString(7) + " " + oRS.getString(8) + " " +

                               oRS.getString(9) + " " + oRS.getString(10));

        }

        oRS.close();

        oStmt.close();



        //oDBCon.commit();



        // Disconnect.

        System.out.println(new java.util.Date() + " disconnecting");

        oDBCon.close();

    }



    public static void main(String argv[]) {

        try {

            new testText17().run();



        }

        catch (SQLException sqle) {

            do {

                System.out.println(sqle.getMessage());

                System.out.println("Error Code:" + sqle.getErrorCode());

                System.out.println("SQL State:" + sqle.getSQLState());

                sqle.printStackTrace();

            }

            while ( (sqle = sqle.getNextException()) != null);

        }

        catch (Exception e) {

            System.out.println(e.getMessage());

            e.printStackTrace();

        }

    }

}