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 ( https://www.hibernate.org/hib_docs/tools/reference/en/html/reverseenginee... ). 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. Does anyone on the Teiid development team know what it would take to extend support for reverse engineering? How far off are we here? Apparently, Hibernate does provide a few options for working with non-standard sources: 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 2. Extend Hibernate's JDBCMetaDataDialect class with your own implementation 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? _______________________________________________ teiid-dev mailing list teiid-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-dev

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. ______________________________________________________________________ From: John Doyle [jdoyle(a)redhat.com] Sent: Thursday, March 18, 2010 5:16 PM To: Michael Walker Cc: Jason Stokes; teiid-dev(a)lists.jboss.org Subject: Re: [teiid-dev] Hibernate reverse engineering Hey Mike, 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. 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. ~john ----- "Michael Walker" <michael.walker(a)amentra.com&gt; wrote: > > 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 (https://www.hibernate.org/hib_docs/tools/reference/en/html/reverseenginee...). > > 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. > > Does anyone on the Teiid development team know what it would take to extend support for reverse engineering? How far off are we here? > > Apparently, Hibernate does provide a few options for working with non-standard sources: > > 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 > 2. Extend Hibernate's JDBCMetaDataDialect class with your own implementation > > 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? > > > > > _______________________________________________ teiid-dev mailing list teiid-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-dev _______________________________________________ teiid-dev mailing list teiid-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-dev