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.

I need a dynamic two dimensional array in Java. I thought I might not be the only one, so I searched with regular search engines and the code searches. Surprisingly I did not find any free implementation. I thought this would be a such common case, that the JRE or at least the Jakarta Commons Collections might contain it. No, they do not.

It seems the rest of the world builds their own implementation or uses the javax.swing.table.TableModel and javax.swing.table.DefaultTableModel. The public API of the latter gets near to what I want, but it’s not exactly what I was looking for.

I thought about something like this:

interface TwoDimensionalArray<T>

{

  T set(int x, int y, T value);

  boolean add(int x, int y, T value);

  T get(int x, int y);

  Iterator<Iterable<T>> iterator();

  boolean isEmpty();

  /** returning the overall element count */

  int size();

}