Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Unable to get DTP 1.5 + Eclipse 3.3 to work
Unable to get DTP 1.5 + Eclipse 3.3 to work [message #31776] Thu, 05 July 2007 02:07 Go to next message
Eclipse UserFriend
Originally posted by: jack.ukleja.no.spam.macquarie.com

Hi there,

I have the *strong* desire to find a SQL management tool where I can
develop and manage a variety of DBMS all from one tool. We have Sybase,
Oracle and SQL Server here at work.

I discovered DTP yesterday and had high hopes for it. Interface and
features look good.

Unfortunately I cannot report much success!

I followed the instructions exactly as described on
http://www.eclipse.org/datatools/. I tried the Eclipse 3.3 path first:
* Eclipse 3.3 SDK
* EMF 2.3 (EMF + SDO)
* GEF 3.3
* DTP 1.5

After placing all the plugins/features in the correct folders, I ran
Eclipse. I could see all the plugins, although some were not enabled. So I
enabled them all and restarted.

Even then I could not see 'Database development' appear in the Perspective
list! I could create a connection to a Sybase 12.5 server but it would
refuse to display any schema info in the data explorer. I also could not
work out how to run any SQL code - no such view shows in the list of
available views.

I tried installing it all over again from scratch but this time using the
Software Updates -> Find and Install screen. I could see DTP 1.5 so
selected all the relevant components and got Eclipse to select the
dependancies automatically. Everything downloaded and Eclipse restarted.
BUT exactly the same problem ... 'Database Developement' does not show in
the Perspectives!

I am assuming this is a bug (quite a bad one considering standard install
does not work!). Only thing I can think is I am running Windows 2000 so
maybe it wasnt tested with Win2k. If this is not a bug then there is
definately some complication that needs to be exaplined in detail to
newbies like myself on how to get DTP up and running. Maybe DTP does not
provide and tools you can use out the box - only a framework?

Anyway I gave up with the e3.3 packages and tried e3.2. I have had more
success with 3.2 unfortunately it does not support Sybase 12.x. So again I
was unable to view my Sybase databases properly.

On top of all that I still cannot work out how to actually run a query.

So to sum up, all these tools look great and have a potentially great
future but there are two stumbling blocks I can see:
1) e3.3 does not seem to work with DTP 1.5 out of the box on Win2k! :(
2) It's way to hard for a newbie to figure out where to begin with this
stuff (no tutorials I have found). Oracle have one but only for e3.3 not
3.2. It's all a bit confusing really. Sybase seem to offer no clear
solution out-of-the-box to managing/developing Sybase ASA out of the box
with DTP.

Maybe I just need to spend more time playing with this stuff.

Regards,
Jack
Re: Unable to get DTP 1.5 + Eclipse 3.3 to work [message #31811 is a reply to message #31776] Thu, 05 July 2007 11:41 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: merks.ca.ibm.com

Jack,

Is it possible that you're using a 1.4 JVM? In this case, EMF 2.3
definitely won't activate because it requires a 5.0 JVM. If you run
eclipse.exe with -debug -clean, I think it will give you more detailed
information about why plugins are not activating...


Jack U wrote:
> Hi there,
>
> I have the *strong* desire to find a SQL management tool where I can
> develop and manage a variety of DBMS all from one tool. We have
> Sybase, Oracle and SQL Server here at work.
>
> I discovered DTP yesterday and had high hopes for it. Interface and
> features look good.
>
> Unfortunately I cannot report much success!
>
> I followed the instructions exactly as described on
> http://www.eclipse.org/datatools/. I tried the Eclipse 3.3 path first:
> * Eclipse 3.3 SDK
> * EMF 2.3 (EMF + SDO)
> * GEF 3.3
> * DTP 1.5
>
> After placing all the plugins/features in the correct folders, I ran
> Eclipse. I could see all the plugins, although some were not enabled.
> So I enabled them all and restarted.
>
> Even then I could not see 'Database development' appear in the
> Perspective list! I could create a connection to a Sybase 12.5 server
> but it would refuse to display any schema info in the data explorer. I
> also could not work out how to run any SQL code - no such view shows
> in the list of available views.
>
> I tried installing it all over again from scratch but this time using
> the Software Updates -> Find and Install screen. I could see DTP 1.5
> so selected all the relevant components and got Eclipse to select the
> dependancies automatically. Everything downloaded and Eclipse
> restarted. BUT exactly the same problem ... 'Database Developement'
> does not show in the Perspectives!
> I am assuming this is a bug (quite a bad one considering standard
> install does not work!). Only thing I can think is I am running
> Windows 2000 so maybe it wasnt tested with Win2k. If this is not a bug
> then there is definately some complication that needs to be exaplined
> in detail to newbies like myself on how to get DTP up and running.
> Maybe DTP does not provide and tools you can use out the box - only a
> framework?
>
> Anyway I gave up with the e3.3 packages and tried e3.2. I have had
> more success with 3.2 unfortunately it does not support Sybase 12.x.
> So again I was unable to view my Sybase databases properly.
>
> On top of all that I still cannot work out how to actually run a query.
>
> So to sum up, all these tools look great and have a potentially great
> future but there are two stumbling blocks I can see:
> 1) e3.3 does not seem to work with DTP 1.5 out of the box on Win2k! :(
> 2) It's way to hard for a newbie to figure out where to begin with
> this stuff (no tutorials I have found). Oracle have one but only for
> e3.3 not 3.2. It's all a bit confusing really. Sybase seem to offer no
> clear solution out-of-the-box to managing/developing Sybase ASA out of
> the box with DTP.
>
> Maybe I just need to spend more time playing with this stuff.
>
> Regards,
> Jack
>
Re: Unable to get DTP 1.5 + Eclipse 3.3 to work [message #31846 is a reply to message #31776] Mon, 09 July 2007 01:34 Go to previous messageGo to next message
Anil Samuel is currently offline Anil SamuelFriend
Messages: 108
Registered: July 2009
Senior Member
Jack

You may want to give
http://www.oracle.com/technology/tech/eclipse/dtp/files/gett ingstarted.html
a go. Use the instructions upto 2.2 to install DTP and dependencies.

Anthos
Jack U wrote:
> Hi there,
>
> I have the *strong* desire to find a SQL management tool where I can
> develop and manage a variety of DBMS all from one tool. We have Sybase,
> Oracle and SQL Server here at work.
>
> I discovered DTP yesterday and had high hopes for it. Interface and
> features look good.
>
> Unfortunately I cannot report much success!
>
> I followed the instructions exactly as described on
> http://www.eclipse.org/datatools/. I tried the Eclipse 3.3 path first:
> * Eclipse 3.3 SDK
> * EMF 2.3 (EMF + SDO)
> * GEF 3.3
> * DTP 1.5
>
> After placing all the plugins/features in the correct folders, I ran
> Eclipse. I could see all the plugins, although some were not enabled. So
> I enabled them all and restarted.
>
> Even then I could not see 'Database development' appear in the
> Perspective list! I could create a connection to a Sybase 12.5 server
> but it would refuse to display any schema info in the data explorer. I
> also could not work out how to run any SQL code - no such view shows in
> the list of available views.
>
> I tried installing it all over again from scratch but this time using
> the Software Updates -> Find and Install screen. I could see DTP 1.5 so
> selected all the relevant components and got Eclipse to select the
> dependancies automatically. Everything downloaded and Eclipse restarted.
> BUT exactly the same problem ... 'Database Developement' does not show
> in the Perspectives!
> I am assuming this is a bug (quite a bad one considering standard
> install does not work!). Only thing I can think is I am running Windows
> 2000 so maybe it wasnt tested with Win2k. If this is not a bug then
> there is definately some complication that needs to be exaplined in
> detail to newbies like myself on how to get DTP up and running. Maybe
> DTP does not provide and tools you can use out the box - only a framework?
>
> Anyway I gave up with the e3.3 packages and tried e3.2. I have had more
> success with 3.2 unfortunately it does not support Sybase 12.x. So again
> I was unable to view my Sybase databases properly.
>
> On top of all that I still cannot work out how to actually run a query.
>
> So to sum up, all these tools look great and have a potentially great
> future but there are two stumbling blocks I can see:
> 1) e3.3 does not seem to work with DTP 1.5 out of the box on Win2k! :(
> 2) It's way to hard for a newbie to figure out where to begin with this
> stuff (no tutorials I have found). Oracle have one but only for e3.3 not
> 3.2. It's all a bit confusing really. Sybase seem to offer no clear
> solution out-of-the-box to managing/developing Sybase ASA out of the box
> with DTP.
>
> Maybe I just need to spend more time playing with this stuff.
>
> Regards,
> Jack
>
Re: Unable to get DTP 1.5 + Eclipse 3.3 to work [message #31881 is a reply to message #31811] Mon, 09 July 2007 02:13 Go to previous message
Eclipse UserFriend
Originally posted by: jack.ukleja.macquarie.com

Ed Merks wrote:

> Jack,

> Is it possible that you're using a 1.4 JVM? In this case, EMF 2.3
> definitely won't activate because it requires a 5.0 JVM. If you run
> eclipse.exe with -debug -clean, I think it will give you more detailed
> information about why plugins are not activating...

Hi Ed,

Thanks a lot for your response - you were right! I was running on Java
1.4. Have upgraded now to Version 6 Update 1 and with Ecplise 3.3 I can
now see the Database Developement/Debugging views. Good stuff!

I have so far had success with using the Oracle driver 'classes12.rar' to
connect to my Oracle 9.2.0.5 database. I can see the procs/tables etc.

I have only had partial success in connecting to my Sybase 12.5.2.11941
instance. I can see everything apart from the stored procedures - does
anyone have any ideas about how to fix this? The driver I am using is
'Jconnect' - jconn2.jar.

Other than that, I am still getting used to the interface. I'm finding it
a bit odd at the moment that there is no immediate way to create/excute
ad-hoc sql queries without creating a Sql file and adding it to the
project. Would be more natural just be to able create a sql window, and
then later save it/add to project etc.

Regards,
Jack
Re: Unable to get DTP 1.5 + Eclipse 3.3 to work [message #586081 is a reply to message #31776] Thu, 05 July 2007 11:41 Go to previous message
Ed Merks is currently offline Ed MerksFriend
Messages: 26287
Registered: July 2009
Senior Member
Jack,

Is it possible that you're using a 1.4 JVM? In this case, EMF 2.3
definitely won't activate because it requires a 5.0 JVM. If you run
eclipse.exe with -debug -clean, I think it will give you more detailed
information about why plugins are not activating...


Jack U wrote:
> Hi there,
>
> I have the *strong* desire to find a SQL management tool where I can
> develop and manage a variety of DBMS all from one tool. We have
> Sybase, Oracle and SQL Server here at work.
>
> I discovered DTP yesterday and had high hopes for it. Interface and
> features look good.
>
> Unfortunately I cannot report much success!
>
> I followed the instructions exactly as described on
> http://www.eclipse.org/datatools/ I tried the Eclipse 3.3 path first:
> * Eclipse 3.3 SDK
> * EMF 2.3 (EMF + SDO)
> * GEF 3.3
> * DTP 1.5
>
> After placing all the plugins/features in the correct folders, I ran
> Eclipse. I could see all the plugins, although some were not enabled.
> So I enabled them all and restarted.
>
> Even then I could not see 'Database development' appear in the
> Perspective list! I could create a connection to a Sybase 12.5 server
> but it would refuse to display any schema info in the data explorer. I
> also could not work out how to run any SQL code - no such view shows
> in the list of available views.
>
> I tried installing it all over again from scratch but this time using
> the Software Updates -> Find and Install screen. I could see DTP 1.5
> so selected all the relevant components and got Eclipse to select the
> dependancies automatically. Everything downloaded and Eclipse
> restarted. BUT exactly the same problem ... 'Database Developement'
> does not show in the Perspectives!
> I am assuming this is a bug (quite a bad one considering standard
> install does not work!). Only thing I can think is I am running
> Windows 2000 so maybe it wasnt tested with Win2k. If this is not a bug
> then there is definately some complication that needs to be exaplined
> in detail to newbies like myself on how to get DTP up and running.
> Maybe DTP does not provide and tools you can use out the box - only a
> framework?
>
> Anyway I gave up with the e3.3 packages and tried e3.2. I have had
> more success with 3.2 unfortunately it does not support Sybase 12.x.
> So again I was unable to view my Sybase databases properly.
>
> On top of all that I still cannot work out how to actually run a query.
>
> So to sum up, all these tools look great and have a potentially great
> future but there are two stumbling blocks I can see:
> 1) e3.3 does not seem to work with DTP 1.5 out of the box on Win2k! :(
> 2) It's way to hard for a newbie to figure out where to begin with
> this stuff (no tutorials I have found). Oracle have one but only for
> e3.3 not 3.2. It's all a bit confusing really. Sybase seem to offer no
> clear solution out-of-the-box to managing/developing Sybase ASA out of
> the box with DTP.
>
> Maybe I just need to spend more time playing with this stuff.
>
> Regards,
> Jack
>
Re: Unable to get DTP 1.5 + Eclipse 3.3 to work [message #586095 is a reply to message #31776] Mon, 09 July 2007 01:34 Go to previous message
Anil Samuel is currently offline Anil SamuelFriend
Messages: 108
Registered: July 2009
Senior Member
Jack

You may want to give
http://www.oracle.com/technology/tech/eclipse/dtp/files/gett ingstarted.html
a go. Use the instructions upto 2.2 to install DTP and dependencies.

Anthos
Jack U wrote:
> Hi there,
>
> I have the *strong* desire to find a SQL management tool where I can
> develop and manage a variety of DBMS all from one tool. We have Sybase,
> Oracle and SQL Server here at work.
>
> I discovered DTP yesterday and had high hopes for it. Interface and
> features look good.
>
> Unfortunately I cannot report much success!
>
> I followed the instructions exactly as described on
> http://www.eclipse.org/datatools/ I tried the Eclipse 3.3 path first:
> * Eclipse 3.3 SDK
> * EMF 2.3 (EMF + SDO)
> * GEF 3.3
> * DTP 1.5
>
> After placing all the plugins/features in the correct folders, I ran
> Eclipse. I could see all the plugins, although some were not enabled. So
> I enabled them all and restarted.
>
> Even then I could not see 'Database development' appear in the
> Perspective list! I could create a connection to a Sybase 12.5 server
> but it would refuse to display any schema info in the data explorer. I
> also could not work out how to run any SQL code - no such view shows in
> the list of available views.
>
> I tried installing it all over again from scratch but this time using
> the Software Updates -> Find and Install screen. I could see DTP 1.5 so
> selected all the relevant components and got Eclipse to select the
> dependancies automatically. Everything downloaded and Eclipse restarted.
> BUT exactly the same problem ... 'Database Developement' does not show
> in the Perspectives!
> I am assuming this is a bug (quite a bad one considering standard
> install does not work!). Only thing I can think is I am running Windows
> 2000 so maybe it wasnt tested with Win2k. If this is not a bug then
> there is definately some complication that needs to be exaplined in
> detail to newbies like myself on how to get DTP up and running. Maybe
> DTP does not provide and tools you can use out the box - only a framework?
>
> Anyway I gave up with the e3.3 packages and tried e3.2. I have had more
> success with 3.2 unfortunately it does not support Sybase 12.x. So again
> I was unable to view my Sybase databases properly.
>
> On top of all that I still cannot work out how to actually run a query.
>
> So to sum up, all these tools look great and have a potentially great
> future but there are two stumbling blocks I can see:
> 1) e3.3 does not seem to work with DTP 1.5 out of the box on Win2k! :(
> 2) It's way to hard for a newbie to figure out where to begin with this
> stuff (no tutorials I have found). Oracle have one but only for e3.3 not
> 3.2. It's all a bit confusing really. Sybase seem to offer no clear
> solution out-of-the-box to managing/developing Sybase ASA out of the box
> with DTP.
>
> Maybe I just need to spend more time playing with this stuff.
>
> Regards,
> Jack
>
Re: Unable to get DTP 1.5 + Eclipse 3.3 to work [message #586104 is a reply to message #31811] Mon, 09 July 2007 02:13 Go to previous message
Eclipse UserFriend
Originally posted by: jack.ukleja.macquarie.com

Ed Merks wrote:

> Jack,

> Is it possible that you're using a 1.4 JVM? In this case, EMF 2.3
> definitely won't activate because it requires a 5.0 JVM. If you run
> eclipse.exe with -debug -clean, I think it will give you more detailed
> information about why plugins are not activating...

Hi Ed,

Thanks a lot for your response - you were right! I was running on Java
1.4. Have upgraded now to Version 6 Update 1 and with Ecplise 3.3 I can
now see the Database Developement/Debugging views. Good stuff!

I have so far had success with using the Oracle driver 'classes12.rar' to
connect to my Oracle 9.2.0.5 database. I can see the procs/tables etc.

I have only had partial success in connecting to my Sybase 12.5.2.11941
instance. I can see everything apart from the stored procedures - does
anyone have any ideas about how to fix this? The driver I am using is
'Jconnect' - jconn2.jar.

Other than that, I am still getting used to the interface. I'm finding it
a bit odd at the moment that there is no immediate way to create/excute
ad-hoc sql queries without creating a Sql file and adding it to the
project. Would be more natural just be to able create a sql window, and
then later save it/add to project etc.

Regards,
Jack
Previous Topic:Unable to get DTP 1.5 + Eclipse 3.3 to work
Next Topic:Connect to Schema
Goto Forum:
  


Current Time: Sun Dec 21 21:40:24 GMT 2014

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

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