Excellent, thanks greatly...

For the first time I have been able to connect to Firebird from within Eclipse...

All I want to do is have my JPA annotations validated (haven't tested that yet, but I am hopeful).

In the past I have played with the idea of exporting my schema to PostgreSQL and using that for validation... (my initial trials proved that that was easier than I thought it was going to be).

It has pushed me towards more seriously looking at PostgreSQL because of the better Eclipse support...

So thanks for your and Roman's work, I for one appreciate it.

Regards
Colin







________________________________
From: Mark Rotteveel <Avalanche1979@...>
To: Firebird-Java@yahoogroups.com
Sent: Sunday, 7 June, 2009 7:09:58 AM
Subject: Re: [Firebird-Java] Using Firebird on Eclipse Ganymede Datatools





A new version of the Eclipse plugin is available on
http://www.lawinege vaar.nl/firebird

Version 1.0.0.200906062028

First step integrating Roman Rokytskyy work.

Changes:
* Used other (generic) UI for connection
* The full jdbc-URL must be used
* Connection now uses two 'virtual' schemas, SYSTEM and USER, to
separate system metadata (RDB$.. and MON$.. tables/views) from the user
metadata
* Sequences (generators) are now visible
* Table-like stored procedures are now grouped under stored procedures
* Constraints are now shown

Gotcha's:
* Untested
* Numeric fields are not shown correctly in the 'edit'-view
(context-menu on a table or view)
* Stored procedure code is not correct (body usually is correct,
but signature is wrong)
* Generated DDL does not contain escapes for use in ISQL
* DDL for sequence/generators cannot be shown yet
* Trigger code is not loaded
* Dependencies are not shown
* Some datatypes introduced in Firebird 2.1 might not work correctly
* The option 'Sample contents' (context menu on a table or view)
does not work

Mark

Mark Rotteveel wrote:

> A basic plugin for Firebird was already written by Brian Fitzpatrick of the Data Tools Platform project. After some changes, this very basic functionality now works. You can find the compiled version at
> http://www.lawinege vaar.nl/firebird
>
> I will be merging/adapting Roman's earlier code in the coming weeks and send out another mail when there is (significant) new functionality.
>
> Mark
>
>> Hi,
>>
>> I've seen a number of posts dated back year 2007 about using Eclipse data
>> tools with Firebird and so far I haven't seen a solution that would allow
>> me to accomplish displaying the tables under schemas.
>>
>> Maybe I'm just not searching hard enough but correct me if I'm wrong but
>> I'm not sure if this problem has been worked on and is this the reason why
>> Firebird is not on the list of supported databases under Eclipse's
>> Connection profile?
>>
>> Or is it just that Eclipse and Firebird dont mix well?
>>
>> Roman, Hellen, anyone?
>
>

--
Mark Rotteveel






[Non-text portions of this message have been removed]