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…

Details

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…

Details

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…

Details

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…

Details