How to get information on UNIQUE keys on Apache Derby

It’s not easy to get information on derby keys once you created them. I was looking for a command like “SHOW CREATE TABLE ” but no luck. I realized that the answer should lay in SYS tables. After googling a while I found the following bit of wisdom: The following query will give you the UNIQUE constraints on a table: select c.constraintname, c.constraintid from sys.systables t, sys.sysconstraints c where t.tablename = ‘FOO’ and t.tableid = c.tableid and c.type = ‘U’; ...

October 16, 2007

Inspecting Tomcat HTTPS connection with Wireshark

Wireshark allows you to inspect SSL connection as long as you have the corresponding private key of the server side. You can read the details here. But if you are using java and tomcat you’ll probably have the certificate and private key stored in a JKS keystore so how can you extract the key in the right format for WireShark? First of all, keytool doesn’t allow you to extract the private key from a keystore. So you need external help. I use the DumpPrivateKey.java which is a modified version on the DumpPrivateKey found in this forum post. ...

June 29, 2007

How to enable Windows key as Super key in linux

I’ve you tried beryl or compiz you probably had notice that the Super key (the windows key, also known as Meta key) is used a lot. By default in my Fedora Core 6 installation the Windows key is not enabled, I had to add Option "XkbOptions" "altwin:super_win" to the InputDevice section of my /etc/X11/xorg.conf to activate it. This is how the InputDevice section look like now: ... Section "InputDevice" Identifier "Keyboard0" Driver "kbd" Option "XkbModel" "pc105" Option "XkbLayout" "es" Option "XkbOptions" "altwin:super_win" EndSection ... via Noiesmo’s GNU/Linux Site

January 9, 2007