Subject | Re: [Firebird-Java] Eclipse, Dali, JPA - No tables under Schema |
---|---|
Author | C F |
Post date | 2007-03-11T06:50:13Z |
Hi Roman,
Thanks for your reply...
Glad to hear that something is being done! :-)
I was just wondering about the fixes that you mention to DTP 1.0...
My first question would be are these fixes available?
Second question, if they are available, are they easy to apply? I see my current Eclipse 3.2.2 uses 0.9.1
As mentioned, I am just playing and learning at this stage... but have been playing against already existing Firebird databases.
Since it is just playing... it is therefore not mission critical... I could test the Dali part against PostgreSQL, but if the updates are available, and not too difficult to apply, I might give it a try.
Again, thanks for your help and information.
Regards
Colin
----- Original Message ----
From: Roman Rokytskyy <rrokytskyy@...>
To: Firebird-Java@yahoogroups.com
Sent: Sunday, March 11, 2007 12:02:43 PM
Subject: Re: [Firebird-Java] Eclipse, Dali, JPA - No tables under Schema
won't be available in the nearest future. The main problem is that
current version of DTP ignores the "supportsShemas" property of the
database description and generates incorrect SQL in form of
<schema>.<object_ name>, which is not accepted by Firebird. I have
identified 5 such places and submitted appropriate bug reports.
But as we have agreed with DTP developers, the fixes will go into DTP
1.5. Currently I'm working with DTP 1.0 (I have applied my fixes
locally), but will switch to DTP 1.5 soon.
Also the "custom catalog loader" is not enough - there's more extension
points involved including but not limited to DDL generation, database
description, profile management, etc. All they require custom extensions
because the basic JDBC stuff is not enough to make all features working.
So, the answer to your question - yes, we are aware of the issue,
however the solution won't be available soon (beta. let's say,
second-third quarter, release - end of the year).
Roman
<!-- #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0; } #ygrp-tpmsgs{ font-family:Arial; clear:both; } #ygrp-vitnav{ padding-top:10px; font-family:Verdana; font-size:77%; margin:0; } #ygrp-vitnav a{ padding:0 1px; } #ygrp-actbar{ clear:both; margin:25px 0; white-space:nowrap; color:#666; text-align:right; } #ygrp-actbar .left{ float:left; white-space:nowrap; } .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana; font-size:77%; padding:15px 0; } #ygrp-ft{ font-family:verdana; font-size:77%; border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px; } #ygrp-vital{ background-color:#e0ecee; margin-bottom:20px; padding:2px 0 8px
8px; } #ygrp-vital #vithd{ font-size:77%; font-family:Verdana; font-weight:bold; color:#333; text-transform:uppercase; } #ygrp-vital ul{ padding:0; margin:2px 0; } #ygrp-vital ul li{ list-style-type:none; clear:both; border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold; color:#ff7900; float:right; width:2em; text-align:right; padding-right:.5em; } #ygrp-vital ul li .cat{ font-weight:bold; } #ygrp-vital a { text-decoration:none; } #ygrp-vital a:hover{ text-decoration:underline; } #ygrp-sponsor #hd{ color:#999; font-size:77%; } #ygrp-sponsor #ov{ padding:6px 13px; background-color:#e0ecee; margin-bottom:20px; } #ygrp-sponsor #ov ul{ padding:0 0 0 8px; margin:0; } #ygrp-sponsor #ov li{ list-style-type:square; padding:6px 0; font-size:77%; } #ygrp-sponsor #ov li a{ text-decoration:none; font-size:130%; } #ygrp-sponsor #nc { background-color:#eee; margin-bottom:20px; padding:0 8px; } #ygrp-sponsor .ad{ padding:8px 0; } #ygrp-sponsor .ad #hd1{ font-family:Arial;
font-weight:bold; color:#628c2a; font-size:100%; line-height:122%; } #ygrp-sponsor .ad a{ text-decoration:none; } #ygrp-sponsor .ad a:hover{ text-decoration:underline; } #ygrp-sponsor .ad p{ margin:0; } o {font-size:0;} .MsoNormal { margin:0 0 0 0; } #ygrp-text tt{ font-size:120%; } blockquote{margin:0 0 0 4px;} .replbq {margin:4;} -->
____________________________________________________________________________________
Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367
[Non-text portions of this message have been removed]
Thanks for your reply...
Glad to hear that something is being done! :-)
I was just wondering about the fixes that you mention to DTP 1.0...
My first question would be are these fixes available?
Second question, if they are available, are they easy to apply? I see my current Eclipse 3.2.2 uses 0.9.1
As mentioned, I am just playing and learning at this stage... but have been playing against already existing Firebird databases.
Since it is just playing... it is therefore not mission critical... I could test the Dali part against PostgreSQL, but if the updates are available, and not too difficult to apply, I might give it a try.
Again, thanks for your help and information.
Regards
Colin
----- Original Message ----
From: Roman Rokytskyy <rrokytskyy@...>
To: Firebird-Java@yahoogroups.com
Sent: Sunday, March 11, 2007 12:02:43 PM
Subject: Re: [Firebird-Java] Eclipse, Dali, JPA - No tables under Schema
> If this is the problem, does anyone think it likely to be looked intoI have already started to code the Firebird support in DTP. However, it
> in the near future?? From the post, sounds like the Data Tools
> Platform people are willing to help... but I have no idea of what is
> involved...
won't be available in the nearest future. The main problem is that
current version of DTP ignores the "supportsShemas" property of the
database description and generates incorrect SQL in form of
<schema>.<object_ name>, which is not accepted by Firebird. I have
identified 5 such places and submitted appropriate bug reports.
But as we have agreed with DTP developers, the fixes will go into DTP
1.5. Currently I'm working with DTP 1.0 (I have applied my fixes
locally), but will switch to DTP 1.5 soon.
Also the "custom catalog loader" is not enough - there's more extension
points involved including but not limited to DDL generation, database
description, profile management, etc. All they require custom extensions
because the basic JDBC stuff is not enough to make all features working.
So, the answer to your question - yes, we are aware of the issue,
however the solution won't be available soon (beta. let's say,
second-third quarter, release - end of the year).
Roman
<!-- #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0; } #ygrp-tpmsgs{ font-family:Arial; clear:both; } #ygrp-vitnav{ padding-top:10px; font-family:Verdana; font-size:77%; margin:0; } #ygrp-vitnav a{ padding:0 1px; } #ygrp-actbar{ clear:both; margin:25px 0; white-space:nowrap; color:#666; text-align:right; } #ygrp-actbar .left{ float:left; white-space:nowrap; } .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana; font-size:77%; padding:15px 0; } #ygrp-ft{ font-family:verdana; font-size:77%; border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px; } #ygrp-vital{ background-color:#e0ecee; margin-bottom:20px; padding:2px 0 8px
8px; } #ygrp-vital #vithd{ font-size:77%; font-family:Verdana; font-weight:bold; color:#333; text-transform:uppercase; } #ygrp-vital ul{ padding:0; margin:2px 0; } #ygrp-vital ul li{ list-style-type:none; clear:both; border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold; color:#ff7900; float:right; width:2em; text-align:right; padding-right:.5em; } #ygrp-vital ul li .cat{ font-weight:bold; } #ygrp-vital a { text-decoration:none; } #ygrp-vital a:hover{ text-decoration:underline; } #ygrp-sponsor #hd{ color:#999; font-size:77%; } #ygrp-sponsor #ov{ padding:6px 13px; background-color:#e0ecee; margin-bottom:20px; } #ygrp-sponsor #ov ul{ padding:0 0 0 8px; margin:0; } #ygrp-sponsor #ov li{ list-style-type:square; padding:6px 0; font-size:77%; } #ygrp-sponsor #ov li a{ text-decoration:none; font-size:130%; } #ygrp-sponsor #nc { background-color:#eee; margin-bottom:20px; padding:0 8px; } #ygrp-sponsor .ad{ padding:8px 0; } #ygrp-sponsor .ad #hd1{ font-family:Arial;
font-weight:bold; color:#628c2a; font-size:100%; line-height:122%; } #ygrp-sponsor .ad a{ text-decoration:none; } #ygrp-sponsor .ad a:hover{ text-decoration:underline; } #ygrp-sponsor .ad p{ margin:0; } o {font-size:0;} .MsoNormal { margin:0 0 0 0; } #ygrp-text tt{ font-size:120%; } blockquote{margin:0 0 0 4px;} .replbq {margin:4;} -->
____________________________________________________________________________________
Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367
[Non-text portions of this message have been removed]