While working with an external vendor, we had a need to understand how to manage HTTP session cookies with python. This is simply how we did it… import urllib, urllib2, cookielib, re cj = cookielib.CookieJar() opener = urllib2.build_opener(urllib2.HTTPCookieProcessor(cj)) home =…
HBase Phoenix JDBC example
Phoenix is an apache project that attempts to provide an ANSI SQL standard interface to HBase data. This is just a quick implementation of it. Notice it has transactional semantics. Code below… import java.sql.*; import java.util.*; public class phoenixTest {…
Oracle database on NFS – Failure scenario testing
This post will provide a simple test case for the efficacy of creating and using an Oracle database cluster using NFS storage. The basic configuration will be shown, as well as the test case scenarios and results. A complete installation…
Does dropping a foreign key constraint drop the corresponding index?
No, you can safely drop a foreign key referential integrity constraint without affecting any underlying indexes. SQL> create table p(t number primary key); Table created. SQL> create table c(f number primary key, t number references p(t)); Table created. SQL> create…
JBOSS – total CPU time compared to total page response time
I thought this was interesting. By taking the total response time of pages from the access log, you can take the amount of server CPU used and compare it to the total elapsed request time. This works for web servers,…
ATG repository caching and the ServerLockManager
While somewhat ancient, I use what is below to crawl an EAR and find which repositories are configured to actually use the ServerLockManager in ATG. for f in $(find . -name “*.jar” -type f ); do for x in $(jar…