[teiid-dev] Hibernate reverse engineering

[Amentra]

Thanks guys, I'll install tools and try it out.



On Mar 19, 2010, at 12:53 PM, John Doyle <jdoyle at redhat.com> wrote:

> Mike,
>
> I got this to work in JBoss Tools, I'm sure there it can be done in  
> the ant tasks as well.  I need to follow up with Max to see if there  
> is a more correct way to do this, but if you add the teiid dialect  
> that is delivered in the client directory of Teiid to the global  
> eclipse classpath, reveng works.
>
> In JBoss Tools navigate to Window->Preferences->Java->Installed  
> JRE's.  Select the current JRE and click the Edit button.  Click Add  
> External Jar and navigate to the teiid-hibernate-dialect jar.
>
> ~jd
> ----- "Ted Jones" <tejones at redhat.com> wrote:
>
>> 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
>> _______________________________________________
>> teiid-dev mailing list
>> teiid-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/teiid-dev