Handling Oracle cursors in JDBC

Summary It is common practice for Oracle stored procedure to pass cursors to calling client. The client then needs to guarantee that the cursors are handled and closed properly, otherwise overtime the open cursor will accumulate into an ORA-1000 error (“ORA-1000 Maximum Number of Cursors Exceeded”) In Java world, cursor translates as ResultSet. In the…

Nokia n900

Just got myself a new phone, Nokia N900 – this notes will contain a review of the phone, as well as the  setup & tinkering I’ve done with this phone. Overview After trying this for about 2 weeks now, I understand why they say that the N900 is not a smartphone. It is really more…

Test post via my n900

This is a test post using my nokia n900, let’s see how we go :p this is a very good way of capturing notes on the go. This is done through an application called MaStory. Seriously, is there anything this phone can’t do!? Btw I am gathering notes on n900 configuration. It will be one…

Sun Tzu – Chapter 2 – Waging War

2. Waging War Execution War is not cheap – plan the operation well and do it swiftly. As Eisenhower says: “I have always found that plans are useless, but planning is indispensable.” – Dwight D. Eisenhower. The most important thing is to carry it out in a sustainable manner – maintain both the micro perspective…

Debugging a remote java application with Eclipse

You can remotely debug a java application by first starting it like below.

Then, any decent IDE (such as Eclipse) with facility to remote debug a java application will be able to attach into the running process under the specified port (in this case, 8888). in Eclipse: Run > debug configurations > remote java…