[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-912) Table Filter folds schema name to lowercase in query -- fails on Oracle9

[James Garrison (JIRA)]

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

James Garrison commented on HBX-912:
------------------------------------

Unless I've missed something very obvious, this makes Reverse Engineering essentially
non-functional on Oracle since there's no way to retrieve the schema information.

> Table Filter folds schema name to lowercase in query -- fails on Oracle9
> ------------------------------------------------------------------------
>
>          Key: HBX-912
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-912
>      Project: Hibernate Tools
>         Type: Bug

>   Components: reverse-engineer
>     Versions: 3.2beta9
>  Environment: Hibernate tools 3.2.0beta9
> Oracle 9
>     Reporter: James Garrison
>  Attachments: reveng1.gif, reveng2.gif
>
>
> In the RevEng table filter dialog I enter the schema name in uppercase.
> When HBX generates the query to fetch the names of database objects, it folds the schema name to lowercase.
> Since Oracle does a case-sensitive comparison, no database objects are returned.
> I have verified this by running a network packet capture with Wireshark, and attached
> screenshots of the Table Filters page and the session trace.

-- 
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