Groovy 1.5 ist out. It’s grooviest thing on earth. Far beyond the Grandfather of Funk himself, if you believe to the rumours and the ‘press’. Wow! It’s sooo groooovy and you really feel groovy if you’re elected to work with it.

I had some looks at groovy again and again since years. In theory it’s cool and I have many ideas where to use it. I developed some really groovy things in the past two weeks and I wanted to report about them here. But I only feel groovy when thinking about groovy. In theory.

Pratically I hate groovy, because I spend to much time on it, trying to run stupid unit tests in eclipse. The Eclipse Groovy plugin is shockingly terrible. At least it does not even compile my Groovy classes. Argh! Renaming a package which is used in a Groovy class crashes the whole IDE. Much wasted time.

Yes, groovy could be groovy, if there were a reasenable tooling we can use. (I have to stick with Eclipse.)

I hope I can report something positive soon.

Our blogroll took a little refresh. I moved out some links, where nothing happened for a longer time and introduced a new link to our workmate and Spring Framework Guru Nils Wloka. He’s running the little Spring related blog “Springify”.

I think there is some work left to do about our blogroll.

No, that is not a joke! An empty ORACLE 10g database has 3644 views. There are 49441 objects at all in an empty database. Crazy.

Sorry, I could not get around. I had to post this.

(via Ted Newards Blog Ride)

We tried to deploy an application to a customer’s test system yesterday and needed to clean up the full database. We agreed before that they have to delete the schema and the user with all table etc. but they missed to notify their ORACLE adminstrators. We had only the permissions to work in, but not with the schema. So how to drop a few hundred tables?

DROP TABLE * CASCADE CONSTRAINTS!?

No. No such statement is possible. The solution of my workmate was a little funny:

1. Open ORACLE SQL Developer and connect to the database / schema.


2. Mark all tables to delete.


3. Choose “edit / copy full path” from the applications menu.


4. Paste the stuff into the script editor. You get something like “TABLE MySchema.MyTable@MyDb”.


5. Open Search/replace and replace “TABLE MySchema” with “DROP TABLE MySchema”.


6. Replace also “@MyDb” with “ CASCADE CONSTRAINTS;”.


7. Run the script.