Announcement Announcement Module
Collapse
No announcement yet.
SqlException Help required Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • SqlException Help required

    bad SQL grammar [insert into T_EMPLOYEE_EMP (MST_ID,MST_TYPE,MST_NAME) values (?,?,?)]; nested exception is java.sql.SQLException: ORA-00904: "MST_NAME": invalid identifier
    MST_NAME(column name) is alredy there in data base
    Code:
    int addEmp = update("insert into T_EMPLOYEE_EMP (MST_ID,MST_TYPE,MST_NAME) values (?,?,?)",new Object[]{2,"Operator","Operator"});
    Last edited by junugari; May 18th, 2011, 10:00 AM.

  • #2
    can anybody help me on this I am getting Bad Sql Grammar exception whiule inserting record into oracle table..

    Comment


    • #3
      Perhaps this is a purely database issue...

      Are you sure you've not misspelled the column name...

      Comment


      • #4
        Test you command from Oracle client first and see what you get?

        Comment

        Working...
        X