Error java.sql.SQLException: ORA-00911: invalid character

Question

I have error for code:

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);
}

Got any dignostic information (line numbers)? I guess that the `;` might be causing the problem, because Oracle-drivers tend to support only one statement within a query. — Caramiriel, Mar 16 '14 at 10:52
@Caramiriel Yes you're right. Simple solution, but I was debugging for 30min before I turned to SO. — Tim Sanders, Apr 25 '14 at 18:38

score 103 · Answer 1 · edited Jul 17 '14 at 09:42

103

The problem is ;

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

Remove the ; from above string.

edited Jul 17 '14 at 09:42

Samuel Liew

76,741
107
159
260

answered Jul 17 '14 at 09:24

Abhishek

1,031
1
7
3

5

thank you! so silly to have systems not be flexible about this or not throwing a very clear expection – George Pligoropoulos Dec 23 '15 at 08:22
@Georgios And the system should accept that comma ! – Jarkid Feb 13 '18 at 03:05
1

@Jarkid it's semicolon. – Alex78191 Jul 15 '19 at 16:47

score 8 · Answer 2 · edited Apr 25 '19 at 07:48

I have also received same problem in myBatis.

Error:

### Cause: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

    ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

Solution:

select * from tableName where id= '123';

after removing ";" from Where clause(Mybatis Mapper xml), its working.

Error java.sql.SQLException: ORA-00911: invalid character

2 Answers2

Linked