Today I was trying to get MySQL working with JDBC on my Macbook pro.

After doing some research I found out that I needed to get “MySQL Connector/J” in the Java extension map.

Here are the steps to get MySQL working with JDBC.

1. Download the MySQL Connect/J from the Mysql.com website.
2. Unzip the package!
3. Copy the “mysql-connector-java-5.1.7-bin.jar” file to your: /System/Library/Java/Extensions/ directory.
4. You can now use MySQL with JDBC!
5. You don’t need to add the jar file to your project in eclipse manually anymore!

Since I’m using Eclipse to develop with Java, it’s in my JRE System Library by default!

For testing if MySQl is working correctly I wrote a simple class.

SQL file:

CREATE TABLE IF NOT EXISTS `testtable` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `age` INT(11) NOT NULL,
  `city` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
 
INSERT INTO `testtable` (`id`, `name`, `age`, `city`) VALUES
(1, 'Mr. John Doe', 31, 'Groningen'),
(2, 'Mrs. Jane Doe', 31, 'Groningen');

Java:

/**
 * @author tomkeur
 */
import java.sql.*;
 
public class MySQLDatabase {
	public static void main(String[] args) {
		Connection conn = null;
 
		try {
			// SETTINGS: userName, passWord and dataBase.
			String userName = "root";
			String passWord = "";
			String dataBase = "test";
 
			// Creating class.
			Class.forName("com.mysql.jdbc.Driver").newInstance();
 
			// Let's create a connection.
			conn = DriverManager.getConnection("jdbc:mysql:///"+dataBase, userName, passWord);
 
			// Do we have a connection?
			if (!conn.isClosed())
			{
				// We have a MySQL Connection.
				Statement s = conn.createStatement ( );
				s.executeQuery ("SELECT * FROM testtable");
				ResultSet rs = s.getResultSet ( );
				while (rs.next()) // loop through rows of result set
				{
					int pkey = rs.getInt (1);
					String strName = rs.getString(2);
					int intAge = rs.getInt(3);
					String strCity = rs.getString(4);
					System.out.println ("uID: " + pkey + ", Name: " + strName + ", Age: " + intAge + ", City: " + strCity );
				}
				rs.close(); // close result set
				s.close(); // close statement
			}
		}
		catch (Exception e)
		{
			System.err.println("Exception: " + e.getMessage());
		}
		finally
		{
			// If we don't have a error, close the connection!
			try
			{
				if (conn != null)
				{
					conn.close();
				}
			}
			catch (SQLException e)
			{
 
			}
		}
	}
 
}

On Microsoft platsforms you can allso add the the jar file to:
C:\Program Files\Java\jreX.X.X_XX\lib\ext where the X’s are the version of your installed Java Runtime Environment (JRE).

So I now made the final decision to start a company especially for Photography. I call it Bright Photography, the website is currently under construction but soon I will post a online portfolio here. These are the types of photography I will aim on:

• Party photography
• Event photography
• Creating pictures of company’s for their websites.

In the meantime I opened a Flickr account, yeah I know I need to upload some more pictures but before I can do that I first need to make a few nice pictures because the last pictures that I’ve taken are work related. Pictures on my flickr account are not work related!

In the upcoming future I want to place more photographs on my blog, and write little stories about me or things that keep me busy.

And my blog is in English now.

After I’ve been searching alot I finally mananged it to delete MySQL from my Macbook pro.

The steps:

First you need to edit the file in: /etc/hostconfig and remove the line

Since this is a system file I advise you to open it with nano in terminal:

1. Open Terminal
2. sudo nano /etc/hostconfig
3. Enter your password if you’re not authed yet.
4. Delete the following line: “MYSQLCOM=-YES-”
5. CTRL+X (This is the command for closing NANO, Enter the “Y” key to save the file and exit nano).

Second step:

Make sure MySQL is not running.

1. Open Terminal and copy and paste and run the following commands:

sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm /etc/my.cnf

MySQL is now removed from your MAC.

Edit 26-02-2009:  Maarten van der Pee wrote a comment that it’s allso needed to delete the my.conf, I added it to the list of commands. Thanks Maarten!

Inmiddels woon ik in Groningen omdat ik hier Informatica ga studeren aan de Hanze Hogeschool (HBO).
Overigens ben ik zeer benieuwd naar mijn nieuwe rooster zodat ik tijd kan gaan vrij plannen om te freelancen, maar zodra ik mijn rooster heb zal ik wat meer actie ondernemen om aan projecten te kunnen werken.

Vrijdag begint de eerste officiële hockey training, ik kijk er naar uit!

Tot zover deze korte status update.