[teiid-dev] Hibernate reverse engineering

[Ted Jones]

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 at amentra.com>
To: "Ramesh Reddy" <rareddy at redhat.com>
Cc: teiid-dev at lists.jboss.org, "Jason Stokes" <jason.stokes at amentra.com>
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 at redhat.com> 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 at redhat.com]
>> Sent: Thursday, March 18, 2010 5:16 PM
>> To: Michael Walker
>> Cc: Jason Stokes; teiid-dev at 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 at amentra.com> 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/reverseengineering.html 
>> ).
>>>
>>> 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 at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/teiid-dev
>> _______________________________________________
>> teiid-dev mailing list
>> teiid-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/teiid-dev
>
_______________________________________________
teiid-dev mailing list
teiid-dev at lists.jboss.org
https://lists.jboss.org/mailman/listinfo/teiid-dev