[SOLVED] java.sql.SQLException: ORA-00928: missing SELECT keyword

snehal89 · 04-24-2013, 01:17 AM

Hello everyone,

I am getting java exception error in following query:

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

please can any one help me on this.

thank you in advance.

pan64 · 04-24-2013, 04:06 AM

what is the problem, SELECT (or something else) is missing:
INSERT into TABLE values (.....) but what? see here:
https://dev.mysql.com/doc/refman/5.1...rt-select.html