File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes java sqlexception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » Java in General
Reply locked New topic

java sqlexception

Janardan Kelkar
Ranch Hand

Joined: May 05, 2008
Posts: 72

i seem to be getting 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

When the compiler's not happy, ain't nobody happy.
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Please don't post the same question in more than one forum.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: java sqlexception
jQuery in Action, 3rd edition