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> 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?
<
https://www.hibernate.org/hib_docs/tools/reference/en/html/reverseenginee...
_______________________________________________ teiid-dev mailing
list teiid-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/teiid-dev