Hibernate version:

3.0.0

[Problem]

I'm using Oracle8 and most of my tables are under the schema "A", but one table can only be accessed without schema prefix. In my mapping I'm using the "hibernate.default_schema" property so I don't have to define the schema everywhere. My problem is that with "hibernate.default_schema" I cannot say to Hibernate not to use schemas.

To ilustrate the problem:

Most of my tables are on schema "A", the following query works:



But one of my tables "tableN" cannot be accessed using schema prefixes:

No schema prefix will make the select work.


I've tryed to make the mapping of "tableN" not use schemas on the generated SQL, but found no luck. I've tried using schema tags in the class and hibernate-mapping tags:


And


Using schema="" Hibernate throws "java.lang.StringIndexOutOfBoundsException: String index out of range: 0" since it checks for quoting.

Looking at the code seens like Hibernate will allways generate a schema if the default schema is not null.

Do you have some pointers of how I fix this, but without resorting to have to define my schema in every mapping file.

Thanks,

While I haven't used Hibernate w/ Oracle, you should be able omit the "hibernate.default_schema" property and then specify the default schema on the JDBC connection. Hibernate will then generate queries of the form "select * from table1" (no schema). Then for your special case table in the other schema, add the "schema=" attribute to the mapping. That will then generate a query in the form of "select * from schema1.table1".

Good luck,
Curtis ...

You see, the problem is that the special case must not use any schema since it´s a private view of the user. Either using JDBC's default schema or Hibernate's I cannot specify to not use schema qualification.

Did u find a solution to this problem? I need to build all my queries without specifying the schema_name.

Did u find a solution to this problem? I need to build all my queries without specifying the schema_name.