Finally got DBEdit for Eclipse Working

Well, for mySQL anyway...which is a start. (As with many aspects of using Eclipse) I could not find a walk through on how you actually do that anywhere, I figure I will do that here (and anyone who may know better, please correct me).rst, if you have not already done so (and assuming you are using mySQL 4.1) follow the instructions here to setup the jdbc drivers for mySQL (for the exact location of those find my previous post here).

For those of you who do not have dbedit yet, you can download it here.

Now, if you do not see the dbedit "view" (is that what you call it?) button on the tab on the top of your Eclipse view, you can click the little box/window with the plus mark, go to other and choose dbedit. Now, if it is not preselected, select that view by clicking the button.

In the white panel on the left, you can right click and go New > Connection. Once in the connection configuration panel, go to classpath, and click "Add Archive". Find the "cf_root/WEB-INF/lib" directory that you placed the mySQL drivers in. Now go back to the "common" tab, and the jdbc driver pull-down should be populated; choose "com.mysql.jdbc.Driver". Now put the location of the database in the format jdbc:mysql://[host]:[port]/[database], put your usename and password (I left the schema blank) and connect.

Your done. Wasn't that easy...umm...or maybe not so easy. Now if someone could show me why a similar setup (having downloaded the Microsoft JDBC Drivers) for MS SQL doesn't work...please.

UPDATE: (The connection string format I use for MS SQL is jdbc:Microsoft:Sqlserver://my-virtualserver:1433;DatabaseName=Pubs and the error I get for MS SQL is "java.lang.InstantiationException dbedit.core.DataException: Couldn't create Driver instance of:com.microsoft.jdbc.base.BaseDriver java.lang.InstantiationException")