
Expand Connection Profiles and select Connection Profile, Next >. You'll be able to reuse this template when creating future connection profiles. Next, create a driver template and a connection profile. I dropped mine in /Library/Java/Extensions on my Mac.Ĭreate a Driver Template and Connection Profile Download the source and binaries and save somewhere that makes sense for your OS. Select 'Connector/J' in the left menu, then select a version. You can usually get drivers from the vendor. You must install the appropriate driver for the database server you're using. Installing Eclipse and DTP does not install JDBC drivers. MySQL user account with a database or privileges to create databases. MySQL Server version 4 or 5 running on localhost or a remote host that allows remote connections. MySQL JDBC Driver, I'm using Connect/J 5.1. Eclipse with the DTP plugin, I'm running Eclipse 3.3 which came bundled with DTP version 1.5.0. Here's what you'll need before we get started. I'm also assuming that you've used Eclipse for a bit and have at least one project defined. I'll assume that you're comfortable installing Eclipse and Eclipse plugins. This post covers connecting to MySQL and basic DTP features. The DTP plugin supports several database platforms via JDBC, including Derby, Oracle, MS SQL, Postgres, Sybase ASA, Flat Files, XML Data, Web Services, and more. The Eclipse Data Tools Platform (DTP) is a standard Eclipse plugin that you can use to perform most database development and query functions.
#Jdbc driver for eclipse mac how to#
In this post I'll show you how to take advantage of another part of the "I" in the Eclipse "IDE". Sure, it's not a big deal to switch back and forth between Eclipse and the MySQL Query Browser or phpMyAdmin, but those seconds add up. I mean lazy like looking for 10 minutes for a lost TV remote rather than getting off the couch to change the channel.