<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta content="MSHTML 6.00.3790.3304" name="GENERATOR">
<style title="owaParaStyle"><!--P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
--></style>
</head>
<body ocsi="x">
<div dir="ltr"><font face="Tahoma" color="#000000" size="2">To set the context: Hibernate's reverse engineering feature uses standard JDBC database metadata to automatically generate all the necessary Hibernate config files for working with the target database
in an O/R fashion (<a href="https://www.hibernate.org/hib_docs/tools/reference/en/html/reverseengineering.html"><font face="Times New Roman" size="3">https://www.hibernate.org/hib_docs/tools/reference/en/html/reverseengineering.html</font></a>).</font></div>
<div dir="ltr"><font face="Tahoma" color="#000000" size="2"></font> </div>
<div dir="ltr"><font face="Tahoma" color="#000000" size="2">The getting started guide tells me that Teiid does not currently support reverse engineering via Hibernate. This is somewhat surprising, since Teiid generally supports all the typical JDBC database
metadata, making it easy to connect third-party client tools, etc.</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2">Does anyone on the Teiid development team know what it would take to extend support for reverse engineering? How far off are we here?
</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2">Apparently, Hibernate does provide a few options for working with non-standard sources:</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2">1. Create a custom hibernate.reveng.xml configuration file - This will take care of small issues such as type mismatches, or exclusion of certain tables</font></div>
<div dir="ltr"><font face="tahoma" size="2">2. Extend Hibernate's JDBCMetaDataDialect class with your own implementation</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2">I wonder if either option would allow us to get reverse engineering working with Teiid without having to make significant change to Teiid source. Thoughts?</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><a href="https://www.hibernate.org/hib_docs/tools/reference/en/html/reverseengineering.html"></a> </div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
</body>
</html>