Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

The INSERT INTO statement contains the following unknown field name: 'OPANo'.

 
Akriti Bahal
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have the following code which compiles fine but when it runs then it throws the exception that java.sql.SQLException:[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the following unknown field name: 'OPANo'. Make sure you have typed the name correctly, and try the operation again., please if you could help what is wrong it would be a great help.


 
joy b chakravarty
Ranch Hand
Posts: 62
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
a stacktrace would help
 
joy b chakravarty
Ranch Hand
Posts: 62
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
VALUES(?,?,?,?,?,?,?,?,?,?,?)");


A ? is missing ... just check
 
Akriti Bahal
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ya, one ? was missing and I put it now but, now I'm getting "java.sql.SQLException:[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the following unknown field name: 'OPANo'. Make sure you have typed the name correctly, and try the operation again." exception when I run it. Please help.
 
Akriti Bahal
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What's a stcktrace?
 
Ashwin Sridhar
Ranch Hand
Posts: 277
Flex Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
are you sure if there is a column by name OPANo in the 'project' table
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic