Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

About the book

 
Pradeep bhatt
Ranch Hand
Posts: 8927
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does the book cover pitfalls in JDBC ..Things to avoided and best pratices?
 
Sainudheen Mydeen
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How about the performance tuning in JDBC. Covered?
-------------
Sainudheen
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Speaking from memory, the book does discuss JDBC best practice and performance issues like always closing connections and so forth in a finally clause, being sane with LOBs, batch updates, concurrency levels and so forth. But on the other hand it doesn't (and shouldn't) go into much depth about database and driver specifics. Schema design and optimisation and writing performant SQL aren't covered at all.
- Peter
 
Ko Ko Naing
Ranch Hand
Posts: 3178
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The name of the book itself is "JDBC API Tutorial and Reference, Third Edition"... I guess it would emphasize on the APIs and some kinda how to use them...
 
Maydene Fisher
Author
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Pradeep Bhat:
Does the book cover pitfalls in JDBC ..Things to avoided and best pratices?

Hi Pradeep,
The reference part of the book has an overview section for each class and interface in the JDBC API. These sections include best practices and things to avoid when appropriate.
Cheers,
Maydene Fisher
 
Maydene Fisher
Author
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Sainudheen Mydeen:
How about the performance tuning in JDBC. Covered?
-------------
Sainudheen

Hi Sainudheen,
The book does not have a separate section on performance tuning, but there is information about what affects performance in various sections throughout the book.
Cheers,
Maydene Fisher
 
Sainudheen Mydeen
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Maydene Fisher:

but there is information about what affects performance in various sections throughout the book.
Cheers,
Maydene Fisher

That would be an excellent way to cover this topic. Thanks Maydene Fisher.
-Sainudheen
 
Ko Ko Naing
Ranch Hand
Posts: 3178
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Sainudheen Mydeen:

That would be an excellent way to cover this topic. Thanks Maydene Fisher.
-Sainudheen

I think such kind of topic somewhat depends on a particular database...
Different databases are dealing their performance tune on their own ways...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic