Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » DB explorer and Date output view
DB explorer and Date output view [message #42772] Thu, 06 March 2008 15:51 Go to next message
Eclipse UserFriend
Originally posted by: salamlinux.free.fr

Hi, I have a fresh new eclipse setup on linux, used update manager to
download and install WTP and DTP.
I understood that I should have in windows > other views > Data (DB
explorer and Data output views) which is not the case.
Am I missing a plugin or it is a configuration issue.
Thanks in advance
Re: DB explorer and Date output view [message #42803 is a reply to message #42772] Thu, 06 March 2008 18:51 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: Jerry.Cox.sas.nospam.com

If DTP and all required dependencies are installed, present in your
configuration (Help->Software Updates->Manage Configuration), and enabled,
then

In Window->ShowViews...->Other...

you should have
Connectivity->Database Explorer
SQL Development->Execution Plan
SQL Development->SQL Results



salamlinux@free.fr (eliassal) wrote in
news:2193c30b8841654e99fd619e445da4e6$1@www.eclipse.org:

> Hi, I have a fresh new eclipse setup on linux, used update manager to
> download and install WTP and DTP.
> I understood that I should have in windows > other views > Data (DB
> explorer and Data output views) which is not the case.
> Am I missing a plugin or it is a configuration issue.
> Thanks in advance
Re: DB explorer and Date output view [message #42834 is a reply to message #42803] Thu, 06 March 2008 20:07 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: salamlinux.free.fr

Yes, I think I have setup everything correfctly through update manager.
Still, in other view > connectivity, I have only Data Source Explorer but
not DataBase Explorer nor Data output.
When using update manager, I have a link to Data tools platform, I thgink
this is the project I need, please confirm
Re: DB explorer and Date output view [message #42865 is a reply to message #42834] Thu, 06 March 2008 22:18 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: Jerry.Cox.sas.nospam.com

You and I are using different versions of datatools.

At 1.6 the view name is "Database Explorer".
In previous versions, the view name was "Data Source Explorer".

I have never heard of a "Data output" view in datatools (at least in 1.5 or
1.6). I think you are referring to the "SQL Results" view. You can check
this by opening the "Database Development" perspective and verifying the
name on the tab of the view you want.

As I said in my previous mail, if datatools are properly installed,
configured, and enabled, the SQL Results view can be found in
SQL Development->SQL Results. It is not in the Connectivity category.



salamlinux@free.fr (eliassal) wrote in
news:0cc61d8a54221dc9051ddf8600263b1c$1@www.eclipse.org:

> Yes, I think I have setup everything correfctly through update
> manager. Still, in other view > connectivity, I have only Data Source
> Explorer but not DataBase Explorer nor Data output.
> When using update manager, I have a link to Data tools platform, I
> thgink this is the project I need, please confirm
>
>
Re: DB explorer and Date output view [message #42896 is a reply to message #42865] Fri, 07 March 2008 07:52 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: salamlinux.free.fr

My installation is a fresh one, I downloaded the most recent for full
eclipse on linux from eclipse .org, then I used update manager, I added a
reference to Callisto and this aqdded other references top download sites
including the data tools platform.

Question : how can I check which version update manager installed?

Why I am trying to understand is because of this problem I am having :in
Data source explorer, right click on database node > new > in new
connection profile I have 4 options :
Derby embedded DB
Generic JDBC connection
HSQLDB connection profile
PostgressSQL jdbc connection
Sybase.....

I chose generic JDBC, a new dialg box appear where I should eneter a name
for the connection, I name it TEST, click next Nad reach "specify driver
and connection details, click on the box where there is 3 buttons, a
screen is presented with different drivers, I chose MySQL 5 as this is the
DB I have on my Linux box I get the following error message :
***********************
Unable to locate jar/zip in file system as specified by the driver
definition: mysql-connector-java-5.0.0-bin.jar

is it a config issue or really something missing and update manager didn'
take care of? if so how can I have those jars alone
Re: DB explorer and Date output view [message #42926 is a reply to message #42896] Fri, 07 March 2008 20:10 Go to previous message
Eclipse UserFriend
Originally posted by: Jerry.Cox.sas.nospam.com

Were you able to find the SQL Results view you were looking for in your original
post?

Datatools is "Unable to locate jar/zip in file system" because the jars
containing the jdbc drivers for the various databases are not shipped with
eclipse. These jars are developed by, and are the property of the database
vendors. You have to aquire the jdbc jars from the database vendors.

Once you have the jdbc jar, datatools will still complain about not being able to
locate the jar. You will need to remove mysql-connector-java-5.0.0-bin.jar from
the "Driver Files:" list. Then select the Add button and browse to the location
of the downloaded jar in your file system.


In general, questions about eclipse installation and configuration will probably
be answered faster and more completely in the eclipse.newcomer newsgroup. That
said, there are several ways to find which versions of a project or feature are
running, here are two of the most straightforward:

1. Help->About Eclipse SDK->Feature Details

2. Help->Software Updates->Manage Configuration
Expand the install locations listed in the tree to find the feature you are
interested in.

Hope this helps.



salamlinux@free.fr (eliassal) wrote in
news:e0d6de70c23c3bc01d5c741a545cae44$1@www.eclipse.org:

> My installation is a fresh one, I downloaded the most recent for full
> eclipse on linux from eclipse .org, then I used update manager, I
> added a reference to Callisto and this aqdded other references top
> download sites including the data tools platform.
>
> Question : how can I check which version update manager installed?
>
> Why I am trying to understand is because of this problem I am having
> :in Data source explorer, right click on database node > new > in new
> connection profile I have 4 options :
> Derby embedded DB
> Generic JDBC connection
> HSQLDB connection profile
> PostgressSQL jdbc connection
> Sybase.....
>
> I chose generic JDBC, a new dialg box appear where I should eneter a
> name for the connection, I name it TEST, click next Nad reach "specify
> driver and connection details, click on the box where there is 3
> buttons, a screen is presented with different drivers, I chose MySQL 5
> as this is the DB I have on my Linux box I get the following error
> message : ***********************
> Unable to locate jar/zip in file system as specified by the driver
> definition: mysql-connector-java-5.0.0-bin.jar
>
> is it a config issue or really something missing and update manager
> didn' take care of? if so how can I have those jars alone
>
>
Re: DB explorer and Date output view [message #590421 is a reply to message #42772] Thu, 06 March 2008 18:51 Go to previous message
Jerry Cox is currently offline Jerry CoxFriend
Messages: 8
Registered: July 2009
Junior Member
If DTP and all required dependencies are installed, present in your
configuration (Help->Software Updates->Manage Configuration), and enabled,
then

In Window->ShowViews...->Other...

you should have
Connectivity->Database Explorer
SQL Development->Execution Plan
SQL Development->SQL Results



salamlinux@free.fr (eliassal) wrote in
news:2193c30b8841654e99fd619e445da4e6$1@www.eclipse.org:

> Hi, I have a fresh new eclipse setup on linux, used update manager to
> download and install WTP and DTP.
> I understood that I should have in windows > other views > Data (DB
> explorer and Data output views) which is not the case.
> Am I missing a plugin or it is a configuration issue.
> Thanks in advance
Re: DB explorer and Date output view [message #590430 is a reply to message #42803] Thu, 06 March 2008 20:07 Go to previous message
Eclipse UserFriend
Originally posted by: salamlinux.free.fr

Yes, I think I have setup everything correfctly through update manager.
Still, in other view > connectivity, I have only Data Source Explorer but
not DataBase Explorer nor Data output.
When using update manager, I have a link to Data tools platform, I thgink
this is the project I need, please confirm
Re: DB explorer and Date output view [message #590441 is a reply to message #42834] Thu, 06 March 2008 22:18 Go to previous message
Jerry Cox is currently offline Jerry CoxFriend
Messages: 8
Registered: July 2009
Junior Member
You and I are using different versions of datatools.

At 1.6 the view name is "Database Explorer".
In previous versions, the view name was "Data Source Explorer".

I have never heard of a "Data output" view in datatools (at least in 1.5 or
1.6). I think you are referring to the "SQL Results" view. You can check
this by opening the "Database Development" perspective and verifying the
name on the tab of the view you want.

As I said in my previous mail, if datatools are properly installed,
configured, and enabled, the SQL Results view can be found in
SQL Development->SQL Results. It is not in the Connectivity category.



salamlinux@free.fr (eliassal) wrote in
news:0cc61d8a54221dc9051ddf8600263b1c$1@www.eclipse.org:

> Yes, I think I have setup everything correfctly through update
> manager. Still, in other view > connectivity, I have only Data Source
> Explorer but not DataBase Explorer nor Data output.
> When using update manager, I have a link to Data tools platform, I
> thgink this is the project I need, please confirm
>
>
Re: DB explorer and Date output view [message #590451 is a reply to message #42865] Fri, 07 March 2008 07:52 Go to previous message
Eclipse UserFriend
Originally posted by: salamlinux.free.fr

My installation is a fresh one, I downloaded the most recent for full
eclipse on linux from eclipse .org, then I used update manager, I added a
reference to Callisto and this aqdded other references top download sites
including the data tools platform.

Question : how can I check which version update manager installed?

Why I am trying to understand is because of this problem I am having :in
Data source explorer, right click on database node > new > in new
connection profile I have 4 options :
Derby embedded DB
Generic JDBC connection
HSQLDB connection profile
PostgressSQL jdbc connection
Sybase.....

I chose generic JDBC, a new dialg box appear where I should eneter a name
for the connection, I name it TEST, click next Nad reach "specify driver
and connection details, click on the box where there is 3 buttons, a
screen is presented with different drivers, I chose MySQL 5 as this is the
DB I have on my Linux box I get the following error message :
***********************
Unable to locate jar/zip in file system as specified by the driver
definition: mysql-connector-java-5.0.0-bin.jar

is it a config issue or really something missing and update manager didn'
take care of? if so how can I have those jars alone
Re: DB explorer and Date output view [message #590458 is a reply to message #42896] Fri, 07 March 2008 20:10 Go to previous message
Jerry Cox is currently offline Jerry CoxFriend
Messages: 8
Registered: July 2009
Junior Member
Were you able to find the SQL Results view you were looking for in your original
post?

Datatools is "Unable to locate jar/zip in file system" because the jars
containing the jdbc drivers for the various databases are not shipped with
eclipse. These jars are developed by, and are the property of the database
vendors. You have to aquire the jdbc jars from the database vendors.

Once you have the jdbc jar, datatools will still complain about not being able to
locate the jar. You will need to remove mysql-connector-java-5.0.0-bin.jar from
the "Driver Files:" list. Then select the Add button and browse to the location
of the downloaded jar in your file system.


In general, questions about eclipse installation and configuration will probably
be answered faster and more completely in the eclipse.newcomer newsgroup. That
said, there are several ways to find which versions of a project or feature are
running, here are two of the most straightforward:

1. Help->About Eclipse SDK->Feature Details

2. Help->Software Updates->Manage Configuration
Expand the install locations listed in the tree to find the feature you are
interested in.

Hope this helps.



salamlinux@free.fr (eliassal) wrote in
news:e0d6de70c23c3bc01d5c741a545cae44$1@www.eclipse.org:

> My installation is a fresh one, I downloaded the most recent for full
> eclipse on linux from eclipse .org, then I used update manager, I
> added a reference to Callisto and this aqdded other references top
> download sites including the data tools platform.
>
> Question : how can I check which version update manager installed?
>
> Why I am trying to understand is because of this problem I am having
> :in Data source explorer, right click on database node > new > in new
> connection profile I have 4 options :
> Derby embedded DB
> Generic JDBC connection
> HSQLDB connection profile
> PostgressSQL jdbc connection
> Sybase.....
>
> I chose generic JDBC, a new dialg box appear where I should eneter a
> name for the connection, I name it TEST, click next Nad reach "specify
> driver and connection details, click on the box where there is 3
> buttons, a screen is presented with different drivers, I chose MySQL 5
> as this is the DB I have on my Linux box I get the following error
> message : ***********************
> Unable to locate jar/zip in file system as specified by the driver
> definition: mysql-connector-java-5.0.0-bin.jar
>
> is it a config issue or really something missing and update manager
> didn' take care of? if so how can I have those jars alone
>
>
Previous Topic:DB explorer and Date output view
Next Topic:Database Access with Eclipse Dali and SQL - Tutorial
Goto Forum:
  


Current Time: Thu Nov 26 08:23:27 GMT 2020

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

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

Back to the top