[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-812) Fetching Children of Database _crawls_.

[Igor (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=33519#action_33519 ] 

Igor commented on HBX-812:
--------------------------

For oracle you should add following element to your .cfg.xml:

<hibernate-configuration>
  <session-factory>
    ...
    <property name="hibernate.default_schema">YOUR_SCHEMANAME_IN_UPPERCASE</property> 
    ...
  </session-factory>
</hibernate-configuration>

> Fetching Children of Database _crawls_.
> ---------------------------------------
>
>                 Key: HBX-812
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-812
>             Project: Hibernate Tools
>          Issue Type: Bug
>          Components: reverse-engineer
>    Affects Versions: 3.2beta8
>         Environment: MySQL 5.0, Eclipse 3.2, JDK 1.5, Beta8 for Hibernate Tools
>            Reporter: Syd Poetry
>
> I just updated a bunch of components for Eclipse (mostly related to Visual Editor); added a couple of tables to my database, went to regenerate all the POJO clases .hbm.xml mapping files, and found that anything that queries the database schema runs abysmally slow.
> Updated the tools from beta6 to beta8 thinking it might be a conflict with one of the updates that was performed, still very slow (5+ minutes to retrieve a list of tables!).  Deleted all my hibernate-related XML files thinking it might be a parsing error, went to generate a new console file, and revenge.xml, found out that any listbox that tried to access the schema appeared to be hanging.  It finishes after much hard-drive crunching. I have 2.2 GBs free running windows XP, MEM usage is 856 MB out of 1.5 GB physical memory.  Just out of curiousity, is *anyone* else having this slow response for schema detection?  I'm wondering if I have to update another component like a driver or something like that.

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