web analytics

Data, data everywhere 

Twitter LinkedIn RSS
magnify
Home Posts tagged "Oracle"
formats

Configuring Transparent Data Encryption (TDE) with Oracle 12c

I am currently building a Java EE 7 application that will utilize an Oracle 12c database for persistent storage. Because some of the data is sensitive, I decided to enable Oracle’s Transparent Data Encryption (TDE) feature, so that I could encrypt particular columns to guard against disclosure of this sensitive data either through the theft

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Configuring SonarQube with Oracle 12c

For a while now I’ve wanted to install SonarQube for doing static analysis of my Java EE 7 applications. The current downloadable version of SonarQube is 5.1.1. The SonarQube requirements documentation indicates that SonarQube supports the following RDBMS for its repository: Microsoft SQL Server 2008 and 2012; Oracle 10g and 11g; MySQL 5.1, 5.5, 5.6,

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
6 Comments  comments 
formats

Configuration of Oracle 12c – part deux

In this second article regarding the installation and configuration of Oracle 12c, I’ll discuss the server’s memory configuration and the settings chosen for the default installation. Again, I’m working with Oracle 12c Enterprise Edition Release 12.1.0.1.0 – 64-bit on Windows 7. Like many, I accepted all of the default configuration options when installing Oracle 12c

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Configuration of Oracle 12c – part un

Oracle 12c represents a fairly dramatic departure from Oracle 11g in terms of setup and configuration of the server on personal workstations. The 12c release was released in 2013, but I had delayed its adoption due primarily to a lack of available reference texts. With that issue now rectified, it’s time to “take the plunge”

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Why the SQL Standard does not need another way to do GROUP BY

In a recent article, Lukas Eder proposed enhancements to the SQL Standard’s GROUP BY syntax to include support for implicit grouping attributes, such as that provided by the Cypher query language. I applaud Lukas’ efforts to define useful changes to the SQL language, but I am going to try to show in this article that

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
3 Comments  comments 
formats

Software for PROG3060 – Java Enterprise Applications

Students taking PROG3060 in the Winter 2015 semester may wish to install all of the various software components required for the course on their own machines. So, in anticipation of student requests for that list of components and how to configure them, here goes. We will be utilizing: Java JDK 1.7.0 r71, 32-bit edition; Eclipse

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Looking for the Eclipse Web Tools Platform? Start here.

Published on August 15, 2013 by in Java

My Java Enterprise Applications course utilizes Eclipse as the development IDE, together with the Web Tools Platform, which includes Glassfish as the Java application server. Persistent storage for applications (ie, database) is the Apache Derby system, which integrates well with the SQL Scrapbook plugin that is part of the Web Tools Platform. The version of

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Resource materials for Oracle PL/SQL programming

The Database: Application Programming course (PROG3040) offered to 3rd year CP/A students at Conestoga will be updated this fall semester in two significant ways: Server and client software will be upgraded from Oracle® 10g to Oracle® 11gR2; and Students will be exposed to MongoDB, a popular “NoSQL” system that features a schema-less, JSON data store

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments