Re: [teiid-dev] Hibernate reverse engineering

FWIW, I was able to reverse engineer using JBossTools 2.0.1 and Teiid 6.2. This was before the Teiid dialect was added to JBossTools. I documented the process here: http://community.jboss.org/wiki/RESTEasywithTeiid. The workaround I had to use do to the absence of the Teiid Hibernate dialect should work for the latest JBossTools as well. My example involved creating a SEAM web app, but that shouldn't be a requirement to get the Hibernate objects created Ted ----- Original Message ----- From: "Amentra" <michael.walker(a)amentra.com&gt; To: "Ramesh Reddy" <rareddy(a)redhat.com&gt; Cc: teiid-dev(a)lists.jboss.org, "Jason Stokes" <jason.stokes(a)amentra.com&gt; Sent: Thursday, March 18, 2010 9:08:37 PM GMT -06:00 US/Canada Central Subject: Re: [teiid-dev] Hibernate reverse engineering It is typically run as an ant task, and behavior is tweaked via a config file. On Mar 18, 2010, at 3:15 PM, Ramesh Reddy <rareddy(a)redhat.com&gt; wrote: > Does Hibernate support command line reverse engineering? > > On Thu, 2010-03-18 at 16:26 -0500, Michael Walker wrote: >> 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 > _______________________________________________ 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