[program-java] Re: Oracle
- From: Anna Giller <anna.giller@xxxxxxxxxxxxxxx>
- To: program-java@xxxxxxxxxxxxx
- Date: Fri, 16 Oct 2009 09:42:12 -0400
Don, thanks!
Please keep me posted.
Anna
-----Original Message-----
From: program-java-bounce@xxxxxxxxxxxxx
[mailto:program-java-bounce@xxxxxxxxxxxxx] On Behalf Of Don Raikes
Sent: Thursday, October 15, 2009 7:07 PM
To: program-java@xxxxxxxxxxxxx
Subject: [program-java] Re: Oracle
Anna,
Ok so here is what I have discovered:
1. jora interesting but not real accessible got stuck trying to explore a
connection. Couldn't figure out how to browse database objects.
2. OEPE: also interesting, but also not real good on db administration
tasks. I haven't figured out how to create/edit/drop objects and/or
grant/revoke privileges.
So I guess I would say back to the drawingboard for now.
> -----Original Message-----
> From: Anna Giller [mailto:anna.giller@xxxxxxxxxxxxxxx]
> Sent: Thursday, October 15, 2009 10:54 AM
> To: program-java@xxxxxxxxxxxxx
> Subject: [program-java] Re: Oracle
>
>
> Don,
>
> If you've never heard about jora, it might be something
> unofficial and has a
> lot of bugs.
> Do you really recommend me to install it, or it's better to
> deal with the
> plug-in you've been testing?
>
> Is it correct, that Eclipse plug-ins do not require any
> installation, just
> the download?
> Which folder to download it into?
>
> Thank you very much,
> Anna
>
>
> -----Original Message-----
> From: program-java-bounce@xxxxxxxxxxxxx
> [mailto:program-java-bounce@xxxxxxxxxxxxx] On Behalf Of Don Raikes
> Sent: Thursday, October 15, 2009 1:35 PM
> To: program-java@xxxxxxxxxxxxx
> Subject: [program-java] Re: Oracle
>
> Anna,
>
> No this sounds like a different plugin, but it sounds promising.
>
> Our oepe download page is at:
> http://www.oracle.com/technology/software/products/oepe/oepe_1
> 1113.html
>
> I cannot access the site for some reason, maybe
> otn.oracle.com is down at
> the moment, but my contact says this is the proper download location.
>
> You want the 1.3 version of the plugin.
>
> The OEPE plugin may provide a lot of functionality you do not
> need, so you
> may want to try the jora plugin as well.
>
> I don't have a clean eclipse installation so I can't test the
> jora plugin
> separately.
>
> > -----Original Message-----
> > From: Anna Giller [mailto:anna.giller@xxxxxxxxxxxxxxx]
> > Sent: Thursday, October 15, 2009 10:21 AM
> > To: program-java@xxxxxxxxxxxxx
> > Subject: [program-java] Re: Oracle
> >
> >
> > Don,
> >
> > I've done some research and found the following link:
> > http://jora.luenasoft.de/index_en.html
> >
> > Would you please let me know if it's the product you've been
> > talking about.
> >
> > Thank you very much,
> > Anna
> >
> > -----Original Message-----
> > From: program-java-bounce@xxxxxxxxxxxxx
> > [mailto:program-java-bounce@xxxxxxxxxxxxx] On Behalf Of Don Raikes
> > Sent: Thursday, October 15, 2009 12:53 PM
> > To: program-java@xxxxxxxxxxxxx
> > Subject: [program-java] Re: Oracle
> >
> > Anna,
> >
> > I will try to find the links. the link I have for downloading
> > is internal
> > only, so I will need to find the external link.
> > I haven't found any good docume ntation about how to use it
> > as yet, but I
> > have pinged one of the guys who has been doing a lot of work
> > with it to see
> > if he can provide some pointers to external docs as well.
> >
> > > -----Original Message-----
> > > From: Anna Giller [mailto:anna.giller@xxxxxxxxxxxxxxx]
> > > Sent: Thursday, October 15, 2009 6:35 AM
> > > To: program-java@xxxxxxxxxxxxx
> > > Subject: [program-java] Re: Oracle
> > >
> > >
> > > Hi Don!
> > >
> > > Is it hard to install this plug-in?
> > > If it's basically accessible, I would like to start using it
> > > right now.
> > > Would you please tell me how to download it, and where to get
> > > a quick start
> > > guide.
> > >
> > > Thank you very much,
> > > Anna
> > >
> > > -----Original Message-----
> > > From: program-java-bounce@xxxxxxxxxxxxx
> > > [mailto:program-java-bounce@xxxxxxxxxxxxx] On Behalf Of Don Raikes
> > > Sent: Wednesday, October 14, 2009 4:49 PM
> > > To: program-java@xxxxxxxxxxxxx
> > > Subject: [program-java] Re: Oracle
> > >
> > > Anna,
> > >
> > > No problem.
> > > I am trying the plugin that oracle has for eclipse, and so
> > > far, it looks
> > > pretty accessible.
> > > I am just trying to find out what kind of functionality it
> > > has in the area
> > > of databsae interaction. I opened a connection to my oracle
> > > 10g database as
> > > system, and have been able to browse through the users and
> > > their tables just
> > > fine.
> > >
> > > I selected data -> edit on one of the tables, and while the
> > > fields read just
> > > fine, I wasn't getting any relationship to the column
> > > headers, so will be
> > > filing a bug on that soon.
> > >
> > > I have to confess I am a total novice when it comes to
> > > eclipse, so don't
> > > know if there are any tricks to making it more accessible as
> > > a framework.
> > >
> > >
> > > > -----Original Message-----
> > > > From: Anna Giller [mailto:anna.giller@xxxxxxxxxxxxxxx]
> > > > Sent: Wednesday, October 14, 2009 1:18 PM
> > > > To: program-java@xxxxxxxxxxxxx
> > > > Subject: [program-java] Re: Oracle
> > > >
> > > >
> > > > Don,
> > > > Thanks for trying!
> > > >
> > > > Anna
> > > >
> > > > -----Original Message-----
> > > > From: program-java-bounce@xxxxxxxxxxxxx
> > > > [mailto:program-java-bounce@xxxxxxxxxxxxx] On Behalf Of
> Don Raikes
> > > > Sent: Wednesday, October 14, 2009 4:14 PM
> > > > To: program-java@xxxxxxxxxxxxx
> > > > Subject: [program-java] Re: Oracle
> > > >
> > > > Anna,
> > > >
> > > > I downloaded teh trial version of FriendlySql, but it keeps
> > > > telling me that
> > > > I need an internet connection to run it. I obviously have
> > > an internet
> > > > connection, so I can't evaluate the software.
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: Anna Giller [mailto:anna.giller@xxxxxxxxxxxxxxx]
> > > > > Sent: Wednesday, October 14, 2009 11:36 AM
> > > > > To: program-java@xxxxxxxxxxxxx
> > > > > Subject: [program-java] Re: Oracle
> > > > >
> > > > >
> > > > > Don,
> > > > >
> > > > > I've just found the tool called Friendly Sql, being
> > > > > advertised as Oracle
> > > > > database browser and editor.
> > > > > It sounds really friendly.
> > > > > It's not free of charge, but I would rather spend money,
> > > than have a
> > > > > constant frustration.
> > > > > Please let me know if you've ever heard about it.
> > > > > Here is the link:
> > > > > http://friendlysql.com/guide.html
> > > > >
> > > > > Thank you very much,
> > > > > Anna
> > > > >
> > > > > -----Original Message-----
> > > > > From: program-java-bounce@xxxxxxxxxxxxx
> > > > > [mailto:program-java-bounce@xxxxxxxxxxxxx] On Behalf Of
> > Don Raikes
> > > > > Sent: Wednesday, October 14, 2009 1:24 PM
> > > > > To: program-java@xxxxxxxxxxxxx
> > > > > Subject: [program-java] Re: Oracle
> > > > >
> > > > > Anna,
> > > > >
> > > > > No problem. I am going to be checking out a newer oracle
> > > > > product which is an
> > > > > extension to eclipse, and if it offers the functionality you
> > > > > need, i will
> > > > > let you know since it sounds like yo are already familiar
> > > > > with eclipse.
> > > > >
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Anna Giller [mailto:anna.giller@xxxxxxxxxxxxxxx]
> > > > > > Sent: Wednesday, October 14, 2009 10:01 AM
> > > > > > To: program-java@xxxxxxxxxxxxx
> > > > > > Subject: [program-java] Re: Oracle
> > > > > >
> > > > > >
> > > > > > Don,
> > > > > >
> > > > > > Thank you very much, and please let me get back to you when
> > > > > > I'm completely
> > > > > > stuck.
> > > > > > Also please keep me posted on any Oracle new
> accessible tools
> > > > > > and any news
> > > > > > regarding accessibility.
> > > > > >
> > > > > > Thanks again,
> > > > > > Anna
> > > > > > -----Original Message-----
> > > > > > From: program-java-bounce@xxxxxxxxxxxxx
> > > > > > [mailto:program-java-bounce@xxxxxxxxxxxxx] On Behalf Of
> > > Don Raikes
> > > > > > Sent: Wednesday, October 14, 2009 12:52 PM
> > > > > > To: program-java@xxxxxxxxxxxxx
> > > > > > Subject: [program-java] Re: Oracle
> > > > > >
> > > > > > Anna,
> > > > > >
> > > > > > No the helpdesk should be able to give you the isql
> address,
> > > > > > then you just
> > > > > > access via your browser and you can do anything, I
> think, you
> > > > > > need in sql to
> > > > > > interact with the database.
> > > > > >
> > > > > > You can also maybe google "oracle isql" and see if
> there is a
> > > > > > link to the
> > > > > > isql manual online. most of our documentation is available
> > > > > > online, but I
> > > > > > don't remember the urls for them.
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: Anna Giller [mailto:anna.giller@xxxxxxxxxxxxxxx]
> > > > > > > Sent: Wednesday, October 14, 2009 9:49 AM
> > > > > > > To: program-java@xxxxxxxxxxxxx
> > > > > > > Subject: [program-java] Re: Oracle
> > > > > > >
> > > > > > >
> > > > > > > Don,
> > > > > > >
> > > > > > > Your information is extremely useful.
> > > > > > > Please let me double check: after the help desc installs
> > > > > > > Oracle database I
> > > > > > > should keep the url for the isql application, and then
> > > > > > > install ISQL myself.
> > > > > > > Is it correct?
> > > > > > > Is there a quick start guide for ISQL?
> > > > > > >
> > > > > > > Thank you very much,
> > > > > > > Anna
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: program-java-bounce@xxxxxxxxxxxxx
> > > > > > > [mailto:program-java-bounce@xxxxxxxxxxxxx] On Behalf Of
> > > > Don Raikes
> > > > > > > Sent: Wednesday, October 14, 2009 12:39 PM
> > > > > > > To: program-java@xxxxxxxxxxxxx
> > > > > > > Subject: [program-java] Re: Oracle
> > > > > > >
> > > > > > > Anna,
> > > > > > >
> > > > > > > Speaking unofficially, depending on the version of the
> > > > > > > database you have
> > > > > > > installed, you may get the isql webclient installed with
> > > > > > it. This is a
> > > > > > > web-based sql client which will generate proper
> html tables
> > > > > > > of the data, I
> > > > > > > believe, although i haven't tried it in several years.
> > > > > > >
> > > > > > > At the end of the database installation, there is
> a window
> > > > > > > that appears that
> > > > > > > lists the ports for all web-based administration tools
> > > > > > > including isql, so
> > > > > > > have whomever is doing the install make sure to
> > note the url
> > > > > > > for the isql
> > > > > > > application.
> > > > > > >
> > > > > > > Also, depending on the version of database being
> installed
> > > > > > > the installer
> > > > > > > will be "fairly" accessible with jaws. I say
> fairly because
> > > > > > > there are, or
> > > > > > > have been some areas where it gets a bit tricky
> to use, but
> > > > > > > with a little
> > > > > > > work it is possible to get it to speak.
> > > > > > >
> > > > > > > *** all views expressed are those of the author
> and have no
> > > > > > bearing on
> > > > > > > Oracle's official position on accessibility. ***
> > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > > From: Anna Giller [mailto:anna.giller@xxxxxxxxxxxxxxx]
> > > > > > > > Sent: Wednesday, October 14, 2009 9:24 AM
> > > > > > > > To: program-java@xxxxxxxxxxxxx
> > > > > > > > Subject: [program-java] Re: Oracle
> > > > > > > >
> > > > > > > >
> > > > > > > > Hi Don!
> > > > > > > >
> > > > > > > > Do you mean that command line tool is the only
> > interactive
> > > > > > > > tool in Oracle?
> > > > > > > > Then how to work productively without being able to
> > > associate
> > > > > > > > the data with
> > > > > > > > their column names?
> > > > > > > > My co-workers use some online tools to
> manipulate Oracle
> > > > > > > > data. Is there any
> > > > > > > > accessible one?
> > > > > > > >
> > > > > > > > Thank you,
> > > > > > > > Anna
> > > > > > > >
> > > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > > From: program-java-bounce@xxxxxxxxxxxxx
> > > > > > > > [mailto:program-java-bounce@xxxxxxxxxxxxx] On Behalf Of
> > > > > Don Raikes
> > > > > > > > Sent: Wednesday, October 14, 2009 12:12 PM
> > > > > > > > To: program-java@xxxxxxxxxxxxx
> > > > > > > > Subject: [program-java] Re: Oracle
> > > > > > > >
> > > > > > > > Anna,
> > > > > > > >
> > > > > > > > The sqlplus that ships with the database is a
> fairly good
> > > > > > > > command-line tool.
> > > > > > > > It speaks fairly well wit hjaws, however, it has the
> > > > > > > > limitations of all
> > > > > > > > command-line tools like need to use the jaws cursor
> > > to review
> > > > > > > > output, and in
> > > > > > > > a listing of data no way to associate data columns
> > > with their
> > > > > > > > headings.
> > > > > > > >
> > > > > > > > However, soon (hopefully within the next couple
> > of months),
> > > > > > > > JDeveloper 11g
> > > > > > > > patchset 1 will be released which will have some real
> > > > > > nice database
> > > > > > > > management tools included along with a complete
> java/web
> > > > > > development
> > > > > > > > environment.
> > > > > > > >
> > > > > > > > I hope to be putting up some tutorials on how to use
> > > > > > > > JDeveloper with JAWS
> > > > > > > > soon.
> > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: Anna Giller [mailto:anna.giller@xxxxxxxxxxxxxxx]
> > > > > > > > > Sent: Wednesday, October 14, 2009 8:39 AM
> > > > > > > > > To: program-java@xxxxxxxxxxxxx
> > > > > > > > > Subject: [program-java] Re: Oracle
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Jim,
> > > > > > > > >
> > > > > > > > > JDBC is OK, it's plain Java, I can use Eclipse for it.
> > > > > > > > > What about Oracle SQL environment? Is it
> > > accessible enough?
> > > > > > > > > Is it difficult to write and execute a simple query
> > > > to create
> > > > > > > > > table and
> > > > > > > > > insert data?
> > > > > > > > >
> > > > > > > > > Thank you,
> > > > > > > > > Anna
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: program-java-bounce@xxxxxxxxxxxxx
> > > > > > > > > [mailto:program-java-bounce@xxxxxxxxxxxxx] On
> Behalf Of
> > > > > > > > Corbett, James
> > > > > > > > > Sent: Wednesday, October 14, 2009 11:21 AM
> > > > > > > > > To: program-java@xxxxxxxxxxxxx
> > > > > > > > > Subject: [program-java] Re: Oracle
> > > > > > > > >
> > > > > > > > > I would take a look at JDBC connections and
> perhaps the
> > > > > > JNDI tree
> > > > > > > > > depending upon your web server....
> > > > > > > > >
> > > > > > > > > J.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: program-java-bounce@xxxxxxxxxxxxx
> > > > > > > > > [mailto:program-java-bounce@xxxxxxxxxxxxx] On
> Behalf Of
> > > > > > > Anna Giller
> > > > > > > > > Sent: October 14, 2009 11:10
> > > > > > > > > To: program-java@xxxxxxxxxxxxx
> > > > > > > > > Subject: [program-java] Oracle
> > > > > > > > >
> > > > > > > > > Hi Everyone!
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > I need to learn Java with Oracle database.
> > > > > > > > >
> > > > > > > > > I'm getting Oracle installed on my machine tomorrow.
> > > > > > > > >
> > > > > > > > > Would you please give me an idea what to start with.
> > > > > > > > >
> > > > > > > > > Do you know a brief accessible tutorial on Oracle SQL?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Thank you very much,
> > > > > > > > >
> > > > > > > > > Anna
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>
>
Other related posts:
