[Info-Ingres] Eclipse installation ... and more ...
Martin Bowes
Hi All,
I'm trying to install eclipse on my PC and establish a connection to an Ingres database.
I'm trying to create the connection profile and have followed the instructions:
Click Window, Open Perspective, Other in the Eclipse SDK.
The Open Perspective dialog appears.
Select the Database Development perspective and click OK.
In the Data Source Explorer, right-click the Database folder and select New from the context menu.
The New Connection Profile dialog appears.
Select the “Ingres JDBC Connection” wizard and click Next.
At which point I get a pop-up with the message:
Error loading new wizard in "org.eclipse.datatools.enablement.ingres.profile"!
Anyone (this means you Emma!) got any idea what I've done wrong?
And why am I trying to do this? Not a day goes by I don't ask myself the same thing!
I have a user who downloaded eclipse and now swears to me that they cannot run the following update:
update xy_dup_attributes e
from xy_dupl_NID_TEL d
set nid = 1, nid_tel=1
where d.studyid = e.studyid and d.creation_date=e.creation_date
my test steps:
put above code in a SQL file in Eclipse;
select the code;
press alt+X keys;
Syntax error. Last symbol read was: 'set'.
And the only way they can get that error message is if the eclipse has removed that pesky 'update … from …' crap at the start of the statement….which I don't believe for a second.
Kristoff
wrote:
> statement....which I don't believe for a second.
Don't know why the installation of eclipse fails on your PC.
I did a quick test with "SQuireL" where you also can execute SQL
statements via JDBC. The update statement works fine there, but when
there is a newline before the set you will get the same error.
In fact SQuirelL passes only the part of the statement after the LAST
newline, so if there is a newline before the where, you get the syntax
error for the where. This is a problem in SQuireL, not in the Ingres
JDBC driver, you can see the truncated statements in the jdbc trace.
In a standalone java program newlines within a SQL statement doesn't
harm, the command is still executed.
May be Eclipse has the same problem as SQuireL.
Kristoff
Kristoff
> Don't know why the installation of eclipse fails on your PC.
> I did a quick test with "SQuireL" where you also can execute SQL
> statements via JDBC. The update statement works fine there, but when
> there is a newline before the set you will get the same error.
> In fact SQuirelL passes only the part of the statement after the LAST
> newline, so if there is a newline before the where, you get the syntax
> error for the where. This is a problem in SQuireL, not in the Ingres
> JDBC driver, you can see the truncated statements in the jdbc trace.
> In a standalone java program newlines within a SQL statement doesn't
> harm, the command is still executed.
> May be Eclipse has the same problem as SQuireL.
>
Just to clarify, I mean a second newline between two lines, i.e. if
there is an empty line between the "from" line and the "set" line.
With eclipse (using the Ingres Eclipse Bundle) I have my problems
either, took me some time (and one million mouse clicks) to get a SQL
file.
But yes, your user is right, you get this error (whether there is a
newline or not). Again, this is not really a problem with the JDBC
driver, eclipse simply forgets to pass everything before the the
"set" ....
So the big question is: What is eclipse doing with that nice SQL
statement?
Kristoff
Martin Bowes
It staggers me that no one has noticed that a simple update statement is
stuffed.
It further staggers me that I can't install the bitch of a thing on my
PC. I still get the message:
Error loading new wizard in
"org.eclipse.datatools.enablement.ingres.profile"!
I've tried Googling that message but with no success. I also tried the
other connection profile wizards in that section and all of them seem to
work perfectly well.
So I'm stuffed at the moment. Merry F'ing Christmas.
Marty
Kristoff
_______________________________________________
Info-Ingres mailing list
Info-...@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
emma.mc...@gmail.com
wrote:
>
> Error loading new wizard in
> "org.eclipse.datatools.enablement.ingres.profile"!
>
> Anyone (this means you Emma!) got any idea what I've done wrong?
>
At first blush it looks like you're missing the Ingres DTP plugin.
That's not a standard plugin with an Eclipse download yet, but has
recently been accepted into the Eclipse CVS source code control system
so will be a standard part of the download going forward. You need to
get the DTP for Ingres to give you Ingres functionality. I'm fairly
sure that's what's causing the error you're seeing.
As a shortcut to prove/disprove your user's claim you can pull the
Ingres Database Workbench, the link to which I posted on my blog last
week, and try it out in there. That's a nicely cut down version of
Eclipse just for situations like this.
Let me know how it goes
Em
Martin Bowes
I've just downloaded the idw-I20081219-1557-win32.win32.x86.zip and have
tried to unpack it on my PC.
Its just told me:
File 'org.eclipse.equinox.launcher...' is password protected. Please
enter the password...
Any ideas?
BTW. Its one of many files which are password protected.
Marty
-----Original Message-----
From: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of
emma.mc...@gmail.com
Sent: 24 December 2008 00:07
To: info-...@kettleriverconsulting.com
Subject: Re: [Info-Ingres] Eclipse installation ... and more ...
Em
_______________________________________________
Martin Bowes
Ignore my prior mail. I'm an idiot and can't spell until I've had more
coffee.
Marty
-----Original Message-----
From: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of
emma.mc...@gmail.com
Sent: 24 December 2008 00:07
To: info-...@kettleriverconsulting.com
Subject: Re: [Info-Ingres] Eclipse installation ... and more ...
Em
_______________________________________________
Emma K. McGrattan
Maybe you could add a drop of whiskey to the coffee in my honour ;). I really hope you have better luck with it and somehow get shifted over to the Christmas Spirit.
Martin Bowes
Sorry that should have read…
This works:
update this_table
set nid=1, nid_tel=1
But this doesn't:
update this_table d
set nid=1, nid_tel=1
Marty
Jeremy MB. Peel
Happy New Year Marty,
I’ve just tried your script using IDW Build id: I20081219-1557.
In this IDW version the UPDATE…FROM statement seems to work even though the Outline View fails to recognize the UPDATE with correlation name:
/*
* UPDATE...FROM with correlation name
*/
update this_table d
from join2this e
set nid=2, nid_tel=2
and d.a_date=e.a_date;
Despite the outline view failure, did the statement execute successfully?
Thanks,
Jeremy
From: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of Martin Bowes
Sent: 24 December 2008 15:52
To: Ingres and related product
discussion forum
Cc: Emma K. McGrattan
Subject: Re: [Info-Ingres] Eclipse
installation ... and more ...
Sorry that should have read…
Martin Bowes
Hi Jeremy,
No it doesn't execute correctly. It strips the update … from … part and only sends the query from 'set' onwards. Hence I get the error:
Syntax error. Last symbol read was: 'set'.
The Eclipse I have is: v3.2.1
Build Id: M20060921-0945
Which would seem to suggest I have an elderly version is that correct? I just downloaded it from the esd.ingres a few weeks ago so I would have thought it would be uptodate.
Marty
Martin Bowes
Hi Jeremy,
I just downloaded the Christmas IDW …swore mightily… GOD I HATE F'ING IDE's…
Version: 0.0.2
Build id: I20081219-1557
And promptly got the update query to work.
It looks like this is a problem in the older version of Eclipse that I've downloaded from esd.ingres.
I'm going to re-do the download and see if I get the same version.