SQL "is equal to", <>, and NULL

Time for a complaint about how SQL deals with NULLs. CREATE TABLE colas ( brand VARCHAR(32) ); INSERT INTO colas ( 'Pepsi' ); INSERT INTO colas VALUES ( 'Coke' ); SELECT * FROM colas WHERE brand <> NULL; The above select statement does not return { 'Pepsi', 'Coke' }. Instead, it returns 0 rows. This is because I should…

Checked and unchecked exceptions in EJBs

EJBs are good. But here's something lame: Throwing an unchecked exception (ie. RuntimeException) causes the current transaction to be rolled back. Throwing a checked exception (ie. a declared exception) does not roll back the current transaction. I never throw any exception from my code that does not require a roll…

Shiny! Drawing XP icons

Today I tried for a few hours to get Xandros to burn some DVDs on my new burner. It was grumpy so after two DVD-coasters I threw in the towel and installed Windows XP. It's a decent alternative to Linux but it has a crappy shell and its SMB client…

Hello, World

I've been thinking of starting a tech-focused weblog for a long time now. Well, consider this "Hello. World". My intention is to talk about Glazed Lists stuff mostly here, and perhaps some other Java stuff. Personal rants will continue to be on swank.ca.…