This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Java in General
Reply locked New topic
Author

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
Bartender

Joined: Apr 14, 2004
Posts: 10336

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


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
 
subject: java sqlexception
 
Similar Threads
Error while accessing MSAccess in JSP
code working in Appletviewer but not browser
Java sqlexception definition
creating virtual tables
Error in insert into