Hi!

Is it possible for hibernate (I'm using version 3.1.3) to generate sql statements without schema?

For example:
I want: SELECT * FROM MY_TABLE;

and NOT as: SELECT * FROM MY_SCHEMA.MY_TABLE;

I didn't find a way to turn off schema.

Best regards,
Igor Novak

Hibernate will generate SQL w/o the schema. In our web app, we only set the schema within the datasource configuration -- no schema="xxx" attributes, etc.

Curtis ...