java.sql.SQLException: ORA-00928: missing SELECT keyword

Question

I am getting the above mentioned exception while executing the SQL query in Java.

statement2.executeUpdate("INSERT INTO visit_header" 
    + "VALUES('"+visitnumber+"','"+date+"','"+cookie+"','"+ip+"')");

I want to know where it is going wrong.

Pradeep Simha · Accepted Answer · 2013-04-24 06:30:51Z

5

As per initial look, you have a problem in your sql query:

statement2.executeUpdate("INSERT INTO visit_header" + "VALUES

Should be

statement2.executeUpdate("INSERT INTO visit_header " + "VALUES  //Note space after header

There was no space between visit_header and VALUES, so your query was like this:

INSERT INTO visit_headerVALUES

Which is wrong.

answered Apr 24, 2013 at 6:30

Pradeep Simha

18.2k19 gold badges60 silver badges112 bronze badges

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

3 Comments

Thank you. It is working now, but now i am getting the exception below java.sql.SQLException: ORA-01950: no privileges on tablespace 'EXAMPLE'

@user2314206, can you login to example table using sql-plus? does user really have privileges to access that tablespace?

Ok. I have given the privileges. I got it. Thank you.

AsirC · Accepted Answer · 2013-04-24 06:30:18Z

5

You forgot to put space between visit_header and values:

statement2.executeUpdate("INSERT INTO visit_header" + " VALUES ('"+visitnumber+"','"+date+"','"+cookie+"','"+ip+"')");

answered Apr 24, 2013 at 6:30

AsirC

4591 gold badge6 silver badges21 bronze badges