You can use the 5.1 driver to connect to MySQL 4.x. Note: Don't be confused by differences in server and driver versions. Add the driver version to the Driver Name, I changed mine to "MySQL JDBC Driver 5.1".Expand the Available Driver Templates folders, select "MySQL JDBC Driver".Select the appropriate folder for your database JDBC driver version, I selected MySQL > 5.1, Click Add.button to add your JDBC driver to the Select a driver dropdown menu. Name the Connection Profile for the host and database to which you're connecting (i.e.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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |