错误java.sql.SQLException:ORA-00911:无效字符 [英] Error java.sql.SQLException: ORA-00911: invalid character

问题描述

我的代码有误:

String sql = "CREATE USER ken IDENTIFIED BY 11;";

try {
    Class.forName("oracle.jdbc.OracleDriver");
    con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system", "kenilyas");
    System.out.println("1111111111111");
    System.out.println("222222");
    pst = con.prepareStatement(sql);
    System.out.println("333333");
    try {
        System.out.println("333333");
        pst.execute();
        System.out.println("creating");
    } catch (Exception e) {
        JOptionPane.showMessageDialog(null, e);
    }
} catch (Exception e) {
    JOptionPane.showMessageDialog(null, e);
}

推荐答案

问题是;

sql = "CREATE USER ken IDENTIFIED BY 11;";

从上面的字符串中删除;.

Remove the ; from above string.

这篇关于错误java.sql.SQLException:ORA-00911:无效字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！