I am trying to use Hibernate with a Progress 10.1 database. This database has been around for many years and many of the table names and column names have dashes in them.

I am trying to see if I can configure Hibernate to allow for this.

For example, one table name is part-file. So if I wanted to extract a record from this table, the SQL would be:

select * from pub."part-file" where partno = 'some part number'

So the table name has to be surrounded with double quotes because of the dash in the table name.

Can Hibernate be configured to take this into consideration? Otherwise it looks like I get table/view not found SQL exceptions when it attempts to extract data from a table with a dash in the name.

I have this as my hbm.xml file:


But it won't of course let me put quotes in that table attribute ( unless I can somehow escape them.

Any ideas?

I actually was able to get this to work by using single quotes to wrap the attribute, then double quotes around the table name and or columns names.

Example for table name with dashes:




Example for column name with dashes:



This seems to work quite well.

Does anyone see anything wrong with this workaround or fix?