Random Wits

Life is too short for a diary

Projects

$ latest projects
     ├── kerberos-oracle
├── k-largest
└── encrypted-files
view all

Random

$ random stuff
├── my bookshelf
    ├── resources
    └── quotes
    └── about me
say Hello

Back to Top

Posts Tagged “scala”

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 → jdbc scala oracle database