Results 1 to 4 of 4

Thread: SqlException Help required

Hybrid View

  1. #1
    Join Date
    May 2011
    Location
    mumbai
    Posts
    37

    Default 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 at 09:00 AM.

  2. #2
    Join Date
    May 2011
    Location
    mumbai
    Posts
    37

    Default

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

  3. #3
    Join Date
    Apr 2011
    Posts
    107

    Default

    Perhaps this is a purely database issue...

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

  4. #4
    Join Date
    Dec 2010
    Posts
    175

    Default

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •