Statement works in database, but fails in Java code -

Question

CREATE USER Person identified by 2012;GRANT ALL PRIVILEGES TO Person;

These statements are successfully executed by Oracle 11g (GUI). But, when I copy and paste the above statement exactly and try to execute it by using executeUpdate(String sql), I get the exception below. Why?

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

Don't you need to have your queries separated? I mean two separate executeUpdate. — Matin Kh
– Matin Kh, Commented Aug 14, 2012 at 7:38

sakthisundar · Accepted Answer · 2012-08-14 07:47:10Z

4

You should not give a two different SQL statements as one. There is no way that you can JDBC driver will execute two statements passed as one string.

try to execute them as

Statement stmt = conn.createStatement();
stmt.executeUpdate("CREATE USER Person identified by 2012");
stmt.executeUpdate("GRANT ALL PRIVILEGES TO Person;");

That should do. Cheers.

answered Aug 14, 2012 at 7:47

sakthisundar

3,2863 gold badges18 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

markus · Accepted Answer · 2012-08-14 07:42:29Z

3

Dependend on your database jdbc driver, the driver will not support executing two statements in one "executeUpdate". You have to do something like:

Statement stmt = conn.createStatement();
for(String statement : statements) {
    stmt.addBatch(statement);
}
stmt.executeBatch();

answered Aug 14, 2012 at 7:42

markus

6024 silver badges13 bronze badges

1 Comment

sweet dreams Over a year ago

Thanks ! I wanted to add some extra info about executeUpdate vs executeBatch() here - stackoverflow.com/questions/1143053/…

Collectives™ on Stack Overflow

Statement works in database, but fails in Java code -

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related