Database Administration
MySQL is a comprehensive relational database management system and must be managed to achieve optimal functionality. Some of the issues that you need to understand include how to add users and set up permissions, how to import large amounts of data into various tables, when and how to make backups, and how to replicate data, among other functions. This chapter provides you with a guide to database administration in a development or staging environment. For a production-level system, we...
Updatable ResultSets
All of the applications we have written thus far have handled the issue of updating data within the database using the UPDATE query statement. In many cases, this is the only option. However, suppose we have an application that first executes a SELECT query that pulls data from the table, displays the information, and then allows the user to make changes. In this case, we can use a feature of the JDBC specification called updatable ResultSets. This feature allows us to change the data within...
DDConnectionBroker
The first link is to the DDConnectionBroker package designed to work with MySQL and an associated JDBC driver like Connector J. On the page you will find a link to download a JAR file called DDConnectionBroker.jar. Place this JAR file in your CLASSPATH. The JAR file includes code for a ConnectionPool with an API defined as Connection getConnection freeConnection Connection That s it The key to the DDConnectionBroker connection pool class is the constructor. As you can see, we define the number...