Home » Language IDEs » ServerTools (WTP) » Installing derby with Ganymede
Installing derby with Ganymede [message #217017] |
Mon, 07 July 2008 21:25 |
Eclipse User |
|
|
|
Originally posted by: cuco2772.gmail.com
Hello all. I have Eclipse 3.4 with WTP (I downloaded the all-in-one for
Java EE
development). I want to use Apache Derby or something that allows me to
connect to a DBMS. From what I could tell, it seems like the DTP already
comes with this version of Eclipse. For ex, here is the last few lines of
output from when I do 'locate derby': (These are all .jar files, but the
names are too long to show the whole thing)
/home/cuco/eclipse/plugins/org.eclipse.datatools.sqltools.db .derby_1.0.0.v200805152355.jar
/home/cuco/eclipse/plugins/org.eclipse.datatools.connectivit y.apache.derby_1.0.1.v200805152355.jar
/home/cuco/eclipse/plugins/org.eclipse.datatools.connectivit y.apache.derby.dbdefinition_1.0.0.v200805152355.jar
/home/cuco/eclipse/plugins/org.eclipse.datatools.modelbase.d erby_1.0.0.v200805152355.jar
/home/cuco/eclipse/plugins/org.eclipse.datatools.connectivit y.apache.derby.ui_1.0.0.v200805160737.jar
I do also have a regular derby.jar in /usr/lib/javadb/lib
So my question is, do I need to download the additional plugin found here:
http://www.eclipse.org/articles/article.php?file=Article-Ecl ipseDbWebapps/index.html
This Derby plugin for Eclipse is listed under the 'Prerequisites' section.
Note that these directions are for eclipse 3.3 and I have 3.4.
If it turns out I do need to download this, what directory should it go in
?
THanks
|
|
|
Re: Installing derby with Ganymede [message #217033 is a reply to message #217017] |
Tue, 08 July 2008 04:39 |
|
Adam Posner wrote:
> Hello all. I have Eclipse 3.4 with WTP (I downloaded the all-in-one for
> Java EE
> development). I want to use Apache Derby or something that allows me to
> connect to a DBMS. From what I could tell, it seems like the DTP already
> comes with this version of Eclipse. For ex, here is the last few lines
> of output from when I do 'locate derby': (These are all .jar files, but
> the names are too long to show the whole thing)
>
> /home/cuco/eclipse/plugins/org.eclipse.datatools.sqltools.db .derby_1.0.0.v200805152355.jar
>
> /home/cuco/eclipse/plugins/org.eclipse.datatools.connectivit y.apache.derby_1.0.1.v200805152355.jar
>
> /home/cuco/eclipse/plugins/org.eclipse.datatools.connectivit y.apache.derby.dbdefinition_1.0.0.v200805152355.jar
>
> /home/cuco/eclipse/plugins/org.eclipse.datatools.modelbase.d erby_1.0.0.v200805152355.jar
>
> /home/cuco/eclipse/plugins/org.eclipse.datatools.connectivit y.apache.derby.ui_1.0.0.v200805160737.jar
>
>
> I do also have a regular derby.jar in /usr/lib/javadb/lib
>
> So my question is, do I need to download the additional plugin found here:
>
> http://www.eclipse.org/articles/article.php?file=Article-Ecl ipseDbWebapps/index.html
>
>
> This Derby plugin for Eclipse is listed under the 'Prerequisites' section.
> Note that these directions are for eclipse 3.3 and I have 3.4.
>
> If it turns out I do need to download this, what directory should it go
> in ?
> THanks
>
I had some trouble back a few months ago using Derby. Including trying
to figure out some of this stuff. I was following the first tutorial in
the Eclipse Web Tools Platform text by Dai, Mandel and Ryman. Mandel was
able to help on the Eclipse end, but not so much with Derby. The text
was written to an early version of DTP and Derby.
I'm not at all saying it doesn't work, but I was unable to do what I
needed with it and it seemed to be trouble in DTP. (By the way, DTP has
its own newsgroup you should probably post this to.)
In the end, I used MySQL and forgot about trying to get SQL statements
to work with Derby directly from DTP in the Eclipse workbench or use
Derby from Java code. I was already used to using MySQL and just went
back to it instead of bashing my head against Derby.
Again, I'm not saying it doesn't work, just that I couldn't make it work
and no one ultimately answered the magical question in the DTP newsgroup
that unlocked the secret for me.
Russ
|
|
|
Re: Installing derby with Ganymede [message #217086 is a reply to message #217033] |
Tue, 08 July 2008 17:49 |
Eclipse User |
|
|
|
Originally posted by: cuco2772.gmail.com
Russ wrote:
I had some trouble back a few months ago using Derby. Including trying to
figure out some of this stuff. I was following the first tutorial in the
Eclipse Web Tools Platform text by Dai, Mandel and Ryman. Mandel was able
to help on the Eclipse end, but not so much with Derby. The text was
written to an early version of DTP and Derby.
I'm not at all saying it doesn't work, but I was unable to do what I
needed with it and it seemed to be trouble in DTP. (By the way, DTP has
its own newsgroup you should probably post this to.)
In the end, I used MySQL and forgot about trying to get SQL statements to
work with Derby directly from DTP in the Eclipse workbench or use Derby
from Java code. I was already used to using MySQL and just went back to it
instead of bashing my head against Derby.
Again, I'm not saying it doesn't work, just that I couldn't make it work
and no one ultimately answered the magical question in the DTP newsgroup
that unlocked the secret for me.
Hey, Russ. Thanks for the reply. I did post on the DTP newsgroup after I
realized that that would be a better place to get info on this.
What's weird is, everything went exactly according to that last tutorial I
posted the link to, it found derby.jar, everything showed up in the
Package Explorer as you'd expect, but then I got the message 'unable to
........'.
The MySQL JDBC driver shows up by default, I should be able to use that.
How did you set up just a regular old MySQL connection from eclipse ?
Is there a driver you have to copy into an eclipse directory > THanks
|
|
|
Re: Installing derby with Ganymede [message #217153 is a reply to message #217086] |
Tue, 08 July 2008 23:31 |
|
Adam Posner wrote:
> [snip]
>
> Hey, Russ. Thanks for the reply. I did post on the DTP newsgroup after I
> realized that that would be a better place to get info on this.
> What's weird is, everything went exactly according to that last tutorial
> I posted the link to, it found derby.jar, everything showed up in the
> Package Explorer as you'd expect, but then I got the message 'unable to
> .......'.
>
> The MySQL JDBC driver shows up by default, I should be able to use that.
> How did you set up just a regular old MySQL connection from eclipse ?
> Is there a driver you have to copy into an eclipse directory > THanks
>
Actually, I could look around in my old code and send you something, but
it might better to peruse quickly my group's J2EE site, specifically the
first article in the syllabus on database. I went through that a little
while ago and updated it a little bit. You probably don't have to follow
the whole thing, just look down until it gets to places that interest you.
If you need a Java example better than the one there, I have one that
was working a few months ago and I'll send it to you. Just ask. But I
think you're asking about the JDBC driver. That's explained in the
syllabus, I think.
http://www.windofkeltia.com/j2ee/
Russ
|
|
| |
Re: Installing derby with Ganymede [message #217270 is a reply to message #217199] |
Wed, 09 July 2008 22:28 |
Eclipse User |
|
|
|
Originally posted by: cuco2772.gmail.com
Thanks for the tip. It almost worked. I put the plugin in /plugins, started
eclipse and created the database. Everything was going well until I got to
the part where the '
New Derby Connection Profile' window comes up and I fill in the details
and press
'Finish' for the wizard to complete. Instead of connecting to the database
I get
this error:
Error creating SQL Model Connection to New Derby.(Error: Failed to create
database '/home/cuco/DerbyDatabases/MyNewDB')
Error creating JDBC Connection to New Derby - Failed to create database
I will post this over in DTP also. So far, though, I've received more
useful
info from here. THanks
|
|
|
Re: Installing derby with Ganymede [message #217278 is a reply to message #217270] |
Wed, 09 July 2008 22:39 |
Eclipse User |
|
|
|
Originally posted by: cuco2772.gmail.com
I just realized I should edit the above comment to say 'everything went
well
with the driver definition part, finding the plugin'.
From my error it looks like it didn't even create the database, so I was
erroneous in saying that it did that part ok.
|
|
|
Goto Forum:
Current Time: Wed Sep 25 14:14:18 GMT 2024
Powered by FUDForum. Page generated in 0.12048 seconds
|