Ali Imtiaz aimtiaz11

Converting .pfx key to Java Keystore

Ensure Java and Keytool is setup in the machine prior to running it.

keytool -importkeystore -srckeystore mypfxfile.pfx -srcstoretype pkcs12 -destkeystore clientcert.jks -deststoretype JKS

Using Curl

Only Get Status Code of API Call

curl -s -o /dev/null -I -w "%{http_code}" http://example:8009/contextPath/

Changing/Switching Java Versions in Mac OSX

Often you may need to switch to different version of Java if you have multiple Java installed in your Mac.

Find where Java 7 is installed:

AIs-MBP:~ ai$ /usr/libexec/java_home -v 1.7 

/Library/Java/JavaVirtualMachines/jdk1.7.0_79.jdk/Contents/Home

How to Install WAR file to Tomcat

Update ~/.m2/settings.xml

<settings>
 <servers>
  <server>
   <id>dev-tomcat</id>
   <username>tomcat</username>
 password

NodeJS create fake user data using Faker

Create server.js file as below:

Install Faker: npm install faker

Content of server.js:

var express = require('express');

Setting up Grunt in your project

Run npm init in your project root folder
Setup grunt locally: sudo npm install grunt --save-dev
Create a Gruntfile.js

Upgrade and switch JDK versions in Linux

Instructions on how to install/upgrade or switch versions of Java in RHEL/Fedora Linux distros.

Search using yum: yum search java | grep 'java-'

java-1.8.0-openjdk.x86_64 : OpenJDK Runtime Environment
java-1.8.0-openjdk-demo.x86_64 : OpenJDK Demos
java-1.8.0-openjdk-devel.x86_64 : OpenJDK Development Environment
java-1.8.0-openjdk-headless.x86_64 : OpenJDK Runtime Environment

Adding local npm package executables to $PATH

Modify PATH variable as below after installing node.

export PATH=${PATH}:$(npm bin)

Installing local packages

After doing so you can now install and use packages locally. For example to setup grunt run:

Using imp/exp

Import

imp schema_name/schema_password FROMUSER=schema_name TOUSER=schema_name IGNORE=Y FILE=EXP_SCHEMA_NAME_SCHEMA.DMP LOG=IMPORT_LOG_FILE.log

Export

	DROP TABLE ADT_SOURCES_EXT;

	create table ADT_SOURCES_EXT
	(

	FIRST_NAME VARCHAR2(30),
	LAST_NAME VARCHAR2(30),
	MIDDLE_INITIAL VARCHAR2(1),
	POSTAL_CODE NUMBER,
	LATITUDE NUMBER,