Hibernate version:3.1
Name and version of the database you are using:Sybase ASE 12.5

Hi!
I have database where some tables are owned by different users. To access tables of different user I need to specify username before tablename. So, simple select looks like:
SELECT * FROM <username>.<tablename>.
Can I specify somewhere in hibernate configuration username
to force hibernate to use that name in all queries as table prefix?
Because, currently I got Error:
"<tablename> not found. Specify owner.objectname"
Here objectname is <tablename>

do I understand you right, you have an app with user management and for each user you create a table?

I would suggest to build the sessionFactory on app startup programmatically.
You can use plain JDBC to retrieve the list of users and build mapping-classed based on this list.

Is that what you need?

No, it is normal table but in Sybase ASE it has a different owner.
And in sybase to access those tables I need to write something like
SELECT * FROM someLogin.someTableName instead of normal SELECT * FROM someTableName. So, I wonder, maybe I can specify somewhere in hibernate configurations that it must insert such prefix in all table names.

this seems to be a dialect issue.
did you choose the proper dialect?

Yes, I am. In fact, it works fine when database owner owns all tables and is used as login. We just can't change owners of those tables, so decided to search solution from the other end ( hibernate ).

<class
table="tableName"
schema="owner"
catalog="catalog"
/>