Random Wits

Life is too short for a diary

Random

$ random stuff
    ├── tags
    ├── bookshelf
    ├── resources
    ├── quotes
    ├── habits
    └── 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