Random Wits

Life is too short for a diary

$ random wits
├── tags

├── bookshelf

├── resources

├── quotes

├── habits

└── about





Fri 20 Mar 2020

Connecting to Oracle database form Scala using JDBC for large data

I was looking to write a scala script to fetch large data from Oracle database. I was earlier using the Alteryx software to fetch data (around 1 million rows) from oracle which took around 7 minutes. Licensed softwares like Alteryx or Informatica, etc are great, but I was looking for a free solution.

We need ojdbc6.jar to connect to the Oracle 12 c database. We will create a Scala script to fetch data from the oracle database & save it to the output file (CSV format)...

Continue reading → Tags : jdbc scala oracle database




Sun 08 Mar 2020

Sleeping At Night

It feels great to sleep at night. I have a small but a cozy room. It’s not lavish or splending. It doesn’t even hoard much furniture. However it’s as peaceful as it can get.

I wonder about those unfortunate people who couldn’t sleep at night. Some of them are stuck in war-torn countries. Around 150 million people are homeless in the world. Astonishing 1.6 billion people don’t have proper housing. That’s 20 percent of the entire human population...

Continue reading → Tags : sleep rambling human rights




Fri 10 Jan 2020

Connect to an Oracle Database using kerberos with python

Jobs failed! Screamed an automatic failure alert in email inbox. Existing python scripts were failing in the server which fetched data from Oracle database. I wondered if the credentials had changed.

After few emails back and forth with the Support team, I discoverd that the server had been upgraded with Kerberos authentication. I have to modify my scripts to support kerberos authentication. I have to dig up more to understand more about kerberos...

Continue reading → Tags : kerberos projects python docker oracle database