Oracle Database Programming using Java and Web Services
This book is about Oracle database programming using Java and Web services. Foreword by Tom Kyte (html) (pdf)
This book is for database developers (DBA, PL/SQL developers, data architects), Java/JDBC/SQLJ developers, and Web services /SOA assemblers.
Through its 1085 pages, it furnishes a complete coverage of the following topics:
This book is for database developers (DBA, PL/SQL developers, data architects), Java/JDBC/SQLJ developers, and Web services /SOA assemblers.
Through its 1085 pages, it furnishes a complete coverage of the following topics:
- Java in the database: stored procedures as database programming model (rationale, obstacles to their adoption, languages for stores procedures, PL/SQL or Java?). Under the hood of the Java runtime in the database (design goals, architecture, memory management, security, threading, Java execution in the database, native compilation, etc). Examples of typical and atypical applications (SAP callout, JDBC callout, EJB callout, HTTP Callout), Excel-like expressions parser) using Java in the database. Mapping SQL and PL/SQL types to/from Java. Declaring Java stored procedures (Call Specs). Experimental examples of running JACL, JYTHON, SCHEME and GROOVY in the database using the Java runtime.
- Oracle JDBC 10g: In depth coverage of the JDBC API specifications and Oracle implementation. Connection and connection services (Implicit Connection Caching). High-Availability in RAC environments (ONS, Fast Connection Failover, TAF) and scalability (Runtime Connection Load balancing in RAC environments). Statements and Oracle extensions (statement caching, DML batching). Manipulating Oracle data types with JDBC. Practical coverage of Result Sets and the various RowSet models (JSR-114) . Proxy Authentication, SSL encryption, end-to-end tracing, Logging, local/global Transactions, Security and best practices.
- Oracle SQLJ 10g: Concise coverage of the SQLJ Language/API and Oracle implementation. Manipulating SQL and PL/SQL data types with SQLJ and contrasting with JDBC (interoperability, differences). Comprehensive coverage of Oracle datatypes mapping, and best practices.
- JPublisher in Action: a practical coverage of a versatile tool that complements JDBC (and SQLJ) for accessing the Oracle database from Java. Automatic wrapping of PL/SQL packages as well as mapping complex/user-defined types to Java.
- Database Web services: Introduction to Web services and SOA for DBAs. How to turn your Oracle database into a Web service consumer (call-out external Web services from within the database using SQL, PL/SQL, Java). How to turn your database into a Web services provider (exposing PL/SQL package into Web service as wellas SQL Query, AQ quques and operations, SQL Queries and DML, and Java in the database --using few mouse clik or a command line utility. How to add SOA services to database web services.
Here is the first chapter, the Table Of Content, the code samples at OTN and at the publisher's web site, and a reader's review.
Enjoy and pass on the buzz.
posted by Kuassi Mensah at 5:34 PM
45 Comments:
FYI
Tried to add your RSS feed to my yahoo using the add button to the right of your main page and got the error "could not find RSS file - please tell webmaster" ( paraphrase)
Very interested to read your book - it's on order.
Regards.
Hi Kuassi,
Just to let you that the add on Amazon shows Tom Kyte as the Author...........
Regards,
Hugo.
Hi Matthew,
Sorry about the RSS feed; I'll double-check the settings as i doubt that the webmaster (i.e., the Google blog folks) will spend time on this.
When/If our paths cross, I'll be gld to sign your copy of the book.
Kuassi
Hi Hugo,
Tom indeed foreworded it, the ad was referring to his book in the combo/bundle (my book + his book).
Kuassi
Oops, Hugo was right.
On Amazon.fr, and Amazon.ca (the ones i have checked so far), Tom Kyte has been listed as the author of the book.
I have just sent an email to the publisher to fix that.
Kuassi
This book looks excellent...I'm looking forward to reading it!
Best to you
Josh,
I am convinced you will find useful tips for your project http://sourceforge.net/projects/gather.
Enjoy, Kuassi
Hi,
I bought this book and reading it. Where can i download the scripts in the book.
Hi Sreekanth,
The book has just been released (this is not an excuse) and there's been some delay in the logistics (such as posting the table of contents, index, etc on Amazon.com and the link to the code samples). I've been pressuring the publisher to host the samples on his web site and get me the URL. It'll hopefuly happen today. Then I'll link it from my blog as soon as i've got it.
Sorry about that, Kuassi
It is available as an ebook? I don't buy non electronic anymore.
Hi,
My publisher just told me that this book will be available as ebbok through Amazon.com, however, it'll take a couple of months.
Thanks for your patience, Kuassi.
do you have the link to the code samples.
Hi,
Sorry the publisher has still not yet posted the code samples.
As a backup measure, I'll upload these on the Oracle Technology Network and post the link to this blog tonight or first thing tomorrow morning.
Kuassi
Here is the link to the code samples http://download.oracle.com/technology/tech/java/jsp/pdf/Code_depot.zip
the link above is taking me to
http://www.oracle.com/technology/software/index.html
thanks
The bits are temporarly hosted on the OTN network; the URL works for me. Maybe the redirect to the regional server was not working by the time you tried.
Can you re-try by replacing download.oracle.com with download-west.oracle.com or download-east.oracle.com?
Winsor Pilates
Get 50% off on Winsor Pilates.
Some people get acne outbreaks from an excess of stress. The vitamin B complex acts as a stress reliever. Because of the many types of B vitamin, an individual seeking a vitamin regiment to help fight off acne should consult a dermatologist before starting. A dermatologist can be very helpful in helping acne sufferers find the right solution to help. A healthy diet with a combination of topical solutions such as Proactiv solution or Neutrogena is often one of the most effective ways to minimize acne outbreaks.
I have been reading your book and I am very interested in utilizing Jython from within the Oracle database. I had attempted this in the past with no luck. Since I have purchased your book, I have tried it again using your examples and I have no luck.
When I attempt to utilize the Jython from within the database, my session hangs and maxes out the CPU for my server. I've also tried writing my own Jython script using the PythonInterpreter and still no luck.
I have no problems using Java Stored Procedures, but Jython just does not want to work. Any suggestions or other examples?
Thanks
Hi Josh,
Which RDBMS release are you using? Could you compile and load the Python runtime without problem?
When you run the example in the book, could walk through steps a-f without problem?
If the answer is yes to the above, have you installed the NCOMP libraries out of the companion CD? I have not made this a requirement but maybe the fact that system classes are being interpreted instead of running binary compiled is maxing out the CPU?
Kuassi
I am using Oracle 10.1.0.5 with all critical patches applied.
I have not successfully ran through steps a through f in the book. If I only load Fib.class, then it is invalid because the compile error states that it cannot find Fib$_PyInner.class. I have loaded Fib$_PyInner.class into the database as well. I then performed step e in the tutorial. When I attempt to perform step f, I receive the following error:
ORA-29532: Java call terminated by uncaught Java exception: java.lang.NoClassDefFoundError
This error does not make sense because the classes are loaded and valid within the database.
Thanks for your response...your book is great.
Josh,
Inspect the trace files for the detailed Java stack trace with NoClassDefFoundError.
Check any abnormality during loading the Jython or the Fibonacci clases.
Kuassi
Looks like a security issue because in the trace files I am seeing the following:
java.lang.OutOfMemoryError
at java.lang.SecurityManager.getClassContext(Native Method)
at oracle.aurora.rdbms.SecurityManagerImpl.checkMemberAccess(SecurityManagerImpl.java:166)
at java.lang.Class.checkMemberAccess(Class.java:1425)
at java.lang.Class.getDeclaredMethod(Class.java:1242)
at org.python.core.PyType.addFromClass(Unknown Source)
... (many other Python classes marked as unknown source)
I will review Chapter 2 of your book once again to see if I can find the answer. I have created a separate schema to load Jython. This schema is not a DBA and it only has the RESOURCE role...perhaps this is the issue?
Josh
Josh,
I must confess that i used the same schema for all the code samples and it was granted lot of permissions. Maybe granting the schema in question more DBA preivilegss might make the security manager happy.
Kuassi
Thanks for the help. I will try and grant more privileges to the schema which I had created for these examples.
Josh
Sorry to continue harping on the issue. I really want to make this work though.
Ok, I have granted my "jython" schema more permissions. I have also followed example in your book to a 'T' and I run into this issue:
java.lang.ExceptionInInitializerError
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:154)
at org.python.core.Py.class$(Unknown Source)
at org.python.core.Py.clinit(Unknown Source)
at Fib.fib(Fib.java:92)
at Fib.fib_wrapper(Fib.java:106)
Caused by: java.lang.IllegalStateException: Jython interpreter state not initialized. You need to call PySystemState.initialize or PythonInterpreter.initialize.
at org.python.core.InternalTables.createInternalTables(Unknown Source)
Now, I have tried to invoke PySystemState.initialize() from within the fib_wrapper() method and then I receive an OutOfMemory() error. It appears from the trace file dump that this made the application run infinite loops.
Thanks again for the assistance.
Josh
Josh,
Sorry for the bumpy road; i appreciate your persistence.
Maybe there is a recursion that is deep enough to cause OutOfMemory situation. I'd suggest to outrageously increase the heap size (i.e., Oldspace) as indicated in Memtest.sql (chapter 2).
Hope this helps, Kuassi
Forgive my exuberance, but as Oracle/Java young apostle, i can't hide my joy after gleaning through your book: Oracle Database Programming using Java and Web Services. It gathers enough muscle to make the young and seasoned DBA/Developer re-learned the basics things again. I am trying to get my copy. I have been trying to do that since last year :). However, there is no information about Fusion Middleware in the book, though there was a treat on Oracle APS 10.1.0.
Finally, what else does it take to be a seasoned Oracle DBA/JAVA Developer after having waiting in the trench for more than 3 years? But, there is no going back now. Thanks for a wonderful contribution to the Oracle/JAVA Developer community.
Hi,
THanks for sharing your enthousiasm.
The primary focus of this book the Oracle database, covering Fusion Middleware would make the scope too wide and the book too big. But i agree, a DBA/administrators focus book on Fusion Middleware will be a useful complement to this one; let me look into it.
An Oracle DBA/Java Developer needs also to start playing with OC4J (using the OTN cod samples).
Thank you foryour apprecation of my contribution.
Have fun.
Kuassi
nice site for more books I have some more gifts..
Reference books
Books
Kitaben
books
Reference Books
tutorials
rapidshare tutorials
rapidshare books
MZWorld
Upload Books
MZWorld Library
Books Forum
Never really got the embedded Jython functioning as exptected, but that is ok. Perhaps I will resume that activity when I find some more time.
I just wanted to share that your web services information is also excellent. I never knew that JDeveloper had the ability to expose PL/SQL packages as web services with such ease.
Overall, great book...when is your next one going to be published?
Josh,
I realy wish you had the Jython sample working; I'll revisit it on my own whenever i can.
I am glad that you found the Web services part useful/interesting.
I plan to write a follow up to this book in a couple of years when there are sufficient new products/functionalities; in th emean time, i will be co-authoring a fusion middleware book but i cannot give more details, at this time.
Kuassi
Josh,
I realy wish you had the Jython sample working; I'll revisit it on my own whenever i can.
I am glad that you found the Web services part useful/interesting.
I plan to write a follow up to this book in a couple of years when there are sufficient new products/functionalities; in th emean time, i will be co-authoring a fusion middleware book but i cannot give more details, at this time.
Kuassi
Is it available in Brazilian Portuguese?
Hi,
Unfortunately, it is currently only available in English.
If a Brazilian/Portugese publisher would step up and invest in the translation, maybe this will happen.
Kuassi
Hi,
Your SAP/BAPI vs PLSQL integration stuff saved my life, thank you!
Dear Tamas,
I am glad to hear that; kudos to Estaban Capoccetti who implemented this solution.
Spread the word.
Kuassi
Nice and knowledgeable sites for everyone-
booksshelf
knowledge
books
liberary
kitaben
Books and references
books
tutorial books
Amazon Germany mis-spelled your name:
http://www.amazon.de/Oracle-Database-Programming-using-Services/dp/1555583296/ref=sr_1_1/303-9285894-9917844?ie=UTF8&s=books-intl-de&qid=1189610137&sr=1-1
Hi,
Good catch; i have requested a fix, a while back but this is not happening. To their defense, they put what my publisher gave them.
Kuassi
get rid of adult acne
food and wine pairing
weight loss workouts
couture wedding gown
home bath spa
Hi, Kuassi,
Does server-side load-balance work with jdbc thin client?
Victor,
If by server-side load-balancing you mean runtime connection load balancing, yes it works for both jdbd-thin and jdbc-oci.
Kuassi
companies marketing mineral makeups and also get the best bargains in mineral makeup you can imagine,
find aout how to consolidate your students loans or just how to lower your actual rates.,
looking for breast enlargements? in Rochester,
homeopathy for eczema learn about it.,
Allergies, information about lipitor,
save big with great bargains in mineral makeup,
change edition interviewing motivational people preparing second,
interviewing motivational people preparing second time,
interviewing people motivational preparing for a second time,
black mold exposure,
black mold exposure symptoms,
black mold symptoms of exposure,
free job interview questions,
free job interview answers,
interview answers to get a job,
lookfor hair styles for fine thin hair,
search hair styles for fine thin hair,
hair styles for fine thin hair,
beach resort in the philippines,
great beach resort in the philippines,
luxury beach resort in the philippines,
iron garden gates, here,
iron garden gates,
wrought iron garden gates
, here,
wrought iron garden gates
,
You: The Owner's Manual: An Insider's Guide to the Body That Will Make You Healthier and Younger
,
eat eating mindless more than think we we why
,
texturizer,
texturizers here,
black hair texturizer,
find aout how care curly hair,
find about how to care curly hair,
care curly hair,
lipitor rash,
lipitor reactions,
new house ventura california,
the house new houston tx,
new house washington dc,
new house pa philadelphia,
san antonio tx house new,
house new pa philadelphia,
new house washington dc,
new house ventura california,
the house new houston tx,
house new san antonio tx,
the house new houston tx, that you are looking for,
new house ventura california, you need to buy,
new house washington dc,
house new pa philadelphia,
new house san antonio tx,
hair surgery transplant,
air filter allergy,
refurbished dell laptop computers,
hair surgery transplant,
air filter allergy,
refurbished dell laptop computers,
hair surgery transplant,
air filter allergy,
refurbished dell laptop computers,
chocolate esophagus heartburn study,
chocolate esophagus heartburn studybe informed,
digestion healing healthy heartburn natural preventing way,
digestion healing healthy heartburn natural preventing way,
sew skirts, 16simple styles you can make!,
sew what skirts 16 simple styles you,
rebates and discounts on sunsetter awnings,
sunsetter awnings discounts and rebates,
discount on sunsetter awnings
truck and bus tires 12r 22.5, get the best price,
tires truck and bus 12r 22.5 best price,
tires truck bus tires12r 22.5 best price,
plush car seat strap covers,
car seat strap covers,plush,
car seat strap, plush covers,
oscoda voip phone systems, the best!,
oscoda voip the phone system,
oscoda voip phone systems,
exterior iron gates,
oriental wrought iron gates,
powder coated iron garden fencing,
black mold exposure,
black mold symptoms of exposure,
wrought iron garden gates,
your next iron garden gates, here,
hair styles for fine thin hair,
search hair styles for fine thin hair,
night vision binoculars,
buy, night vision binoculars,
lipitor reactions,
lipitor reactions,
luxury beach resort in the philippines,
beach resort in the philippines,
homeopathy for baby eczema.,
homeopathy for baby eczema.,
save big with great mineral makeup bargains,
companies marketing mineral makeups,
prodam iphone praha,
Apple prodam iphone praha,
iphone clone cect manual,
manual for iphone clone cect,
fero 52 binoculars night vision,
fero 52 night vision,
best night vision binoculars,
buy, best night vision binoculars,
computer programs to make photo albums,
computer programs, make photo albums,
Post a Comment
Links to this post:
Create a Link
<< Home