[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-809) Quoting uppercased table names for PostgreSQL causes the reverse engineering to ignore foreign keys.

[Max Rydahl Andersen (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-809?page=comments#action_25182 ] 

Max Rydahl Andersen commented on HBX-809:
-----------------------------------------

could you try this out with hibernatetools from svn ?

I can't really see how the quoting here should affect foreign keys to not being found.

At least provide a minimal sql schema that shows the error.

> Quoting uppercased table names for PostgreSQL causes the reverse engineering to ignore foreign keys.
> ----------------------------------------------------------------------------------------------------
>
>          Key: HBX-809
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-809
>      Project: Hibernate Tools
>         Type: Bug

>   Components: reverse-engineer
>     Versions: 3.2beta8
>     Reporter: Sean Parsons

>
>
> If I override needQuote in JDBCMetaDataDialect as follows:
> public boolean needQuote(String name)
> {
> 	if (name.toLowerCase().equals(name))
> 	{
> 		return super.needQuote(name);
> 	}
> 	else
> 	{
> 		return true;
> 	}
> }
> The reverse engineering stops joining my tables through the foreign keys and instead of the classes being joined together, I just get long's in the place of the appropriate class in my case.  I tried stripping this down to just call the superclass method and that works and I've monitored the items that it is checking and the cases where it dropped into the else clause were only for the tables and once for each.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira