File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java sqlexception definition

 
Janardan Kelkar
Ranch Hand
Posts: 72
Eclipse IDE Firefox Browser Suse
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i seem to be ghetting an exception when trying to insert in a database defined in ms access.
parameters are as follows:
driver is sun.jdbc.odbc.JdbcOdbcDriver;
error code is: -3506
sql state is :37000
message is : [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

my query is:
"select * from Order"

java 1.5
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Order is a SQL keyword. If you have an entity called order, rename it. If you can't rename it, I think the Access escape character is brakets, so you could try:
 
Janardan Kelkar
Ranch Hand
Posts: 72
Eclipse IDE Firefox Browser Suse
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thank you very much...my wrong,sorry!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic