Thursday 14 November 2013

Creating Database Connection in Eclipse DTP

In this post, I will create a database connection in Eclipse to MySQL database.

List of software you need:
  • Eclipse IDE with DTP(Data Tools Platfoem). I am using Eclipse Java EE IDE version Kepler which comes with built in DTP. You can download this from Eclipse download page
  • MySQL Server. You will need to install MySQL server. I have installed MySQL Community Server 5.6. You can download it from MySQL Server Download page. This is a link to give more information about installation of MySQL server - Install and configure MySQL Server
  • MySQL Connection driver for Java. You can download it from this page. This will be a zip or gz compressed file. You have to extract it at any location. This contains a .jar file. I am using mysql-connector-java-5.1.25-bin.jar .