How to execure an SQL insert statement using Java?

Question

I am trying to execute and SQL query in java using the method executeQuery(String) of Class "Statement" i.e.
Statement stmt = null;
stmt.executeQuery(sql); /* sql is an insert statement in sql */

However, I am getting message of an exception of the class "SQLException" saying, "There was an internal database error". The thing worth mentioning is that when I fire the same "insert" statement denoted by string "sql" directly onto the database, the query gets fired successfully.

What is the root cause of this problem where in the query is getting fired direclty in the database but not in java?

Answer 1

try this inside your class
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:");
Statement stmt = con.createStatement();
stmt.executeQuery(sql);
}
catch(Exception e){
}

good luck.

Answer 2

here connection may be the culprit. Also special chracters in ur insert values can cause the error.

Answer 3

I THINK THE PROBLEM IS WITH UR LINKING TO THE DATABASE FROM JAVA, CHECK THAT THE CONNECTION IS PROPER