Skip to Main Content


Question and Answer

Tom Kyte

Thanks for the question, kit.

Asked: September 03, 2002 - 4:38 pm UTC

Last updated: October 26, 2005 - 7:20 am UTC

Version: 8.1.7

Viewed 1000+ times

You Asked

Hi, tom
been to your site many times and seen you often recommned other books.
being a predominant oracle person, it appears its vital to pick up some java knowledge.

however, there is always a time constraint and most of my time goes in learning new oracle ideas. I have been doing oracle for 15 years and even now i call my self an expert. So I would like to learn java but in terms of getting by with oralce.

I noticed 1 book you recommended recently, 9i pl/java programming book but it seems to cover lots of the java in the db which i gather is being replaced by it being in the application server

do you know of such easy understanding books.

there are so many oracle java books,it be nice your thoughts on them


and Tom said...

No, it doesn't really cover the J2EE java in the database (and thats what is being de-emphasized)

If you check out the table of contents:

</code> <code>

I think you'll find it is a gentle introduction into Java from a PLSQL/Oracle developers perspective. Showing bits and pieces where Java is truly useful in and out of the database (using java to EXTEND the database).

It concentrates on Java + DATABASE stuff (hey, I helped do the technical editing, wouldn't have it any other way).

I've read other java books (and I was a C and C++ programmer before this...) and they just all make my head spin. I think you'll find this one to be a "gentle" introduction. It is ideally suited, perhaps even uniquely suited, to meet your goal of "So I would like to learn java but in terms of getting by with oralce."

But -- as anyone is free to do -- I rekon there'll be some other suggestions popping up under this answer anytime now...


  (8 ratings)

Is this answer out of date? If it is, please let us know via a Comment


Thanks for the question regarding "oracle developer moving to java", version 8.1.7

kit, September 04, 2002 - 4:51 am UTC



kit, February 10, 2004 - 6:08 am UTC

I followed your recommendation and have gone though your previous recommendation. I'd like to step it up a bit now and need a new book that covers the title subjects.

Asa fellow Oracle person. Do you feel I'm going down the wrong path in should I just stick to learn oracle inside outI mean there is enough to learn there.

As a developer should I update my DBA skills.

Please do recommend the DBA/JAVA/JSP/STRUTS/TOMCAT/Servlets Books that you have found easy to understand

Will you be doing a 9i/10g book soon ?

Tom Kyte
February 10, 2004 - 6:44 am UTC

I read a java book once (way back when). that is when I discovered -- hey, this miracle thing that will save the world is "gasp" -- just a programming language. Sooo, not being the guy who does the gui -- and java not being the perfect language for writing code inside the server -- I haven't really followed the java/jsp/struts/tomcat/servlet thingy (all gui to me) too much. Haven't read any.

I learned all of my database stuff from the documentation and experimentation -- never really read too far outside the supplied stuff. (well, not for a long time anyway).

I did a 9i book -- released in August 2003. See the home page.

Effective oracle by design

kit, February 10, 2004 - 6:51 am UTC

thanks for your input. if any of your readers have any recommendations then pleas add on.

I have bought the oracle by design book and I know it covers some 9i features but wondering if a new book will come out that details all the features

Or do you think whats in the book is enough for 9i

Tom Kyte
February 10, 2004 - 7:07 am UTC

well, if you just want a list of new features -- there is always the new features guide. then, there is exploration (experimentation) to really understand and learn the new feature.

Java-Oracle advices

Alex, February 10, 2004 - 11:42 am UTC


I would recommend the following:

JDeveloper - tutorials, wizards, code samples from OTN,
It includes Struts helpers, JSP editor and convinient
database tools. Of course, wizards will somewhat shields
you from inside understanding, but you can always
dig/rewrite generated code...

Here, you will find Tomcat and Struts (originals)

9iAS (oops, sorry, 10gAS  :-)  ) for J2EE or standalone 
Tomcat - simple JSP server. In both there is a lot
of JSP and some J2EE examples.

Thinking in Java - Just great openning to OO-Java world. <code>
There are 100s other java books, Tom's
suggestopn looks good according to table of contents

Hibernate and TopLink (Oracle's) - 2 great O/R mappers.
Since EJB is going down in popularity
(complex/not flexible) O/R mappers are important.

You may need JDBC stuff - see Oracle docs and samples
and a lot of on-line tutorials. (ask me if you
need help to find)

Alex V.

P.S. Tom, thanks for Montreal presentation
this morning :-))

Java book suggestions

Ryan Gaffuri, February 10, 2004 - 12:01 pm UTC

I'd recommend staying away from jdeveloper or any IDE at first. Just learn Java. Start with the basics. Go to That is wordpad that gives you a nice java editor. You need to install the java SDK from the then install this(or you might have a problem). It will give you formatting, colors, and a list you can use to switch classes.

The java book that alot of people like is actually free. "Thinking in Java". His design pattern book is very good.

When you go to and check out the javadocs you will be in for a rude awakening. They are very terse compared to Oracle's robust documentation. No one book will teach you everything you need to know, but this is a good start.

There is also a java tutorial(that is terse) on

A reader, February 11, 2004 - 8:09 am UTC

Hi Tom,

"No, it doesn't really cover the J2EE java in the database (and thats what is being de-emphasized)"

Not sure what you mean? Is Java in the database (Java Stored Procedures etc.) being de-emphasized? I have the book you provided the link to, but it has quite a few examples of doing stuff using Java Stored Procedures, such as FTP, email, compressing files etc. Am I missing something here?

Tom Kyte
February 11, 2004 - 9:21 am UTC

no, j2ee in the database is being de-emphasized. j2ee apps belong in the middle tier, not the database.

j2ee is a huge huge architecture.

java, that is just a language - like plsql, c, vb, etc.

oracle developer moving to java

kit, February 12, 2004 - 6:46 am UTC

HI thanks for all your input

I'll have look at the tomcat site

I' have a firm understanding of the JAVA but now i need exmaples of integrating with JSP and that using JDBC calling stored procs

Tomcat in Oracle applications server?

Sean, October 25, 2005 - 9:27 am UTC

I'm in a new site. The client's window server has the Tomcat running, and they ask :
"Do you know which TomCat is allocate for
which on the machine?"

Tom --
Does oracle iAS use TomCat??

Thanks in advance.


Tom Kyte
October 26, 2005 - 7:20 am UTC

i use Apache and mod_plsql.