[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-614) SchemaUpdate broken in DB2/400

[Marcello Mazzotti (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_30690 ] 

Marcello Mazzotti commented on HHH-614:
---------------------------------------

i have the same bug on hibernate 3.2.6ga using db2400 v5r3.  QSYS2.SYSSEQUENCES is the correct table to discover sequences on db2/400.

> SchemaUpdate broken in DB2/400
> ------------------------------
>
>                 Key: HHH-614
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-614
>             Project: Hibernate3
>          Issue Type: Bug
>    Affects Versions: 3.0.5
>         Environment: Hibernate running on Windows XP Professional and jre 1.5. Database running on i5/OS V5R3M0. jt400 toolbox driver.
>            Reporter: Jouni Rajala
>             Fix For: 3.1 beta 1
>
>
> When running SchemaUpdate, i get exceptions out that indicate problems with sql dialect. SQL Exception says:
> java.sql.SQLException: [SQL0204] Kirjaston SYSIBM *FILE-lajista objektia SYSSEQUENCES ei löydy.
> Which is translated as 'table SYSSEQUENCES is not found in schema SYSIBM' (not sure about correct translation to english but I am sure you get the meaning).
> It shows that you try to use DB2 syntax DB2/8.1 or something similar which has SYSIBM.SYSSEQUENCES table existing. This table however does not exists in DB2/400 and sequences are handled differently.
> When I use SchemaExport utility, everything works just fine. So it is probably just leftover from somewhere.

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