I'm using the following code to insert data. But I'm receiving an error as "ORA-00928: missing SELECT keyword"
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
java.sql.Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@xxx.xxx.x.xxx:xxxx:xxxx", "xxxx", "xxxx");
String query="insert into offer1('RCODE','OFFERNO','DAT') values(?,?,?)";
PreparedStatement ps=conn.prepareStatement(query);
ps.setString(1,r_code);
ps.setString(2,offerno);
ps.setDate(3,sqlDate);
ResultSet rs=ps.executeQuery();
out.println("data inserted");
}catch(Exception e)
{
out.println(e);
}
I can't see any errors in this code. If someone finds, please tell me what is the mistake and how to solve it?
single quotes are for string literals not for identifiers only so you should remove it around the columnNames.
INSERT INTO offer1 (RCODE,OFFERNO,DAT) VALUES (?,?,?)
and use executeUpdate
since you are not retrieving records which results a resultset.
from DOCS
boolean execute()
ResultSet executeQuery()
int executeUpdate()
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With