<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: Getting "association error" when reverse-engineering an existing schema with Hibernate tools
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/johnqcitizen">John Citizen</a> in <i>JBoss Tools</i> - <a href="https://community.jboss.org/message/801784#801784">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Thanks for the response. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I am using <strong>maven-hibernate3-plugin 2.2</strong>, which has a dependency on <strong>hibernate-tools  3.2.3.GA</strong> and <strong>hibernate-core 3.3.1.GA</strong> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Here is some output from running the following command:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">$ <strong>mvn -X hibernate3:hbm2java</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">Apache Maven 3.0.4 (r1232337; 2012-01-17 18:44:56+1000)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">Maven home: C:\dev\apache-maven-3.0.4\bin\..</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">Java version: 1.6.0_38, vendor: Sun Microsystems Inc.</span></p><p style="padding-left: 30px;"><span style="font-size: 10pt; font-family: 'courier new', courier;">OS name: "windows xp", version: "5.1", arch: "x86", family: "windows"</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[INFO] --- hibernate3-maven-plugin:2.2:hbm2java (default-cli) @ foo ---</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG] <strong>org.codehaus.mojo:hibernate3-maven-plugin:jar:2.2</strong>:</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    cglib:cglib-nodep:jar:2.2.2:runtime</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    com.oracle:ojdbc:jar:11.1.0.6.0:runtime</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    log4j:log4j:jar:1.2.14:runtime</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    <strong>org.hibernate:hibernate-tools:jar:3.2.3.GA:compile</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.beanshell:bsh:jar:2.0b4:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       freemarker:freemarker:jar:2.3.8:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.hibernate:jtidy:jar:r8-20060801:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    <strong>org.hibernate:hibernate-core:jar:3.3.1.GA:compile</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       antlr:antlr:jar:2.7.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       commons-collections:commons-collections:jar:3.1:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       dom4j:dom4j:jar:1.6.1:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.slf4j:slf4j-api:jar:1.5.6:runtime (scope managed from compile) (version managed from 1.5.2)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    <strong>org.codehaus.mojo.hibernate3:maven-hibernate3-api:jar:2.2:compile</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       xml-apis:xml-apis:jar:1.0.b2:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.apache.geronimo.specs:geronimo-jta_1.0.1B_spec:jar:1.1.1:runtime</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.slf4j:slf4j-log4j12:jar:1.5.6:runtime</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.slf4j:jcl-over-slf4j:jar:1.5.6:runtime</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.codehaus.plexus:plexus-utils:jar:1.5.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    org.apache.maven:maven-model:jar:2.0.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    org.apache.maven:maven-project:jar:2.0.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.apache.maven:maven-settings:jar:2.0.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.apache.maven:maven-profile:jar:2.0.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.apache.maven:maven-artifact-manager:jar:2.0.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]          org.apache.maven:maven-repository-metadata:jar:2.0.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.apache.maven:maven-plugin-registry:jar:2.0.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.apache.maven:maven-artifact:jar:2.0.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       org.codehaus.plexus:plexus-container-default:jar:1.0-alpha-9-stable-1:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]          junit:junit:jar:3.8.2:test (scope managed from compile) (version managed from 3.8.1)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]          classworlds:classworlds:jar:1.1-alpha-2:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    org.apache.maven:maven-plugin-api:jar:2.0.6:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    org.codehaus.mojo.hibernate3:maven-hibernate3-jdk14:jar:2.2:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]    org.codehaus.mojo.hibernate3:maven-hibernate3-jdk15:jar:2.2:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       <strong>org.hibernate:hibernate-entitymanager:jar:3.4.0.GA:compile</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]          <strong>org.hibernate:hibernate-commons-annotations:jar:3.1.0.GA:compile</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]          javax.transaction:jta:jar:1.1:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       <strong>org.hibernate:ejb3-persistence:jar:1.0.2.GA:compile</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       <strong>org.hibernate:hibernate-annotations:jar:3.4.0.GA:compile</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       jboss:jboss-common:jar:4.0.2:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]          slide:webdavlib:jar:2.0:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]          xerces:xercesImpl:jar:2.6.2:compile</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG]       javassist:javassist:jar:3.4.GA:compile</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG] Goal:          <strong>org.codehaus.mojo:hibernate3-maven-plugin:2.2:hbm2java (default-cli)</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG] Style:         Regular</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG] Configuration: <?xml version="1.0" encoding="UTF-8"?></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;"><configuration></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">  <componentProperties></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">    <revengfile>/src/main/resources/reveng.xml</revengfile></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">    <propertyfile>src/main/resources/hibernate.properties</propertyfile></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">    <packagename>com.whatever.domain</packagename></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">    <jdk5>true</jdk5></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">    <ejb3>true</ejb3></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">  </componentProperties></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">  <components></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">    <component></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">      <name>hbm2java</name></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">      <implementation>jdbcconfiguration</implementation></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">      <outputDirectory>target/generated-sources/hibernate3</outputDirectory></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">    </component></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">  </components></span></p><p style="padding-left: 30px;"><span style="font-size: 10pt; font-family: 'courier new', courier;"></configuration></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[DEBUG] =======================================================================</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[INFO] </span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[INFO] >>> hibernate3-maven-plugin:2.2:hbm2java (default-cli) @ foo >>></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier; font-size: 10pt;">09:06:58,296        DEBUG DriverManagerConnectionProvider:138 - created connection to: jdbc:oracle:thin:@***, Isolation Level: 2</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,296         INFO SettingsFactory:116 - <strong>RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">With the Partitioning, OLAP and Data Mining options</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,296         INFO SettingsFactory:117 - <strong>JDBC driver: Oracle JDBC driver, version: 11.1.0.6.0-Production</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,312         INFO Dialect:175 - Using dialect: org.hibernate.dialect.Oracle10gDialect</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier; font-size: 10pt;">09:06:58,328         INFO TransactionFactoryFactory:59 - Using default transaction strategy (direct JDBC transactions)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier; font-size: 10pt;">09:06:58,343         INFO SettingsFactory:170 - Automatic flush during beforeCompletion(): disabled</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,343         INFO SettingsFactory:174 - Automatic session close at end of transaction: disabled</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,343         INFO SettingsFactory:181 - JDBC batch size: 15</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,343         INFO SettingsFactory:184 - JDBC batch updates for versioned data: disabled</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,343         INFO SettingsFactory:189 - Scrollable result sets: enabled</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,343        DEBUG SettingsFactory:193 - Wrap result sets: disabled</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,343         INFO SettingsFactory:197 - JDBC3 getGeneratedKeys(): disabled</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,343         INFO SettingsFactory:205 - Connection release mode: auto</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,343         INFO SettingsFactory:223 - Default schema: RAPS</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">09:06:58,343         INFO SettingsFactory:232 - Default batch fetch size: 1</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">[ERROR] <strong>Failed to execute goal org.codehaus.mojo:hibernate3-maven-plugin:2.2:hbm2java (default-cli)</strong> on project foo: Execution default-cli of goal org.codehaus.mojo:hibernate3-maven-plugin:2.2:hbm2java failed: <strong>An association from the table FOO refers to an unmapped class: com.whatever.domain.Bar</strong> -> [Help 1]</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier; font-size: 10pt;">Caused by: <strong>org.hibernate.MappingException: An association from the table FOO refers to an unmapped class: com.whatever.domain.Bar</strong></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.hibernate.cfg.Configuration.secondPassCompileForeignKeys(Configuration.java:1285)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.hibernate.cfg.JDBCMetaDataConfiguration.secondPassCompileForeignKeys(JDBCMetaDataConfiguration.java:33)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1203)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.hibernate.cfg.Configuration.buildMappings(Configuration.java:1148)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.codehaus.mojo.hibernate3.configuration.AbstractComponentConfiguration.getConfiguration(AbstractComponentConfiguration.java:57)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.codehaus.mojo.hibernate3.HibernateExporterMojo.configureExporter(HibernateExporterMojo.java:200)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.codehaus.mojo.hibernate3.exporter.Hbm2JavaGeneratorMojo.configureExporter(Hbm2JavaGeneratorMojo.java:64)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.codehaus.mojo.hibernate3.HibernateExporterMojo.doExecute(HibernateExporterMojo.java:273)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.codehaus.mojo.hibernate3.HibernateExporterMojo.execute(HibernateExporterMojo.java:152)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)</span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">          ... 20 more</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I am using the following hibernate configuration:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;">hibernate.connection.driver_class=<strong>oracle.jdbc.driver.OracleDriver</strong></p><p style="padding-left: 30px;">hibernate.connection.url=<strong>jdbc:oracle:thin:@****</strong></p><p style="padding-left: 30px;">hibernate.connection.username=****</p><p style="padding-left: 30px;">hibernate.connection.password=****</p><p style="padding-left: 30px;">hibernate.dialect=<strong>org.hibernate.dialect.Oracle10gDialect</strong></p><p style="padding-left: 30px;">hibernate.default_schema=<strong>MY_SCHEMA</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>and the following reverse enginerring file:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;"><?xml version="1.0" encoding="UTF-8"?></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;"><!DOCTYPE hibernate-reverse-engineering PUBLIC </span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">  "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" </span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;"><span>  "</span><a class="jive-link-external-small" href="http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" rel="nofollow" target="_blank">http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd</a><span>" ></span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;"> <hibernate-reverse-engineering></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;">      <schema-selection match-schema="<strong>MY_SCHEMA</strong>" /></span></p><p style="padding-left: 30px;"><span style="font-family: 'courier new', courier;"></hibernate-reverse-engineering></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Hope that helps.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/801784#801784">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in JBoss Tools at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2128">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>