weblog; a miraculous build

Maven

Developing Web services using Apache CXF and Maven

http://www.ctrl-alt-dev.nl/Articles/CXF-Maven/CXF-Maven.html

Step-by-step instructions on how to develop a web service using CXF and Maven. Starts off by creating a web service without CXF, adds tests and then replaces non-test code with code generated by CXF. Should be a worth while walkthrough.

Oracle

WadeLiu Blog On Oracle: query and kill oracle connection session

• http://focusoracle.blogspot.com/2008/04/query-and-kill-oracle-connection.html
• http://www.oracle-base.com/articles/misc/killing-oracle-sessions.php

My tests failed initially due to the fact I had not added new trusted certificate entries into the existing client certificate. This happened repeatedly and must have used up all the connections in the database pool. They were eventually released, but I tried to see if I could hurry that cleanup along.

I had permissions to execute the first two lines, but not the last one.

SQL> SELECT s.sid, s.serial#, s.osuser, s.program FROM v$session s; 

SQL> select sid from v$session where audsid= userenv('SESSIONID'); 

SQL> ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;