I used OracleDataSource() to make connection and it worked. val ods = new OracleDataSource() ods.setUser(username) ods.setPassword(password) ods.setURL(url) val connection = ods.getConnection() connection.setAutoCommit(false) val prepUpdateStat = connection.prepareStatement(sqlUpdate) prepUpdateStat.execute() connection.commit() prepUpdateStat.close() ... View more