JDBC: Problem with execution of SQL Statement

From:

"Sameer" <dolpheen@gmail.com>

Newsgroups:

comp.lang.java.programmer,comp.lang.java.help

Date:

19 Jun 2006 10:16:44 -0700

Message-ID:

<1150737404.228258.124070@p79g2000cwp.googlegroups.com>

Hello,
A simple JDBC program is given below:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestClass {

    public static void main(String args[]){
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url= "jdbc:oracle:thin:@IISSERVER:1521:ORACLE";
            Connection connection =
DriverManager.getConnection(url,"scott","tiger");
            Statement statement;
            ResultSet resultSet;
            statement = connection.createStatement();
            String query = "INSERT INTO RESULT "+
                    "VALUES("+
                    "4,'IT-04-01','','SHINDE
SAMEER',54,55,40,58,52,34,40,43,30,26,'SECOND CLASS'"+
                    ");";
            System.out.println(query);
            resultSet = statement.executeQuery(query);

        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
   }
}

The variable query holds the value:
INSERT INTO RESULT VALUES(4,'IT-04-01','','SHINDE
SAMEER',54,55,40,58,52,34,40,43,30,26,'SECOND CLASS');

I can run this statement in SQl Plus and get the record inserted into
the table.
But this is not the case with program. The Oracle driver loads and I
get a SQLException

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

        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
        at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
        at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
        at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
        at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
        at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125)
        at TestClass.main(TestClass.java:24)

What may be the problem?
Please help.