Hello,
I have a hibernate based application working right but when i needed to transfer it to another database whith the similar tables i've seen (using Query analyser) that some tables must be queryed like this " select * from mediator.TableName " where mediator is the owner of the table and my queries at hibernate do " SessionFactory.find( "SELECT t from Table t order by t.codigo" ) " .
I wanted to include in my hibernate query mediator.Table , but thats imposible it shows the error:
And i've tried to connect (using Query analyser) whith the user mediator but my queries are accepted only like mediator.TableName

Some one can help me.

Try setting a Hibernate default Schema - section 4.4 in the reference docs.

hibernate.default_schema=mediator (in a properties file)

<property name="hibernate.default_schema">mediator</property> in hibernate.cfg.xml

hi pksiv i've tried your advice but i belive that this would work right if in all my table i must include mediator.TableName, but in some tables i must not use mediator.TableNamebut only TableName for example in my User's table which i use to logging in my sistem.

Thanks JP

If you can't use it for all of them, you can set it for each Class in the individual mapping files.

HOOOO how can i do this ??? this will help me a lot !!!!

<class name="MyClass" schema="myschema">
...
...
</class>

Guy very, very, very, .... very, thanks this has resolved my trobel !!!!

Im very pleased !!!!


Thanks JP