I installed the Eclipse DBEdit Plug-in today in order to try to save some development time. The plug-in looks pretty cool, but took some time to install. I first tried to see if I could use the Macromedia JDBC drivers that were on my box, since I already have CFMX 7 installed. Turns out you get an "Restricted Access" message when trying to use the Macromedia drivers when you're not using a Macromedia product. This lead me to installing the Microsoft SQL Server JDBC drivers.
Here's what I had to do to get DBEdit installed. I think many good open source projects go unused because often there's a complete lack of instructions for getting the project installed and getting it operational. So if you're using SQL Server 2000 and Eclipse and want to get DBEdit running, you've come to the right place!
NOTE:If using WinRAR, you should be able to open up "mssqlserver.tar" and then open up the "msjdbc.tar" and browse to the "./lib" folder without extracting all the .tar files.
NOTE:If you want to specify database other than the default database for the user you're logging into, you can specify the database to log into by default, by adding the databaseName argument to the URL string. (Where XXX is the name of the database.)
If all goes well, you should see your database info.
TIP: Some tips for using DBEdit
- From the Tables pain, hit [CTRL][F10] to see the "View Menu".
- To see all databases, click the "Show All Catalogs" option.
- To view the column types, click the "Show Column Types" option.
- To filter out system tables, go to the "Filters..." option and configure your options as:
NOTE:If you're looking for information on installing the SQL Explorer Eclipse plug-in, check out Shlomy Gantz's blog Installing SQL 2000 JDBC drivers on Eclipse using SQL Explorer plugin. It was via his blog entry that I discovered how to install the JDBC drivers.