Tagged: database

Tomcat Logo 0

Add Connection Pool with auto connection cleanup functionality for Tomcat 7 and MySQL

Since we don’t want to use external classes or libraries to handle database connections for our web applications we should stick to what comes built-in with the container server – in my case Apache Tomcat 7 and MySQL database server. To keep the database connection pooling and cleanup functionality on...

Resetting user password in Mantis BugTracker 0

Resetting user password in Mantis BugTracker

In case you forgot your Mantis BugTracker password here is a a simple way to reset it. This approach assumes that you have write access to the database table mantis_user_table. So in order to reset the password for a given user find and update the respective entry’s password column with...

Updating Tables across multiple Databases 0

Updating Tables across multiple Databases

Recently I was asked if it is possible to update tables with data from other databases. Of course it is 🙂 Imagine the case where you want to update your customer table with data from a backup database. Let’s call the current database currentDB and the backup backupDB and the...