Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Web Tools Project (WTP) » Installing derby with Ganymede
Installing derby with Ganymede [message #217017] Mon, 07 July 2008 17:25 Go to next message
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 00:39 Go to previous messageGo to next message
Russell Bateman is currently offline Russell Bateman
Messages: 3157
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

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 13:49 Go to previous messageGo to next message
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 19:31 Go to previous messageGo to next message
Russell Bateman is currently offline Russell Bateman
Messages: 3157
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

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 #217199 is a reply to message #217017] Wed, 09 July 2008 09:46 Go to previous messageGo to next message
David Williams is currently offline David Williams
Messages: 696
Registered: July 2009
Senior Member
On Mon, 07 Jul 2008 17:25:27 -0400, Adam Posner <cuco2772@gmail.com> wrote:

> Hello all. I have Eclipse 3.4 with WTP (I downloaded the all-in-one for
> Java EE
> ...
>
> 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:
>
> ...
> If it turns out I do need to download this, what directory should it go in


Here's a few instructions I once got on how to test Derby with Java EE IDE (can't say I did
test db connections, but ... if it help you ...



* Download the latest Apache Derby core plug-in (do a Google search for "Derby 10 Core Plug-in for Eclipse" and you will probably find it)
* --OR--
* Download the Apache Derby 10.1.2 plug-in from Orbit (this links to the current recommended build - http://download.eclipse.org/tools/orbit/downloads/drops/R200 709171314/bundles/org.apache.derby_10.1.2.1_v200706111724.ja r)
* Copy the plug-in into your Eclipse/plugins directory.
Re: Installing derby with Ganymede [message #217270 is a reply to message #217199] Wed, 09 July 2008 18:28 Go to previous messageGo to next message
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 18:39 Go to previous message
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.
Previous Topic:can not add breakpoint inside javascript
Next Topic:JSDT - jsDoc not used for code completion?
Goto Forum:
  


Current Time: Fri Aug 29 22:37:28 EDT 2014

Powered by FUDForum. Page generated in 0.02303 seconds