John,
I'm actually having issues getting this working with Teiid 6.2 and JBoss Tools; maybe
it's easy for you to tell what I'm doing wrong here, since you've got it
working.
First, I've added the teiid-dialect to the JDK global classpath as you've
previously mentioned. Also, on my project build path, I added the teiid-6.2.0-jdbc driver.
Next, I created a config file with the appropriate values (driver, dialect, url, username,
password). I did not define a default schema or catalog, and did not give the session
factory a name.
Then, I created a Hibernate console configuration, which uses the previously-defined
config file, and specifies that the Teiid dialect should be used.
When I try to expand the "Database" tab, it tells me that it can't find the
Teiid dialect. So, I added the dialect to the project classpath as well. After that
addition, the "Database" tab fails silently, with no error in the error log or
console.
I repeated the same process with Oracle, and it succeeded.
Also, I've confirmed that Teiid is running, the JDBC driver is in the classpath, and
the values are correct by running a simple JDBC test client in the same project. The code
is able to establish a connection and execute some sample queries against Teiid.
Do you see anything obvious I'm missing here? Thanks.
________________________________________
From: John Doyle [jdoyle(a)redhat.com]
Sent: Friday, March 19, 2010 3:53 PM
To: Michael Walker
Cc: teiid-dev(a)lists.jboss.org; Jason Stokes; Ted Jones
Subject: Re: [teiid-dev] Hibernate reverse engineering
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(a)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(a)amentra.com>
To: "Ramesh Reddy" <rareddy(a)redhat.com>
Cc: teiid-dev(a)lists.jboss.org, "Jason Stokes"
<jason.stokes(a)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(a)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(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?
>>>
>>>
>>>
>>>
>>
>>> _______________________________________________ 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