[
http://opensource.atlassian.com/projects/hibernate/browse/HBX-912?page=co...
]
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira