Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Is DTP suitable for Oracle pl/sql development?
Is DTP suitable for Oracle pl/sql development? [message #580997] Fri, 14 July 2006 19:30
Eclipse UserFriend
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.
Previous Topic:postgres driver definitions?
Next Topic:Using ODA from own application
Goto Forum:
  


Current Time: Wed Sep 18 22:38:23 GMT 2024

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

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

Back to the top