Updates
Latest Tweet
What's New?
Check out for latest innovation, a computer based training video collection
Like this Page
JDBC Recipes: A Problem-Solution Approach Review by K. L. Twombly
JDBC Recipes full of flavor.
Do you like to read about programming? or Do you like to see the code with your own
eyes? I like to see it with my own eyes. Mahmoud Parsain has compiled a see it for yourself
book on the JDBC (Java Database Connectivity). If you like Java and you do any work with Databases
then you should read this book. It provides many many examples (Recipes) you can see and learn from to
create the Database solutions you need.
Here are some of the items covered and coded in the book: Making Connections, Drivers, Connection pools,
Using DataSource class, ResultSet class, Scrollable and updatable ResultSets, working with BLOBs and CLOBs,
Handeling Date, Time and Timestamps, JDBC Exceptions, PreparedStatements, working with Parameters and
PreparedStatements. The book has all you need to simply add, update, delete records in your databases or
to create tables, perform transactions, and roll back transactions if necessary.
The book focuses on Oracle and MySQL type databases but this is not a draw back. All the examples can
be applied to various other types such as Derby, SqlServer, Teradata, DB2, SqlLite, Sysbase ect. I am a ETL
developer (Extract, Translate, and Load) for warehouse databases and I was able to easily apply this code
to create my own simple Sql ETL application to move data from one RDBMS to another.
There were two items in the book that I did not find. One was the setMaxRows statment which can be
handy to limit the number of rows being returned from the database. The other was the getTypeInfo call that is
part of the DatabaseMetadata class. You can use the getTypeInfo call to get a list of the data types the
database you are connecting to supports. However, even with these missing the book hits just about every
other property and method commonly used in the JDBC api.
Mahmoud Parsian has done a great job in providing such a comprehensive set of JDBC code examples
that are simple to follow. Apress has produced another great reference for the Java programmer to have
on the shelf.