Installing SQL Explorer Eclipse plug-in In Ganymede

Installing SQL Explorer Eclipse plug-in Using auto Update: Hat tip to 5thcross.wordpress.com.  I noticed this set of instructions had not been updated for a while but they worked like a charm. The tool seems to have picked up some support recently and may be a good addition to your toolbox. Paticularly since the Data Tools Platform Eclipse component still seems to have a way to go. I’ll be trying to use this along side Birt for report wrting to edit the underlying queries… we’ll see. These instructions are lifted verbatum, they work. With Eclipse 3.41 and SQL Explorer version 3.5.0.RC6

  • From the Eclipse menu,
    select Help->Software Update->Find and Install. You will be
    displayed with a Install/Update dialog box.
  • Select Search for new
    features to install radio button & click next.
  • Click on the New Remote
    Site on the right hand side of the Install dialog box
  • Enter the name as “SQL
    Explorer” & “http://eclipsesql.sourceforge.net/” (without quotes) for
    the url in the New Update Site dialog box and click ok.
  • Select the SQL Explorer
    site in the Install dialog box and click finish.
  • Once the search is
    finished, it will present with the features to install.
  • Select the features you
    want to install. In this case select SQL Explorer branch & click next.
  • Accept the license
    agreement & click next.
  • Select the install location
    where you want to install this plug-in. By default it will be installed
    into the eclipse plug-in directory. If you want to add another location
    click on the change location button on the lower right hand corner and
    specify the directory where you want to install. Once you are finished
    with the selections click on finish button.
Advertisements

Got Ganymede RC4 with Birt Running on Win xp sp3

As I thought might be the case my problems seem to have been due to massive user error. The key is that one must start a project before trying to set anything else up, and.. The BIRT package comes with its own version of data explorer that is not the same as the main Eclipse DTP. I sill have not gotten the data tools platform (DTP) working with My Mysql database. I did get a sample report going with MY mysql database. so that is a start. For help on this if you are as confused as I was, and to some extent still am see the screen shots from me and the from the great help from an Actuate master (BIRT developer). see the bug 236647 (in Bugzilla) for some useful info for the total newbie!

So a key that I don’t think is highlighted in Eclipse Docs is that you must have STARTED A PROJECT, before anything else works properly, makes sense since it uses the project workspace to store all environment info…

If any one has an idea how or where one should put the MYSQL driver into the Eclipse environment so that it will work with the DTP I’d appreciate it! Currently I just get the “can’t find it” message even though it is displayed in the Jar file tab…(and I did set up another project to test it)

I’m still drinking through a fire hose trying to learn Eclipse, MYSQL, and JAVA all at once,(along with BIRT and probably a few other items)