[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-1103) org.hibernate.tool.hbm2x.ExporterExcept when reverse engineering a DB

[Olivier Cailloux (JIRA)]

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

Olivier Cailloux commented on HBX-1103:
---------------------------------------

Anthony: the PK is LEFT_ID. You should be able to see all the details from the create_DB.sql script. Here is the relevant part:
CREATE TABLE [dbo].[MIDDLE](

	[LEFT_ID] [int] NOT NULL,

	[RIGHT_ID] [int] NOT NULL,

 CONSTRAINT [PK_MIDDLE] PRIMARY KEY CLUSTERED 

(

	[LEFT_ID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]



Thanks for working on this.
Olivier

> org.hibernate.tool.hbm2x.ExporterExcept when reverse engineering a DB
> ---------------------------------------------------------------------
>
>                 Key: HBX-1103
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1103
>             Project: Hibernate Tools
>          Issue Type: Bug
>          Components: reverse-engineer
>    Affects Versions: 3.2.4 Beta1
>         Environment: MS SQL database 2005 :
> Microsoft SQL Server Management Studio						9.00.3042.00
> Microsoft Analysis Services Client Tools						2005.090.3042.00
> Microsoft Data Access Components (MDAC)						2000.085.1132.00 (xpsp.080413-0852)
> Microsoft MSXML						2.6 3.0 4.0 6.0 
> Microsoft Internet Explorer						7.0.5730.11
> Microsoft .NET Framework						2.0.50727.1433
> Operating System						5.1.2600
> eclipse Platform 3.4.1, build M20080911-1700
> JBoss Hibernate Tools, 3.2.4.CR1-R200812191611
>            Reporter: Olivier Cailloux
>            Assignee: Anthony Patricio
>            Priority: Critical
>         Attachments: create_DB.sql, hibernate.reveng.xml, logback.xml, persistence.xml, SQLdiag.gif, stacktrace.log
>
>
> Hi,
> I am trying to use hibernate tools in eclipse to reverse engineer a complex db, and I sometimes get "org.hibernate.tool.hbm2x.ExporterException: Error while processing Entity: persist.eXacto.Left with template pojo/Pojo.ftl" type exceptions.
> After much tries, I have been able to track the error down to the following schema: https://smg8.ulb.ac.be/hib/SQLdiag.gif . The sql to create the problematic schema is the following: https://smg8.ulb.ac.be/hib/create_DB.sql .
> The stack trace reported by Hibernate tools through the eclipse error log is here: https://smg8.ulb.ac.be/hib/stacktrace.log . The configuration files are here: https://smg8.ulb.ac.be/hib/logback.xml ; https://smg8.ulb.ac.be/hib/hibernate.reveng.xml ; https://smg8.ulb.ac.be/hib/persistence.xml .
> I have not been able to log anything else from Hibernate other than the error stacktrace here above, altough I tried to configure logback correctly and enabled sql debugging in persistence.xml. What is missing to enable detailed log output?
> Please tell me if you need any other information. I am beginner in Hibernate. Thank you for any help or pointer.
> Olivier

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