Re: [teiid-dev] Teiid dialect in Hibernate

John, I did some testing with the Hibernate Test Suite using Hibernate Branch_3_2_4_SP1_CP. This was just to determine what issues would be exposed with the Dialect. The test reports running with the MetaMatrix Dialect and the Oracle Dialect can be seen here: http://dev39.qa.atl.jboss.com/~smcgowan/hibernate-reports/MetaMatrix/test... http://dev39.qa.atl.jboss.com/~smcgowan/hibernate-reports/Oracle/test-rep... I also generated DDL using the MM dialect: http://dev39.qa.atl.jboss.com/~smcgowan/hibernate-reports/DDL/DDL-MetaMat... After generating the DDL, we populated the databases with the tables. We did find, however, that tests reuse the same Table name with a different table structure. Shelly ----- Original Message ----- From: "John Doyle" <jdoyle(a)redhat.com&gt; To: "Ramesh Reddy" <rareddy(a)redhat.com&gt;, "Shelly McGowan" <smcgowan(a)redhat.com&gt; Cc: "teiid-dev" <teiid-dev(a)lists.jboss.org&gt; Sent: Wednesday, March 24, 2010 10:17:05 AM GMT -05:00 US/Canada Eastern Subject: Re: [teiid-dev] Teiid dialect in Hibernate Hey Shelly, You did some work a year or so ago in order to get some AS/Hibernate tests working with the Teiid dialect. Do you have any insight or suggestions on this issue? How did you workaround the DDL problem? ~jd ----- "Ramesh Reddy" <rareddy(a)redhat.com&gt; wrote: > I had IRC conversation with Steve Ebersole about adding the Teiid > Dialect to the Hibernate Core in the next upcoming 3.5 release. > > He is not willing to accept any dialects that are not testable from > their testing framework. He said Hibernate uses a schema export tool > that issues some DDL queries through JDBC interface for their testing > to > work. > > Since Teiid driver does not support the DDL currently, issuing the > DDL > is not possible. He suggested that we look into ways to > 1) delegate the DDL calls either through the TeiidDriver > (https://jira.jboss.org/jira/browse/TEIID-669) > or > 2) devise a way in their schema export tool to delegate the DDL > class. > > also, since they already have two CR releases, chances of getting > into > 3.5 release seems slim. However, if we can make it that would be > great. > > Any suggestions? volunteers? > > Thanks. > > Ramesh.. > > On Tue, 2010-03-23 at 13:05 -0500, Ramesh Reddy wrote: > > I am not dis-agreeing. Just wanted to what our options were. > > > > I do think it is valuable for Teiid be included along with > Hibernate. > > They are about to release 3.5 very soon, we need to see if we can > make > > it into 3.5 final release. > > > > So, instead of making this JIRA in the Tools, we need to make this > into > > Hibernate by communicating with its lead. > > > > > > Thanks > > > > Ramesh.. > > > > On Tue, 2010-03-23 at 11:01 -0400, John Doyle wrote: > > > Ramesh-The drivers are supplied by the DataTools > ConnectionProfiles > > > and Drivers that you have to define before you use Hibernate, so > > > drivers are a different issue, and not something that the > hibernate > > > plug-ins have 'built in'. It's an configuration step that's > already > > > extensible in a way that Dialects don't appear to be. > > > > > > I'm personally in favor of including our dialect in Hibernate > because > > > then Tools will just work, there won't be some additional step > for > > > Teiid. It seems to me that if Oracle just works out of the box > in > > > Tools, then a fellow JBoss project should just work. The only > > > downside I can see to including our dialect in Hibernate is that > our > > > release cycles don't match up and changes/maintenance would have > to be > > > managed across our differing cycles. > > > > _______________________________________________ > > 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