How to multiple insert on Oracle

If you want to insert multiple lines in Hbernate with SQL so you can rollback the all transaction, all you need to to is wrap the all thing using START and END

Basic Structure of PL/SQL

PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other. Typically, each block performs a logical action in he program. A block has the following structure:
DECLARE

/* Declarative section: variables, types, and local subprograms. */

BEGIN

/* Executable section: procedural and SQL statements go here. */

/* This is the only section of the block that is required. */

EXCEPTION

/* Exception handling section: error handling statements go here. */

END;

Electric USB Guitar (On Linux)

Behringer iAXE629

This post is about  IAXE629 from Behringer, which is a great electic guitar for noobs like me. Although it is a regultar guitar, that you can plug to a regular amplifier, it has a built-in USB sound card with low latency, that you can plug to a computer. This allows to amplify the sound in the computer (emulating virtually any guitar amplifier) and to output to any regular speakers or headphones. Obviously this means that you don’t need to buy or carry around with you a huge guitar amplifier or guitar pedals, because you have all the cpu power from your computer at your disposal.

Anyhow, the guitar comes with a low-latency driver for windows only, and a nice software with some guitar presets (although i would recommend getting Guitar Rig 3).

As for linux there are 3 options:

- Install jackd or qjackctl if you want a gui interface (in qt). Just read jack man as it has lots of options, but this is the setup that works best for me: jackd -p128 -dalsa -P hw:1 -C hw:1 -r44100 -p128 -n4 -s & (my guitar is usually connected in hw:1). For effects and sound output I then use  creox which is linux native, but not that great as it does not have default presets, you just have to tune everything manually.

- Install Guitar Rig or any other software using wine (this is the best option imho). You’wll also need wineasio which is a low latency sound driver for wine. To setup wineasio you can download the rpm (for ubuntu users you can convert to a deb using alien) install it and then run  regsrv32 wineasio.dll on your terminal and configure wine to use ALSA (using winecfg).

Now you can start jackd followed by your application, something like this:

jackd -p128 -dalsa -P hw:1 -C hw:1 -r44100 -p128 -n4 -s &
wine GuitarRig3.exe &

- The third option is to run the software using a virtualmachine, unfortunatly for me it does not work very well. My windows virtual machine running on virtualbox usually fits all my needs, but either with vmware and virtualbox i get huge latency playing my guitar.

If you still want to try it, just install the non-free (as in freedom) but still free (as in beer) version of virtualbox which you can download at their  homepage that comes with usb support, install your favorite guitar software and give it a try, please tell me if you had any success.

Another program that I recommend is tuxguitar (It is available in ubuntu repositories just like every other program i mentioned above) for both linux and windows (OSX and FreeBSD also supported). It is usefull to read tabs in the Guitar Pro format, there are tons of them.

ipw3945 driver on Ubuntu Hardy Heron

This works of course in other linux distros with minor changes. (kernell > 2.6.13)

I’ve been having some problems with the Intel 3945ABG wireless card, namedly in connecting in ad-hoc mode, so i found this site (thanks) which has a guide to blacklist the iwl3945 driver, and compile the ipw3945, my wireless card is now working with no issues. here’s a sum up of all the steps i took:

1. Download Microcode, Regulatory daemon, ipw3945 driver and this patch

2. Blacklist ipw3945:
edit /etc/modprobe.d/blacklist and add:
blacklist iwl3945

3. copy the microcode to /lib/firmware/2.6.24-21-generic/  (the kernel version changes of course, and you’ll have to repeat these steps if you upgrade to a new kernel).
ex:
sudo cp ipw3945.ucode LICENSE.ipw3945-ucode /lib/firmware/2.6.24-21-generic/

4. Copy the daemon files to /sbin
ex:  sudo cp ipw3945d-st* x86/ipw3945d /sbin

5. cd into the driver directory and apply the patch (apt-get install patch if you don’t have it installed)

ex: patch -p1 < ipw3945-1.2.2.patch (target file = ipw3945.h)

6. make SHELL=/bin/bash

7. sudo make install SHELL=/bin/bash

8. sudo chmod 777 /sbin/ipw*

9. create /etc/modprobe.d/ipw3945 and add:

install ipw3945 /sbin/modprobe -i ipw3945 ; sleep 0.5 ; /sbin/ipw3945d –quiet
remove ipw3945 /sbin/ipw3945d –kill ; /sbin/modprobe -r -i ipw3945

10. sudo modprobe ipw3945

Then just reboot and it should be working, if you want to rollback to the old driver just comment out the line in the blacklist file.