weird executeUpdate error?

i have an method that generates a SQL statement and send it to
the database with the method executeUpdate.

i have copied and pasted the SQL line that was generated with this program,
into Oracle. and it gives me no error.

but in this program, it throws an exception.

public void settInn(int studentnummer, String fagkode, String dato) {
      Statement stmt;
      
      try {
         // String sqlSetning = "INSERT INTO chekha.student_eksamen " + 
                            //   "VALUES(39,'PG3402',NULL)";
      String sqlSetning = "INSERT INTO chekha.student_eksamen " +
      "VALUES("+studentnummer+",'" +fagkode+"', '" +dato+"')";
      System.out.println( sqlSetning );
      
      stmt = con.createStatement();
      
      int antall = stmt.executeUpdate(sqlSetning);
      if (antall != 0) {
      System.out.println("Registrert");
      }
      else System.out.print("ikke registrert");
         
      con.commit();
      stmt.close();
      }
      
      
    catch (SQLException e) {
           System.out.println("Klarer ikke � utf�re oppdateringen");
           System.out.println(e.getMessage());
           javax.swing.JOptionPane.showMessageDialog(null, "Klarer ikke � utf�re oppdateringen. " +
           "\n" + 
           e.getMessage());
           
          
        }
    }

i have checked the output of "System.out.println( sqlSetning );" pasted into oracle with success.

how comes?

what is exception ,you are getting

hi,

i get an SQLException :
"ORA-00942: table or view does not exist" .

but I have tested the SQL statement in Oracle and it works fine.

??

Do you have public synonyms set up for your tables?

I am not to familiar with oracle, but are you connecting to the correct database and do you have read/write privileges?

are you sure you are connected to right database?? Just a thought can you please verify.

thanks
[ January 21, 2005: Message edited by: Shailesh Chandra ]

hi shailesh,
yes, the same database and with same username and password of course.
so weird?

kelvin.

try to execute a select query on same table revert if you get same error?

try one more thing remove schema name from table chekha.student and try with student only.

however schma name does not give error but try this as well.

hi Shailesh ,
just tried that too.

how comes?!
i tried to insert the SQL line within the program. it fails.
then i copy the SQL line which was generated by the program. it worked.
this is so weird!

did select statment execute ....??
I copied your program and execute my insert query !! no problem ...

either problem is with database connection or it is some other database related issue.
Can you paste your program of making connection !!!

thanks
[ January 21, 2005: Message edited by: Shailesh Chandra ]

Sheilest,
Thank you for your help.
You were right. A problem with a connection of the database.

Regards,
Kelvin.