for reference to add sql syntax highlighting / coloring to eclipse
you can install `Data tools platform extender sdk` from &quot;install new software&quot;, under `Database Development`

or enter site location directly
http://download.eclipse.org/datatools/updates

This [Eclipse SQL Editor][1] seems very lightweight.  It only does syntax highlighting and provides an outline view.  As of now the author is planning to eventually add code folding and completion, but those two features are still on the todo list.


  [1]: http://web.archive.org/web/20120104065151/http://blog.debertshaeuser.com/index.php?page=eclipse-sql-editor

Use [Toad eclipse-extension][1] (community edition), you will get almost everything you want in an SQL editor. Search for &#39;toad&#39; in eclipse market place. It has very good Oracle, MySQL and PostgreSQL support.

Take a look at [Installation instructions and screenshots][2].


Alternatively, there is [DBeaver][3] (very good in my experience and support almost all DB&#39;s) which is built on eclipse platform and available as standalone and eclipse plugin.


  [1]: http://www.toadworld.com/products/toad-extension-for-eclipse/default.aspx
  [2]: http://www.toadworld.com/products/toad-extension-for-eclipse/w/wiki/10446.toad-extension-for-eclipse-installation.aspx
  [3]: http://dbeaver.jkiss.org/

The [eclipse SQLExplorer][1] plugin seems light enough, and comes with a basic [SQL editor][2] (but no &quot;format&quot; option):

alt text

----

The official [DTP DataTool Project][3] is much complete, but have also [its own editor][4]:

![DTP Editor][5]


  [1]: http://eclipsesql.sourceforge.net/sqleditor.php
  [2]: http://eclipsesql.sourceforge.net/sqleditor.php
  [3]: http://www.eclipse.org/datatools/
  [4]: http://wiki.eclipse.org/Getting_Started_with_DTP
  [5]: http://i.stack.imgur.com/tDTSO.jpg

QuantumDB is also a lightweight option that I really liked.

http://quantum.sourceforge.net/

Just found DBeaver : http://dbeaver.jkiss.org/

looks good, plenty of features, support mssql (which I need in the moment :) ... I&#39;ll give it a try ...

 

When we are updating a record, we can use `session.flush()` with Hibernate. What&#39;s the need for `flush()`?

What&#39;s the use of session.flush() in Hibernate

I would like to sort my list with the `date` property.

This is my custom class:

```c#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Test.Web
{
    public class cTag
    {
        public int id { get; set; }
        public int regnumber { get; set; }
        public string date { get; set; }
    }
}
```

An this is the `List` that I want to sort:

```c#
List&lt;cTag&gt; Week = new List&lt;cTag&gt;();
```

I want to sort the `List` by the `date` property of the `cTag` class.
The date is in the format `dd.MM.yyyy`.

I read something about the `IComparable` interface, but I don&#39;t know how to use it.

Sort a Custom Class List&lt;T&gt;

Is there any simple SQL editor in Eclipse? Or do I need to find a simple SQL editor plugin for Eclipse?

By simple I mean, the editor does **NOT** connect to any DB, does syntax highlighting and preferably formatting sql is a bonus.

Lightweight SQL editor for Eclipse

Is there any simple SQL editor in Eclipse? Or do I need to find a simple SQL editor plugin for Eclipse?
By simple I mean, the editor does NOT connect to any DB, does syntax highlighting and preferably formatting sql is a bonus.

In my MySQL InnoDB database, I have dirty zip code data that I want to clean up.

The clean zip code data is when I have all 5 digits for a zip code (e.g. &quot;90210&quot;).

But for some reason, I noticed in my database that for zipcodes that start with a &quot;0&quot;, the 0 has been dropped.

So &quot;**Holtsville, New York**&quot; with zipcode &quot;`00544`&quot; is stored in my database as &quot;`544`&quot;

and

&quot;**Dedham, MA**&quot; with zipcode &quot;`02026`&quot; is stored in my database as &quot;`2026`&quot;.

What SQL can I run to front pad &quot;0&quot; to any zipcode that is not 5 digits in length? Meaning, if the zipcode is 3 digits in length, front pad &quot;00&quot;. If the zipcode is 4 digits in length, front pad just &quot;0&quot;.

**UPDATE**:

I just changed the zipcode to be datatype VARCHAR(5)

MySQL - how to front pad zip code with &quot;0&quot;?

I have a query like this:

    SELECT
        jobs.*, 
        (
            CASE
                WHEN lead_informations.state IS NOT NULL THEN lead_informations.state
                ELSE &#39;NEW&#39;
            END
        ) AS lead_state
    FROM
        jobs
        LEFT JOIN lead_informations ON
            lead_informations.job_id = jobs.id
            AND
            lead_informations.mechanic_id = 3
    WHERE
        lead_state = &#39;NEW&#39;

Which gives the following error:

    PGError: ERROR:  column &quot;lead_state&quot; does not exist
    LINE 1: ...s.id AND lead_informations.mechanic_id = 3 WHERE (lead_state...

In MySql this is valid, but apparently not in Postgresql. From what I can gather, the reason is that the `SELECT` part of the query is evaluated later than the `WHERE` part. Is there a common workaround for this problem?

Using an Alias column in the where clause in Postgresql

I have H2DB database which stores data in files. I have 3 files: `test.18.log.db`, `test.data.db`, and `test.index.db`.

I want get SQL dump file like when I use `mysqldump`. Is it possible?


How in H2DB get sql dump like in MySql?

I&#39;m playing around with a little web app in web.py, and am setting up a url to return a JSON object. What&#39;s the best way to convert a SQL table to JSON using python? 

return SQL table as JSON in python

How to convert a column value from `varbinary(max)` to `varchar` in human-readable form?

varbinary to string on SQL Server

When using the &quot;file search&quot; function in eclipse to find a bit of text in a &quot;.java&quot; file, I may get a list of several search results.  Let&#39;s say I double click on the file &quot;A.java&quot; which then opens A.java in a new editor tab.  If I then use the &quot;file search&quot; function again to find some other bit of text and this time double click on the file &quot;B.java&quot;, this file will replace &quot;A.java&quot; in the editor.  

I&#39;d like Eclipse to open a new editor for B.java so that both A.java and B.java are available in my editor tabs.  Is this possible?  I&#39;ve had a look around in the preferences but I&#39;m not sure what option would give me this bit of functionality.


Eclipse: Files opened by multiple searches using same editor tab

You know how in Eclipse, pressing &lt;kbd&gt;F3&lt;/kbd&gt; over a method will take you to its declaration? Well I have a method that is part of an interface; clicking &lt;kbd&gt;F3&lt;/kbd&gt; over this naturally takes me to the declaring interface.

Obviously there is an object implementing this interface and this is where the method is actually implemented.  I want, when I press &lt;kbd&gt;F3&lt;/kbd&gt;, to jump to the implementation, not the interface declaration. I know that the implementation may not be known at compile-time, so is there a way for Eclipse to show me all the classes implementing the interface so that I can select which implemented method to view? Right now when this happens I am just manually searching for this to find the implemented method.

Jump into interface implementation in Eclipse IDE

I selected API minimum level 1.5 for my android app and I&#39;m just about to integrate gestures in to it which came in 1.6. Is there a way in Eclipse to change the minimum level from 1.5 to 1.6 halfway through building an app?

Many thanks

Can you change min. API level for your Android app in Eclipse?

While working on a simple program in Android, I mistakenly closed LogCat window and I want to know how to show it again.


How to enable LogCat/Console in Eclipse for Android?

How to import a jar in Eclipse?

I program with eclipse and sometimes use GUI text editors like SciTE or vim. However, I&#39;m at a point in a project that requires me to edit files over a ssh connection in a 80 column SSH window.

Since I have to (* shiver*) `sudo vim` before I can open the file I&#39;m not sure how to open the file in an editor *outside the terminal* (that would allow me to see the text wider than 80 columns). If the command line was larger then I guess using straight vim wouldn&#39;t be a problem.

I&#39;m at a loss of how to deal with this situation and how I could turn this nightmare into a manageable coding environment.

How do you edit files over SSH?

How do I enable word wrap for SQL Server Management Studio 2008&#39;s query editor? 

How to word wrap in SQL Server Management Studio

In vim, FIXME and TODO are highlighted, but I can&#39;t get FIXME: and TODO: (note the colon after the keyword) to highlight? What should I put in my .vimrc to make this happen?

In vim, how do I highlight TODO: and FIXME:?

Besides the new Google Docs, all the other WYSIWYG web-based rich text editors (ckeditor, tinymce, old Google Docs) I&#39;ve seen are based on contenteditable or designMode. I personally hate using these editors. It doesn&#39;t take much formatting or copying/pasting before the whole experience turns into an exercise in frustration. Returns suddenly start getting double-spaced, unintended formatting gets introduced via pasting from other HTML sources, undo&#39;s/redo&#39;s are completely broken, formatting becomes excruciatingly difficult to control, etc.

I believe this is one of the reasons Google Docs introduced its own much more constrained, non-HTML formatting engine. Is there any open-source library out there that provides something similar? Thanks in advance.

Any WYSIWYG rich text editor that doesn&#39;t use HTML (contenteditable or designMode), a la (the new) Google Docs?

I can&#39;t find how to disable word-wrap in Xcode 4 editor. How can I do it?

How to disable word-wrap in Xcode 4 editor?

&gt; **Possible Duplicate:**  
&gt; [How can I make Eclipse file search not include svn directories?](https://stackoverflow.com/questions/41934/how-can-i-make-eclipse-file-search-not-include-svn-directories)  

&lt;!-- End of automatically inserted text --&gt;

I would like to perform a search but exclude all .svn directories from the search. How could I do that?

By the way, I have the Subversive plugin installed in Eclipse, if it&#39;s needed.

How to exclude .svn directories from search in Eclipse?

I&#39;m installing the Android SDK on a fresh installation of Fedora 14 (Linux). I installed eclipse, and ran the tools/android sdk tool to install all the Eclipse components for the SDK. I was able to get DDMS to install when selecting it by itself.

And for the last component - the Android developer tools, I&#39;m getting the ugly error message pasted below. 

Now I&#39;m Stuck in Eclipse dependency hell. 

I&#39;ve searched through the available packages in Fedora and I can&#39;t find the one that has the files necessary to satisfy this Eclipse dependency. Can anybody please translate what it is that Eclipse is asking for and what Fedora package it lives in?


The ugly error:

&lt;!-- language: lang-none --&gt;

    Cannot complete the install because one or more required items could not be found.
      Software being installed: Android Development Tools 0.9.9.v201009221407-60953 (com.android.ide.eclipse.adt.feature.group 0.9.9.v201009221407-60953)
      Missing requirement: Android Development Tools 0.9.9.v201009221407-60953 (com.android.ide.eclipse.adt.feature.group 0.9.9.v201009221407-60953) requires &#39;org.eclipse.wst.sse.core 0.0.0&#39; but it could not be found

ADT requires &#39;org.eclipse.wst.sse.core 0.0.0&#39; but it could not be found

I am trying to add the add SDK Platform 1.6 to an existing Install of 2.2, with the help of [this thread][1].

As suggested, I ran &lt;kbd&gt;Help&lt;/kbd&gt; → &lt;kbd&gt;Check for Updates&lt;/kbd&gt; which found and installed the following:

      + Android DDMS              8.0.1.v201012062107-82219
      + Android Development Tools 8.0.1.v201012062107-82219

It prompted for restarting Eclipse and when it restarted it gave me the following error message:

    &quot;SDK Platform Tools component is missing!
    Please use the SDK Manager to install it.&quot;

Huh? Why? I still have the SDK Platform Tools on C:\android-sdk-windows that was working perfectly before I did this &quot;upgrade&quot;.

What do I need to have both 2.2 and 1.6 supported in my development environment?


  [1]: https://stackoverflow.com/questions/4490726/how-to-install-old-sdk-platform


&quot;SDK Platform Tools component is missing!&quot;

I&#39;m using Eclipse Helios on Ubuntu 10.04, and I&#39;m trying to install CDT plugin on it. I download it from here [here][1]. 

And then I go to **Install New Software** and select the zip file (*I don&#39;t extract it, just select the zip file*). And its ok, it installs, everything works fine, it shows optional features, *blah blah blah*.

And then I create a new HelloWorld project. And when I try to run it, it shows an error and says:

Launch failed. Binary not found.

Can anyone explain me how to fix it?

Thanks.


  [1]: http://www.eclipse.org/downloads/download.php?file=/tools/cdt/releases/helios/dist/cdt-master-7.0.1.zip

Launch Failed. Binary not found. CDT on Eclipse Helios

I&#39;m running Eclipse 3.6.1 Classic, which does not come with the Eclipse Marketplace plugin by default. I&#39;ve looked around the Eclipse website, but I don&#39;t see an available plugin for installing Eclipse Marketplace. Am I just not seeing it?

Content Type	Original Author	Original Content on Stackoverflow
Question	nimcap	View Question on Stackoverflow
Solution 1 - Sql	Ben K	View Answer on Stackoverflow
Solution 2 - Sql	sam2themax	View Answer on Stackoverflow
Solution 3 - Sql	sojin	View Answer on Stackoverflow
Solution 4 - Sql	VonC	View Answer on Stackoverflow
Solution 5 - Sql	Shantanu Kumar	View Answer on Stackoverflow
Solution 6 - Sql	apocalypz	View Answer on Stackoverflow

Lightweight SQL editor for Eclipse

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

Solution 5 - Sql

Solution 6 - Sql

Sort a Custom Class List<T>

What's the use of session.flush() in Hibernate

Attributions