CSV Configuration

CSV Configuration

    ...

    Properties info=new Properties();

    info.put(TextJDBC.SOURCE, TextJDBC.SOURCE_FILE);
    info.put(TextJDBC.TYPE, TextJDBC.TYPE_CSV);
    info.put(TextJDBC.COLUMN_NAMES, "name,last_name,amount");
    info.put(TextJDBC.COLUMN_TYPES, "String,String,Double");

    String sql="select last_name,name,amount from test 
        where (last_name starts with 'last name') 
        and ((amount==5) or (amount==12)) order by amount desc";    

    Class.forName(TextJDBCDriver.class.getCanonicalName());
    TextConnection con=(TextConnection)DriverManager.getConnection(url, info);
    PreparedStatement p=con.prepareStatement(sql);

    ...