[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_26394 ] 

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

This may not be an issue of case-folding, but something else.

I deleted hibernate.reveng.xml and created a new one from scratch, this time specifying
NO filters.  The network trace looks IDENTICAL, including the "ittoolkit" string as a query 
parameter.  

The only other object in the project named "ittoolkit" is the session-factory in hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
		"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
		"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory name="ittoolkit">
        <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="hibernate.connection.url">jdbc:oracle:thin:@wfmdev4:1521:hrdev</property>
        <property name="hibernate.connection.username">ittoolkit</property>
        <property name="hibernate.connection.password">ittoolkit</property>
        <property name="hibernate.default_schema">ittoolkit</property>
        <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
	<mapping resource="com/wholefoods/ittoolkit/ws/admin/Team.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

For completeness, here's hibernate.reveng.xml:

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

<hibernate-reverse-engineering>
</hibernate-reverse-engineering>


> 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