Running Oracle SQL Developer 3.0 under Ubuntu

Since Oracle doesn't provide the file deb for Ubuntu, you need to download Oracle SQL Developer for other platforms (usually is a zip file that doesn't not include a JDK), and follow the instructions below:

http://oracolodeidb.blogspot.com/2009/04/ubuntu-e-oracle-sql-developer.html

PS. As described in the article, I also needed to execute the following command:
$ cd ~/.sqldeveloper
$ echo /usr/lib/jvm/java-6-openjdk > jdk

Italian Postal Codes

The full list of italian postal codes (CAP), ready to use!

http://italy.fsfe.org/it/projects/cap/

See also:
http://www.michelem.org/2006/09/29/tutti-i-nuovi-cap-italiani-come-ottenere-il-database-completo/

Flow charts on line

this web site is very very nice
http://yuml.me/diagram/scruffy/class/draw

Remote Desktop under Linux

I've refined the parameters for rdesktop, to perfectly work with my resolution and my italian keyboard:

rdesktop -u administrator -g 90% -k it -PKD $IPaddress

PL/SQL into T-SQL

It's unbelievable!
Microsoft provides free tools to migrate database objects (stored procedures included) to SQL Server. Very very useful.

SSMA: Migration Made Easy
http://www.microsoft.com/sqlserver/2005/en/us/migration.aspx

CPU-Z

I've just discovered a program which allow us to know how many RAM banks are mounted inside our pc!
The program is CPU-Z, and you cand download it from here.

Running Reports with Oracle Report Server 10G using a web browser

Of course, it's possible to run Oracle reports with a simple http request.
This approach only requires Oracle Report Server installed on the machine/server and responding on its port 8889.

• Verify that you have all license rights to install Oracle Report Server


• Install a PDF reader (personally I love foxit reader)


• Verify that these environment variables are set:
  REPORTS_PATH = C:\your_reports_folder;
  PATH=C:/DevSuite10_home;C:/OLD_DevSuite9_home;etc...
  Important: Make sure your latest Dev
  Suite is on your PATH environment variable first, before any older versions!


• Start OC4J


• Start your web browser and run your report using this sintax:
  http://<reports server name>/reports/rwservlet?report=<report file name>&<other report parameters>

Example:
http://localhost:8889/reports/rwservlet?report=rep_007.rep&userid=username/password@192.168.19.58:1
521/ORCL&desformat=pdf&destype=cache&YOUR_REPORT_PARAMETER1=image.bmp&OTHER_REPORT_PARAMETERS=...

Common problems:
If your report calls other libraries, these must be in the same directory of the report, and must be compiled/recompiled with Oracle reports builder 10g.

To avoid errors like the following:

Not able to load oracle.reports.util.EnvironmentGlobal class
Using oracle.reports.util.Environment class

you must also generate/regenerate REP file using 10g Report Builder AND check whether the file/folder has enough privilege to the logged in user.
If you still have problems try to copy it to another folder: there might be problem with the acess right in your folder.

For reference:
Useful guide to Oracle Reports http://www.rittmanmead.com/files/quick_start_guide_oracle_reports.html
Using the Oracle Reports Web Service http://download.oracle.com/docs/cd/B10464_05/bi.904/b13673/pbr_webservice.htm
In the case that you can't use report server and you're forced to use something on the clients, thake a look at
http://www.orafaq.com/forum/t/37321/2/

How to insert code (such as HTML, PHP, Javascript code) in your Blogger post?

The solution is simple.

1. Copy the code into your NOTEPAD
2. Use Edit->Replace (or Ctrl+H) and in find all the < and replace them with & l t ; (delete the spaces between the characters, without spaces you would just see another < here)
3. Use Edit->Replace (or Ctrl+H) and in find all the > and replace them with & g t ; (delete the spaces between the characters, without spaces you would just see another > here)
4. Copy the code from NOTEPAD into the Blogger post
5. And you are done

What have you done? The & l t ; is another way of telling the browser to shov a <.

Simple!

.NET MVC and Jquery

To understand jquery a good place to start (how to show/hide divs, fade effects, and so on) is http://docs.jquery.com/Tutorials:Getting_Started_with_jQuery and http://visualjquery.com/

When you are planning to build a .NET MVC form which performs insert/edit/delete over a DB, it's very useful the jqgrid plugin. The only "problem" that I found with jqgrid is that it requires data in a json format and, IMHO, this is not very "comfortable".

If you make a google search, you'll find examples of MVC responses which make almost everything by their own.
It would be great if you keep all your javascript code in a proper contentplaceholder of your views:
<asp:ContentPlaceHolder ID="ScriptContent">
your code here
</asp:ContentPlaceHolder>

In the Master Page it must stay empty: ;-)
<asp:ContentPlaceHolder ID="ScriptContent" runat="server">
</asp:ContentPlaceHolder>

There is also the way to use Intellisense for jquery in Microsoft Visual Web Developer! to do this simply refer to the -vsdoc.js file in the head of your MasterPage:
<script src="../../Scripts/jquery-1.4.1-vsdoc.js" type="text/javascript"></script>

Install Windows or Linux from usb

To install Linux from USB I recommend UNetbootin.
UNetbootin allows you to create bootable Live USB drives for a variety of Linux distributions from Windows or Linux.

For what concern Windows, here's one of the best forums that explains how to install Windows from USB.

MvcContrib

http://www.jeremyskinner.co.uk/2009/03/01/mvccontrib-grid-part-5-the-action-syntax/

Acer Aspire 3810T: Fixes for Xubuntu 9.10

suspend fix
Change GRUB_CMDLINE_LINUX="" to GRUB_CMDLINE_LINUX="i8042.reset=1" in /etc/default/grub.
Run sudo update-grub.
Reboot.

NHibernate and MVC Guides

NHibernate
Official web site http://nhforge.org/
Getting started guide http://nhforge.org/wikis/howtonh/your-first-nhibernate-based-application.aspx
Good and quite complete article (in italian) http://aspnet.html.it/articoli/leggi/2563/introduzione-a-nhibernate/

MVC
Jeffrey Palermo's book released under Creative Commons license:
http://github.com/jeffreypalermo/mvc2inaction

Official web site http://www.asp.net/mvc/

Good guide (in italian, focused on MVC1 but concepts are the same) http://aspnet.html.it/guide/leggi/166/guida-aspnet-mvc/

A set of concepts reused in MVC and in NHibernate 3.0 (NHibernate 3.0 will be the first version to use .NET 3.5)
http://aspnet.html.it/articoli/leggi/3201/le-novita-di-aspnet-mvc-2/
http://aspnet.html.it/articoli/leggi/2510/le-novita-di-c-30/

How to resize a Virtualbox disk partition using GParted

http://www.my-guides.net/en/content/view/122/26

Data Recovery

A collection with the best programs useful for data recovery.

- RECUVA
- PC INSPECTOR File Recovery
- Panda Recovery
- TOKIWA DataRecovery
- SoftPerfect File Recovery
- Undelete Plus
- FreeUndelete
- ADRC Data Recovery Software Tools
- Glary Undelete
- Avira UnErase Personal

How to crak a WIFI LAN

Aircrack-ng is a cracking program that can recover keys once enough data packets have been captured.
It's also a set of tools for auditing wireless networks.

http://www.aircrack-ng.org/

HJ195

Free Utilities, Software Tools and Applications

Dia: a program to draw structured diagrams.

How to migrate existing Windows installations to VirtualBox

I've discovered that it's not so easy to migrate existing Windows installations in VirtualBox.

In my instance I was trying to migrate a Windows XP image, but I was stopped by a BSOD after the boot of the OS, which prompted an error with intelppm.sys (but this problem may also be caused by processr.sys).

The reason for this crash is because these drivers are attempting to perform an unsupported operation inside of the virtual machine.

To solve this problem you can manually disable these drivers (with no negative side effect) by going to the following location in the registry:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Processor

Or

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Intelppm

And changing the 'Start' value to '4'.

source

Window XP Service Pack

When you need XP Service Packs, it's always difficult to find them!

So, Here they are:

Download SP1

Download SP2

Download SP3

Form Grep & Form Diff

did you ever want to find code fragments into a set of Oracle Forms?
Form Grep is the solution

I also found very useful Form Diff, a software which allows you to locate differences between 2 Forms.

EDIT
A cheaper solution to find some text into a form (*.fmb *.fmx), library (*.pll *.plx) or report (*.rdf *.rep).
Under Linux simply type:

find . | xargs grep 'string' -sl

The -s is for summary and won't display warning messages such as grep: ./directory-name: Is a directory

The -l is for list, so we get just the filename and not all instances of the match displayed in the results.