java +mysql LOAD DATA INFILE mysql中执行正常，java报错？？？

Question

LOAD DATA INFILE '/txt/test.txt' INTO TABLE test LINES TERMINATED BY '\r\n'
java.sql.SQLException: Could not retrieve transation read-only status server
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:877)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:873)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3603)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3572)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:759)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739)
at LoadDateFile.main(LoadDateFile.java:45)
Caused by: java.sql.SQLException: Unknown system variable 'tx_read_only'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3597)
... 4 more

            public static void main(String[] args) {

    try {
        //System.out.println("start;");
        Class.forName("com.mysql.jdbc.Driver");
        //System.out.println("com.mysql;");
        conn = DriverManager.getConnection(url,user,password);
        System.out.println("conn:");
        stmt = conn.createStatement();
        // System.out.println("load date infile");
        String sql = "LOAD DATA INFILE  '/txt/test.txt'  INTO TABLE test  LINES TERMINATED BY '\\r\\n' ";
        //sql="SELECT * FROM test";
        // sql = "load data infile 'E:/mysqlsql/test.txt' replace into table test character set GBK fields terminated by ',' enclosed by '\'' lines terminated by '\r\n'";
        System.out.println(sql);
        boolean result = stmt.execute(sql);

        System.out.println("Load执行结果：" + result);

    }catch(Exception e){
        e.printStackTrace();
    }
}

Answer 1

http://www.cnblogs.com/jeffen/p/6005410.html 看看这篇文章