mgrmani
05-23-02, 18:54
| Hi I have IBM Visualage for java for windows version 4.0,web sphere 4.0 and database Oracle 8.1.7.I want to insert one record into database using servlet.My main logic related to database connection,prepared statement,result set in this servlet, pStmt = conn.prepareStatement ("INSERT INTO EMPLOYEE(ENO,ENMAE,SALARY,JOINDATE,ADDRESS,PHONE,D EPTNO) VALUES(?,?,?,?,?,?,?)"); pStmt.setInt(1,eno); pStmt.setString(2,ename); pStmt.setFloat(3,sal); pStmt.setString(4,date); pStmt.setString(5,add); pStmt.setLong(6,ph); pStmt.setInt(7,dept); rs = pStmt.executeQuery(); ResultSet rs = pStmt.executeQuery(); is giving the following error:java.sql.SQLException: ORA-00904: invalid column name. kindly, let me know how to correct this error. expecting your immediate reply. Regards, Rajendra mgr_raj9@yahoo.com |