<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">P {
MARGIN: 0px
}
</style>
<meta content="MSHTML 6.00.3790.3304" name="GENERATOR">
</head>
<body ocsi="x">
<div dir="ltr"><font face="Tahoma" color="#000000" size="2">Thanks John. Let me know the JIRA and I'll follow it. I agree that this seems like something we should be capable of currently.</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div id="divRpF953009" style="DIRECTION: ltr">
<hr tabindex="-1">
<font face="Tahoma" size="2"><b>From:</b> John Doyle [jdoyle@redhat.com]<br>
<b>Sent:</b> Thursday, March 18, 2010 5:16 PM<br>
<b>To:</b> Michael Walker<br>
<b>Cc:</b> Jason Stokes; teiid-dev@lists.jboss.org<br>
<b>Subject:</b> Re: [teiid-dev] Hibernate reverse engineering<br>
</font><br>
</div>
<div></div>
<div>
<div style="FONT-SIZE: 12pt; COLOR: #000000; FONT-FAMILY: Times New Roman">Hey Mike,<br>
<br>
I just tried to reverse engineer a 6.2 teiid vdb, because I thought your central thrust here was incorrect and that we had everything we needed already, and it fails. The tooling can't find our dialect. It's in all the lists, but the classes are not getting
found.<br>
<br>
I believe this to be a defect, and that with the latest release of JBossTools you should be able to reverse engineer a Teiid VDB. I'll see about tracking down the issue and logging a Jira.<br>
<br>
~john<br>
----- "Michael Walker" <michael.walker@amentra.com> wrote: <br>
> <style title="owaParaStyle"><!--P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
--></style>
<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" target="_blank"><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" target="_blank">
</a> </div>
<div dir="ltr">> <font face="tahoma" size="2"></font> </div>
<div dir="ltr">> <font face="tahoma" size="2"></font> </div>
<br>
> _______________________________________________ teiid-dev mailing list teiid-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-dev
</div>
</div>
</body>
</html>