wood burning stoves 2.0*
The moose likes JDBC and the fly likes Cannot understand this error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Cannot understand this error" Watch "Cannot understand this error" New topic
Author

Cannot understand this error

Vaibhav Pingle
Greenhorn

Joined: Nov 23, 2006
Posts: 6
Hi frnds.....

On running the following query......




i am getting the following error......

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression 'B.BNUMBER=T.BUY_BILL) AS BUY_DATE, BUY_PRICE, BUY_VENDOR, SELL_BILL,(SELECT B.BDATE FROM BILLS AS B WHERE B.BNUMBER=T.SELL_BILL) AS SELL_DATE, SELL_PRICE, SELL_VENDOR FROM TRADES T'.



but the same query runs fine in MS access....when run independently of java....

I am using MS Access as the Databse
[ November 27, 2006: Message edited by: Bear Bibeault ]
 
 
subject: Cannot understand this error
 
Similar Threads
Problem with UNION query
Anyone any good at SQL?
SQL Queries: Some errors
Java sqlexception definition
jdbc select query problem on selecting MS-ACCESS date