| Is DTP suitable for Oracle pl/sql development? [message #19476] |
Fri, 14 July 2006 19:30  |
Eclipse User |
|
|
|
Originally posted by: fburleigh.gmail.com
I've known of thee Eclipse project for quite a while but only now have I
let my curiosity--and need for a database development tool--lead me to
download the software on windows.
I got Eclipse 3.2 and the DTP that goes with it (from Help, Update).
After quite a struggle I discovered the concept of Perspective, then
defined an Oracle connection using an "oracle thin driver" (using the
class file for jre 1.4/5.0). I'm logged in to the 10gR2 database and
can see (some of) the schema. I see none of my Oracle packages or
procedures. It could be this tool isn't quite ready for this task for
Oracle yet?
I've not had much luck beyond that.
I made a "project," then a new sql file but can't see how to run any
sql. I'd expect to right click my open connection in the DSE then get
an sql editor open to that connection.
So I make a new SQL "Scrap book" and type some sql that I'd like to run
in the open connection I see in the DSE. I'm shown a kind of connection
editor that only offers me the ability to make a new connection, rather
than using the one I've already defined, shown in the DSE. The drop
down list "JDBC driver" only shows "other" (I have Oracle 10 selected in
the tree to the left). I can select a driver file but don't know what
to type in the JDBC driver class box or the connect URL box (I suspect I
could copy from the open connection in the DSE but that wouldn't help
with the class name box).
I can see a lot of work has gone in to this, and from the web pages it
seems that I should be able to debug my pl/sql. But maybe that's more
of a plan than a completed project?
Pointers much appreciated.
|
|
|
| Re: Is DTP suitable for Oracle pl/sql development? [message #19566 is a reply to message #19476] |
Tue, 18 July 2006 14:52  |
| Eclipse User |
|
|
|
Originally posted by: john.graham.sybase.com
Hi Frank,
> I got Eclipse 3.2 and the DTP that goes with it (from Help, Update).
> After quite a struggle I discovered the concept of Perspective, then
> defined an Oracle connection using an "oracle thin driver" (using the
> class file for jre 1.4/5.0). I'm logged in to the 10gR2 database and
> can see (some of) the schema. I see none of my Oracle packages or
> procedures. It could be this tool isn't quite ready for this task for
> Oracle yet?
DTP has recently established an "Enablement" project in an effort to
encourage community involvement for cases like the above. Initially, DTP
0.7/0.9 used Apache Derby as our sample database, so coverage of others
was limited at best. I have blogged about the history of this topic and
our current approach:
http://dataplat.blogspot.com/2006/05/device-driver-problem.h tml
We're very optimistic about the prospects for the Enablement project, so
look for some really cool stuff in the coming months! Of course, we'd also
welcome your participation in it as well!
> I made a "project," then a new sql file but can't see how to run any
> sql. I'd expect to right click my open connection in the DSE then get
> an sql editor open to that connection.
That's an excellent enhancement request. As it so happens, we're in the
early planning stages for our next DTP release (target: December 2006), so
this is a particularly good time to note these sorts of things. Please
enter the requests into Bugzilla under Data Tools/Data Source Explorer, so
we can track it.
> So I make a new SQL "Scrap book" and type some sql that I'd like to run
> in the open connection I see in the DSE. I'm shown a kind of connection
> editor that only offers me the ability to make a new connection....
Do you also happen to have WTP installed? Right now there's an overlap in
data tooling between WTP and DTP, which we plan to resolve going forward.
The DTP SQL editor is found under the "New" wizard: category "SQL
Development-->SQL File."
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
|
|
|
|
| Re: Is DTP suitable for Oracle pl/sql development? [message #581057 is a reply to message #19476] |
Tue, 18 July 2006 14:52 |
 John Graham
Messages: 183
Registered: July 2009 |
Senior Member |
|
|
Hi Frank,
> I got Eclipse 3.2 and the DTP that goes with it (from Help, Update).
> After quite a struggle I discovered the concept of Perspective, then
> defined an Oracle connection using an "oracle thin driver" (using the
> class file for jre 1.4/5.0). I'm logged in to the 10gR2 database and
> can see (some of) the schema. I see none of my Oracle packages or
> procedures. It could be this tool isn't quite ready for this task for
> Oracle yet?
DTP has recently established an "Enablement" project in an effort to
encourage community involvement for cases like the above. Initially, DTP
0.7/0.9 used Apache Derby as our sample database, so coverage of others
was limited at best. I have blogged about the history of this topic and
our current approach:
http://dataplat.blogspot.com/2006/05/device-driver-problem.h tml
We're very optimistic about the prospects for the Enablement project, so
look for some really cool stuff in the coming months! Of course, we'd also
welcome your participation in it as well!
> I made a "project," then a new sql file but can't see how to run any
> sql. I'd expect to right click my open connection in the DSE then get
> an sql editor open to that connection.
That's an excellent enhancement request. As it so happens, we're in the
early planning stages for our next DTP release (target: December 2006), so
this is a particularly good time to note these sorts of things. Please
enter the requests into Bugzilla under Data Tools/Data Source Explorer, so
we can track it.
> So I make a new SQL "Scrap book" and type some sql that I'd like to run
> in the open connection I see in the DSE. I'm shown a kind of connection
> editor that only offers me the ability to make a new connection....
Do you also happen to have WTP installed? Right now there's an overlap in
data tooling between WTP and DTP, which we plan to resolve going forward.
The DTP SQL editor is found under the "New" wizard: category "SQL
Development-->SQL File."
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
|
|
|
|
Powered by
FUDForum. Page generated in 0.03632 seconds
] 
Search
Help
Register
Login
Home
