[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-758) Provide an OracleMetaDataDialect

[Max Rydahl Andersen (JIRA)]

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

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

no problem I fixed them both now (sorry for not updating)

the classcastexception were being swallowed with a too friendly catch clause which i now changed + fix the actual value.

The cursor issue is "fun" because it is exactly the same thing that happens with the jdbc metadata api on Oracle (and only oracle)
and the fix (on your metadata dialect) is to pass in the Statement used when iterating a resultset so it will be closed together with the resulset.

Then no cursor leaking is to be found. The fun part is that in the pure metadata api there is only the resultset to close so it looks like
Oracle does not close their metadata Statements....

> Provide an OracleMetaDataDialect
> --------------------------------
>
>          Key: HBX-758
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-758
>      Project: Hibernate Tools
>         Type: Improvement

>   Components: reverse-engineer
>     Versions: 3.2beta7
>     Reporter: Max Rydahl Andersen
>     Assignee: David Channon
>      Fix For: 3.2beta8

>
>
> Use oracle specific queries to speed up reverse engineering on Oracle db's

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