 | |
[Info-Ingres] Eclipse installation ... and more ...
comp.databases.ingres comp.databases.ingres
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
[Info-Ingres] Eclipse installation ... and more ... -
12-22-2008
, 05:54 AM
#2
| |||
| |||
|
|
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. |
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
#3
| |||
| |||
|
|
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. |
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
#4
| |||
| |||
|
|
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. |
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
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres
#5
| |||
| |||
|
|
Error loading new wizard in "org.eclipse.datatools.enablement.ingres.profile"! Anyone (this means you Emma!) got any idea what I've done wrong? |
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
#6
| |||
| |||
|
|
Error loading new wizard in "org.eclipse.datatools.enablement.ingres.profile"! Anyone (this means you Emma!) got any idea what I've done wrong? |
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
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres
#7
| |||
| |||
|
|
Error loading new wizard in "org.eclipse.datatools.enablement.ingres.profile"! Anyone (this means you Emma!) got any idea what I've done wrong? |
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
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres
#8
| |||
| |||
|
#9
| |||
| |||
|
#10
| |||
| |||
|
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.