Hi all:
I was trying to run the Hibernate Toolset example at the end of this page:
http://www.hibernate.org/159.html

recreated the database as an MSAccess database, with the three tables ITEM,
BID and USER
i used the generic dialect and tried to run the query:
select user from User as user

i go the following error:


1 errors occurred while listing (and calling getPathNames).
Could not execute query: com.inzoom.adojni.ComException: The SELECT
statement includes a reserved word or an argument name that is misspelled or
missing, or the punctuation is incorrect. in Microsoft JET Database Engine
code=3092 Type=1 Query: select user0_.USER_ID as USER_ID, user0_.HANDLE as
HANDLE, user0_.NAME as NAME, user0_.PASSWORD as PASSWORD from USER user0_
The SELECT statement includes a reserved word or an argument name that is
misspelled or missing, or the punctuation is incorrect.


my questions are:
1) where did the user0_ come from?
2) is there a dialect for MSAccess? or has anyone written one and willing to
share it?

thanks
hilz

Hi,


hibernate create the suffix : 0_
after all sql query. Thats normal behavior



Better try the SQLServerDialect, it should work for simple testing.
I saw a MSAccess dialect made by a user yesterday, but can't find the link right now.

I'll post here if I find it.

Cheers.

Stéphane

'user' is a reserved word in sql server , not sure about access.

Wow...I totally forgot about this post! It's been over year since i posted it!
Anyway...I would still love to get hold of this dialect if it existed.

I tried a quick search just now, and still can't find anything.

If you do find it, PLEASE post here!

thanks a lot