how to configure hibernate3 to use user login in queries?

[alebu]

Hi!
I have database where some tables are owned by different then database owner user. To accesss those tables I need to specify username before tablename. So, simple select looks like : SELECT * FROM <username>.<tablename>.
This is a test database and in production will be used only one user ( database owner ) and ther will be no need to specify table owner. I use hibernate to work with those tables, so my question is:
Can I specify somewhere in hibernate configuration username
to prevent hibernate to use that name in all queries?
Because, currently I got Error:
<tablename> not found. Specify owner.objectname
-----
Using Sybase ASE-12.5 and Hibernate-3.1

 

[alebu]

Uhh, sorry, I mean HOW TO FORCE hibernate to use username in queries My bad

 

[Diancecht]

What about hibernate configuration file?
hibernate.cfg.xml or something.

http://www-128.ibm.com/developerworks/websphere/techjournal/0409_patil/0409_patil.html

But I don't see what this has to do with Java.

Cheers,
Dian

 

[timw]

But I don't see what this has to do with Java.

Well, Hibernate is a Java framework and there isn't a specialised forum for it here (AFAIK).

Tim

 

[alebu]

Well, I like tek-tips, but there is no specialized forum here for hibernate. If I can ask here about jdbc, then I think it is naturally to ask about hibernate too.

 

[Diancecht]

I always thought in Hibernate as a data source, noy bounded to Java, since you can use it with .NET, for example.

Anyway, I hope you got your answer.

Cheers,
Dian