[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-961) invalid column name in H2MetaDataDialect getSuggestedPrimaryKeyStrategyName query

[Max Rydahl Andersen (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_27517 ] 

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

just run the unittests with H2MetaDataDialect and see what fails ;)

I swear that this TABLE_CATNAME worked with the latest h2 at the time of committing it.
I also know that H2 author changes the structure of H2 information schema at some point...that's why I'm asking for what version of h2 you are using.

> invalid column name in H2MetaDataDialect getSuggestedPrimaryKeyStrategyName query
> ---------------------------------------------------------------------------------
>
>                 Key: HBX-961
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-961
>             Project: Hibernate Tools
>          Issue Type: Bug
>          Components: reverse-engineer
>    Affects Versions: 3.2beta10
>         Environment: H2, version: 1.0 (2007-06-17)
>            Reporter: Dan Allen
>         Attachments: HBX-961-v1.txt, HBX-961-v2.txt
>
>   Original Estimate: 5 minutes
>  Remaining Estimate: 5 minutes
>
> There is an invalid column name used in the query to get the primary keys for a table.  The query uses the column name TABLE_CATNAME but the appropriate name of the column is TABLE_CATALOG.  A patch is supplied.

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