Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » cant create new driver definition for derby.jar
cant create new driver definition for derby.jar [message #46378] Tue, 08 July 2008 00: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

I was trying to follow this tutorial. I created a new project called
DTPDatabaseAccess, created a folder lib in there, and copied my derby.jar
from
/usr/lib/javadb/lib/ to /home/cuco/workspace/DTPDatabaseAccess/lib. I did
this manually then hit refresh from within eclipse and derby.jar did show
up
in the Package Explorer, so eclipse knows about it.

Here, by the way, is the link for the tutorial I mentioned above:

http://www.vogella.de/articles/EclipseDataToolsPlatform/arti cle.html

I get to the section titled 'Configuration' and do this:

Define the driver for the derby access. Go to Window-> Preferences and
select "Data Management" -> Connectivity -> Driver Definition. Press Add.
Select Derby and the version you want to use. Select then the tab jar
press Add and select the derby.jar (which contains the driver).

WHen I follow these directions a window comes up saying 'New Driver
Definition'
and under that it says 'Specify a Driver Definition and Template Name'.
I select derby.jar, click 'Add Jar/Zip File' and get this error:

Unable to locate JAR/zip in file system as specified by the driver
definition: derby.jar.


Anybody have any ideas what could be wrong ? THanks in advance.
Is it possible that
I need to download an 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: cant create new driver definition for derby.jar [message #46469 is a reply to message #46378] Tue, 08 July 2008 12:18 Go to previous messageGo to next message
Enrico Schenk is currently offline Enrico Schenk
Messages: 23
Registered: July 2009
Junior Member
Hi Adam

Adam Posner wrote:
[...]
> Define the driver for the derby access. Go to Window-> Preferences and
> select "Data Management" -> Connectivity -> Driver Definition. Press
> Add. Select Derby and the version you want to use. Select then the tab
> jar press Add and select the derby.jar (which contains the driver).
>
> WHen I follow these directions a window comes up saying 'New Driver
> Definition'
> and under that it says 'Specify a Driver Definition and Template Name'.
> I select derby.jar, click 'Add Jar/Zip File' and get this error:
>
> Unable to locate JAR/zip in file system as specified by the driver
> definition: derby.jar.
[...]

This usually message means that you have a file in the "Jar List" that
DTP cannot resolve. Can you replace the entry "derby.jar" with the
location of the derby.jar on your system (e.g.
/home/cuco/workspace/DTPDatabaseAccess/lib/derby.jar)? You can do this
by using the buttons on the right in the "Jar List" tab.

Thanks
Rico
Re: cant create new driver definition for derby.jar [message #46553 is a reply to message #46469] Tue, 08 July 2008 17:35 Go to previous messageGo to next message
Eclipse User
Originally posted by: cuco2772.gmail.com

I did try that. Unfortunately, got the same result, though.
This is turning out to be a perplexing problem.
Re: cant create new driver definition for derby.jar [message #46740 is a reply to message #46553] Thu, 10 July 2008 15:12 Go to previous message
Eclipse User
Originally posted by: brianf.sybase.com

The five plugins with "Apache Derby" in them you mentioned in your initial
post are all for providing Derby functionality within DTP. None of them
directly contributes the Derby "derby.jar"

It sounds however that you have the Derby installation at
/usr/lib/javadb/lib

So... Try this.

1) Go to the Preferences dialog (Window->Preferences)
2) Drill down to the Driver Definitions preference page (Data
Management->Connectivity->Driver Definitions)
3) Click Add...
4) Select one of the Derby drivers (Derby Embedded JDBC Driver for version
10.0, 10.1, or 10.2 etc.)
5) Go to the Jar List tab.
6) Select the derby.jar file in the list. Click Edit Jar/Zip...
7) Using the file browse dialog, find the derby.jar on your machine
(probably in your /usr/lib/javadb/lib directory)
8) Click OK on the file browse dialog.
9) Verify on the New Driver Definition dialog that you don't have that error
about the jar not being found.
10) Click OK on the New Driver Definition dialog.
11) Then go to create a new Derby connection profile.

Let me know if that helps at all.

Another possibility is to go grab the Apache Derby plug-in wrapper from the
Apache Derby site
( http://archive.apache.org/dist/db/derby/db-derby-10.1.1.0/de rby_core_plugin_10.1.1.zip)
and drop that into your Eclipse installation (/eclipse/plugins or
/eclipse/dropins) and restart your workbench. It should (fingers crossed)
pick up on the fact that the plug-in exists in the Eclipse directories and
create a new derby driver definition for you by default.

--Fitz

"Adam Posner" <cuco2772@gmail.com> wrote in message
news:7ef1646e837c77152f48873901ca1a63$1@www.eclipse.org...
>I did try that. Unfortunately, got the same result, though.
> This is turning out to be a perplexing problem.
>
Re: cant create new driver definition for derby.jar [message #591779 is a reply to message #46378] Tue, 08 July 2008 12:18 Go to previous message
Enrico Schenk is currently offline Enrico Schenk
Messages: 23
Registered: July 2009
Junior Member
Hi Adam

Adam Posner wrote:
[...]
> Define the driver for the derby access. Go to Window-> Preferences and
> select "Data Management" -> Connectivity -> Driver Definition. Press
> Add. Select Derby and the version you want to use. Select then the tab
> jar press Add and select the derby.jar (which contains the driver).
>
> WHen I follow these directions a window comes up saying 'New Driver
> Definition'
> and under that it says 'Specify a Driver Definition and Template Name'.
> I select derby.jar, click 'Add Jar/Zip File' and get this error:
>
> Unable to locate JAR/zip in file system as specified by the driver
> definition: derby.jar.
[...]

This usually message means that you have a file in the "Jar List" that
DTP cannot resolve. Can you replace the entry "derby.jar" with the
location of the derby.jar on your system (e.g.
/home/cuco/workspace/DTPDatabaseAccess/lib/derby.jar)? You can do this
by using the buttons on the right in the "Jar List" tab.

Thanks
Rico
Re: cant create new driver definition for derby.jar [message #591805 is a reply to message #46469] Tue, 08 July 2008 17:35 Go to previous message
Adam Posner is currently offline Adam Posner
Messages: 8
Registered: July 2009
Junior Member
I did try that. Unfortunately, got the same result, though.
This is turning out to be a perplexing problem.
Re: cant create new driver definition for derby.jar [message #591876 is a reply to message #46553] Thu, 10 July 2008 15:12 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
The five plugins with "Apache Derby" in them you mentioned in your initial
post are all for providing Derby functionality within DTP. None of them
directly contributes the Derby "derby.jar"

It sounds however that you have the Derby installation at
/usr/lib/javadb/lib

So... Try this.

1) Go to the Preferences dialog (Window->Preferences)
2) Drill down to the Driver Definitions preference page (Data
Management->Connectivity->Driver Definitions)
3) Click Add...
4) Select one of the Derby drivers (Derby Embedded JDBC Driver for version
10.0, 10.1, or 10.2 etc.)
5) Go to the Jar List tab.
6) Select the derby.jar file in the list. Click Edit Jar/Zip...
7) Using the file browse dialog, find the derby.jar on your machine
(probably in your /usr/lib/javadb/lib directory)
8) Click OK on the file browse dialog.
9) Verify on the New Driver Definition dialog that you don't have that error
about the jar not being found.
10) Click OK on the New Driver Definition dialog.
11) Then go to create a new Derby connection profile.

Let me know if that helps at all.

Another possibility is to go grab the Apache Derby plug-in wrapper from the
Apache Derby site
( http://archive.apache.org/dist/db/derby/db-derby-10.1.1.0/de rby_core_plugin_10.1.1.zip)
and drop that into your Eclipse installation (/eclipse/plugins or
/eclipse/dropins) and restart your workbench. It should (fingers crossed)
pick up on the fact that the plug-in exists in the Eclipse directories and
create a new derby driver definition for you by default.

--Fitz

"Adam Posner" <cuco2772@gmail.com> wrote in message
news:7ef1646e837c77152f48873901ca1a63$1@www.eclipse.org...
>I did try that. Unfortunately, got the same result, though.
> This is turning out to be a perplexing problem.
>
Previous Topic:Derby fails to create database
Next Topic:is there any samples for dtp consumer application ?
Goto Forum:
  


Current Time: Fri Sep 19 06:04:32 GMT 2014

Powered by FUDForum. Page generated in 0.11344 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software