Analog Coast

This is somewhat a brain dump so I don’t forget. This all relates to SQL Developer 1.5.4

Connecting to Remote SVN Repository

In order to connect SQL Developer to a remote SVN repository you must jump through some hoops since the initial connection dialog doesn’t allow you to type in a remote URL. The dialog only allows local file system paths.

So to connect to http://www.example.com/svn/Database/trunk you have to jump through these hoops:

1. Create a local repository Using “Versioning | Subversion | Create repository…”. Pick a repository path in your temp directory that doesn’t exist. This creates new entry in the repository manager which we can customise later.
   
   
2. Now you should see a Versioning panel somewhere in the application. Select the RemoteSVNRepository node and right click on it. Select “Properties…”
3. You will be presented with this dialog. Fill in your remote repository URL, username and password.
    
4. Click on Test Read access. You should see the client connecting
5. Click on OK
6. Right click on the connection, Select “Check out…” and you’re in business!

SQL Developer Results pane not showing results

It seems that SQL Developer makes a distinction between me running a Statement (F9) and running a script (F5). If you run something like

SELECT "AHA!" as str FROM DUAL

So, same statement executed, but you get two completely different representations:

Statement (F9) you get the results in a nice data table	Script (F5) you get console output representation

Ungh. It took me only 2 months to figure this out.