This week's book giveaway is in the HTML Pages with CSS and JavaScript forum.
We're giving away four copies of Testing JavaScript Applications and have Lucas da Costa on-line!
See this thread for details.
Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

About the book

 
Ranch Hand
Posts: 8943
Firefox Browser Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does the book cover pitfalls in JDBC ..Things to avoided and best pratices?
 
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How about the performance tuning in JDBC. Covered?
-------------
Sainudheen
 
author
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
 
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...
 
Author
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
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...
 
Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic