LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   java.sql.SQLException: ORA-00928: missing SELECT keyword (http://www.linuxquestions.org/questions/linux-software-2/java-sql-sqlexception-ora-00928-missing-select-keyword-4175459386/)

snehal89 04-24-2013 02:17 AM

java.sql.SQLException: ORA-00928: missing SELECT keyword
 
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 05: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


All times are GMT -5. The time now is 03:54 PM.