JOIN ON multiple conditions

If you want to write an sql join on more than one condition you have to keep in mind that the from clause could just have one condition. Example:

SELECT  * FROM person p, accounts a

  LEFT JOIN preferences  pref ON pref.id = p.pref_id AND pref.name = 'glue'

 will fail, but this

SELECT  * FROM person p

  LEFT JOIN preferences  pref ON pref.id = p.pref_id AND pref.name = 'glue'

  LEFT JOIN accounts a   ON a.id = p.account_id AND a.name = 'snoop'

will work.

Manual DVD eject MACOSX

if the DVD icon in Finder is gone you could use

drutil eject

within a terminal.

Creation and usage of SSH Identity Files for OpenSSH or SFTP

Here is a quick step by step list how to setup an use an identity file with SSH or SFTP

1. Create a private and a public key with 

    ssh-keygen -t dsa

2. Now you should have something like 

   id_dsa and id_dsa.pub

3. Add the content of the public key file id_dsa.pub to the users .ssh/authorized_keys file folder on the host you want to connect with 

   cat id_dsa.pub >> .ssh/authorized_keys

4. Now you should be ready to connect to the host with i.e.
             sftp -o IdentityFile=id_dsa user@host

     ssh  -i id_dsa user@host

HTC Desire HD und die gelben Bilder

Falls ihr euch über die gelblichen Bilder von eurem HTC Desire HD wundert, dann geht einfach mal in das Menu der Kamera Anwendung. Dort befindet sich der Menupunkt Weissabgleich. Hier ist per Default Tageslicht eingestellt. Stellt es mal auf Auto. Das wirkt Wunder :-)

Command prompt from here

Well sometimes I need a cmd right from the directory in the explorer within Windows. Microsoft offered the so called MS Powertoys, which have had a feature called command prompt from here. What that does was just a simple registry entry, which added an entry to the folder context menu. If you want to have such an extension you could easily add the following to your registry:



[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\command prompt]
@="Devenv from here"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\command prompt\command]
@="C:\\bin\\devenv.cmd %L"

(Just paste the lines above into a file with a .reg extension and click on it)

Now you could create a file called C:\bin\devenv.cmd and add you favorite Path extensions or variables. After adding the two entries to your registry you will see a new entry when you right click on a folder "Devenv from here".

Eclipse Galileo 3.5.1 Index Problems

After a while working with eclipse Galileo SR1 the startup of the IDE slows down. Beside this I frequently got an error like that:

Class file name must end with .class

To fix this I've done the following:

1. Close Eclipse
2. Delete /.metadata/.plugins/org.eclipse.jdt.core/*.index
3. Delete /.metadata/.plugins/org.eclipse.jdt.core/savedIndexNames.txt
4. Start Eclipse again

The eclipse bug list mentioned the behaviour in defect 286379 fixed for Milestone 3.6 M3.

Instantiate a Generic Type in Java

Once you used generics for a while you might stumble upon the following question:

public class MySample {
       private     T    mySample = null;


       public MySample() {
               mySample = new T();  // well this would be fine, but it doesn't work because the compiler doesn't know the type at this time!
      }
}

Ok, fair enough the compiler doesn't know if T is an interface or an object and couldn't instantiate the type. If your T is a class you could solve the question with this:

public class MySample {

       private     T    mySample = null;

       public MySample(Class _class) {

               mySample = _class.newInstance();

      }

}

This should work with the little overhead of specifying the class in the generic and the constructor:

  MySample  sample = new MySample(Whatever.class);