Hello,

I'm relatively new to hibernate. It looks good but I have a very big problem...

Our database has all the tables names in uppercases,

USER, USERGROUP, etc...

In my hibernate config file I have something like this....

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">


<hibernate-mapping auto-import="true" default-lazy="false">

<class name="ro.etc.hibernate.domain.authorisation.Authorisation"
table="`APPUSER_TEST`" schema="ANCPI" >
<id name="appuserid" column="APPUSERID" type="java.lang.Integer" unsaved-value="0">
<generator class="native"/>
</id>
<property name="username" column="USERNAME"/>

<set name="groups" table="`USERXGROUP_TEST`" schema="ANCPI">
<key column="appuserid"/>
<many-to-many column="usergroupid" class="ro.star.ancpi.eTerra1.hibernate.domain.authorisation.Group"/>
</set>

</class>

<class name="ro.etc.hibernate.domain.authorisation.Group"
table="`USERGROUP_TEST`" schema="ANCPI">
<id name="groupid" column="GROUPID">
<generator class="native"/>
</id>
<property name="groupname" column="GROUPNAME"/>
</class>

</hibernate-mapping>


I want hibernate to generate the Oracle Sql using exactly my table names,
APPUSER_TEST, USERGROUP_TEST, etc...in the exact cases.

I used the famous backticks ````````` but with no results. It simply doesn't work !


Can you help me ?


Thanks

try using maybe that will do the trick

Thanks for your response Glimmlampe.

I tried the \" approach before but I forgot to mention it.

something like this:
----
table="\"MY_TABLE_NAME\""
----
gives the following error at compile time:

Caused by: org.hibernate.InvalidMappingException: Could not parse mapping document from input stream.


Anyway...it seems to me really odd that Hibernate by default transform tables' names from the mapping files to lowercases.

Also tried

table='"MY_TABLE_NAME"' <-- if it's not direct readable it's

<simple quote><double quote>MY_TABLE_NAME<simple quote><double quote>

and when my HQL was transformed to SQL the query was:

...from "my_table_name"..........

also tried escape characters " &quot; for double quote...

""MY_TABLE_NAME"" and "&quot;MY_TABLE_NAME&quot;"

in this cases the sql was :
...from ?my_table_name?..........

Is this a bug ?