The Toolbox for Java provides direct record-level access to the iSeries database for Java applications.
Performance - When the iSeries Toolbox for Java was introduced, I believe that the database access was several times faster that JDBC. However, database access times are typically a small component of the overall application performance and JDBC performance has improved. If the main function of your application is database access, you will want to test the performance differences between the two access methods.
Most iSeries applications used direct reads and writes. The Toolbox for Java provided that capability for Java applications.
The greatest advantage that Java has over others is its portability and its e-business strengths. When you start employing database access methods that are unique to the platform, you have compromised the portability of your application. This may make porting to another platform extremely difficult in the future. If you chose to use direct database access, you should keep a log of every instance where you use this in case you want to port to another platform in the future.
I'm happy with the results I've gotten so far, twice the speed of NT's ASP.
================================== MORE INFORMATION ON THIS TOPIC ==================================
Ask your Web development questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: tips, tutorials and more.
Check out this live Q&A with Dave Slater and Jim Mason, How to best get started with WebSphere Development Tools.
This was first published in January 2002