JDBC Using GetBestRowIdentifier

Go back to: Code Samples 
...
ResultSet WSrowid = WSdbmd.getBestRowIdentifier() 
   (... "employees", ...);
...
WSs.executeUpdate("UPDATE employees SET ADDRESS = ? WHERE ROWID = ?";
// fastest access to the data!




Like what you see? Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • LinkedIn
  • Reddit
  • StumbleUpon
  • Technorati
  • TwitThis

Buy the Book

This book is for software architects, IT staff, DBAs, and developers to use in their daily work to predict, diagnose, and solve performance issues in their database applications.

Get Connected

Facebook Twitter

Corporate Sponsor

Data Direct

News and Announcements...

Brent Ozar – SQL Server DBA, "What’s On My Bookshelf?" September 28, 2009

http://www.brentozar.com/archive/2009/09/whats-on-my-bookshelf/

ebizQ, “Data Access in SOA Environments,” Sept. 9, 2009

http://www.ebizq.net/topics/soa_management/features/11676.html

Enterprise Systems Journal, “Achieving Optimal Database Application Performance: Benchmark Tips and Techniques,” Sept. 8, 2009

http://esj.com/articles/2009/09/08/achieving-database-performance-1.aspx?sc_lang=en

Desicritics.org, Biz/Tech, "Book Review, The Data Access Handbook - Achieving optimal database application performance and scalability," July 5, 2009

http://desicritics.org/2009/07/05/201531.php

TechRepublic, Programming and Development, “Book review: The Data Access Handbook offers database performance tips,” June 16th, 2009

http://blogs.techrepublic.com.com/programming-and-development/?p=1331

Developer Snippets, “Data Access Handbook provides solutions to applications run faster and stronger,” May 16, 2009

http://www.developersnippets.com/2009/05/16/data-access-handbook-provides-solutions-to-applications-run-faster-and-stronger/



SQLServerCentral.com, “The Data Access Handbook – Sample Chapter,” May 15, 2009

http://www.sqlservercentral.com/articles/books/66925/


IT Knowledge Exchange “IT Bookworm: “Tuning Database Applications for Performance,” May 14, 2009

http://itknowledgeexchange.techtarget.com/bookworm/tuning-database-applications-for-performance/

Dr. Dobb’s Journal, “This Week’s Developers Reading List,” May 7, 2009

http://www.ddj.com/217300701;jsessionid=W0Z50E3RZUYZ0QSNDLOSKHSCJUNN2JVN


Sybase Blog, “I’d Rather Play Golf: Book Review on The Data Access Handbook,” April 21, 2009

http://iablog.sybase.com/paulley/2009/04/book-review-the-data-access-handbook/


Book Content Copyright © 2009 by Prentice Hall PTR. All rights reserved. | Corporate Sponsor DataDirect Technologies.