I'm trying to use a sequence defined by other user for key-generating, and hibernate can't find it. I checked where it looks and found it runs 'select sequence_name from user_sequences' and searches the list it creates from the ResultList (this SQL is defined in the dialect, in getQuerySequencesString method).

Can anyone tell me how can I use other user's sequences properly?
(If it matters, hibernate.hbm2ddl.auto is set to validate in my application).

Hibernate version:3.1

Name and version of the database you are using:oracle9i

you can extends oracle dialect

I know I can do this. This is actually what I'm doing. I was just wandering if there is any better way (I don't like the idea of creating a new dialect). Is this a bug? Will it change in any version in the near future?

i think that it isn't bug - if you try select all sequence you have problem if two user have same sequence name
you can make your UID generator , too