web analytics

Data, data everywhere 

Twitter LinkedIn RSS
magnify
Home Articles posted by Glenn Paulley
formats

Using the debugger in Oracle 12c SQL Developer

One of the significant features of Oracle’s SQL Developer client is the built-in debugger for PL/SQL stored objects: PL/SQL stored procedures, stored functions, and triggers. In this tutorial we describe how to use the SQL Developer 4.1.0 debugger with an Oracle 12.0.1 server. Setting up the correct permissions and authorizations so that development staff can

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

Java EE development: the PermGen error

When developing a tiered Java EE database application there are a tremendous number of program errors that will only be discovered at runtime. If one is using Hibernate as the Object-relational mapping tool, even JPQL queries embedded within your Java application will (likely) pass Java compilation because the syntax and semantics of the JPQL query

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

Teaching critical thinking skills through visual analytics

One way or another – either by being a university student, an industry practitioner, an industrial researcher, and now as an instructor – I’ve been doing “Computer Science” since 1978. Over the past 37 years I have worked with a variety of different hardware and software technologies, and at least a score of different programming

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

Performance overhead of SQL user-defined functions

Some time ago I wrote an article that described the performance tradeoffs one encounters when using SQL user-defined functions – sometimes called UDFs or PSM (Persistent Stored Module) functions – from within an SQL query. In that article, I wrote: A recent email exchange with software consultant Breck Carter regarding the performance of user-defined functions

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

Book review: Software Architecture in Practice, 3rd edition

If you are looking for a single volume to explain software architecture, then I would recommend Software Architecture in Practice [1] by Bass, Clements, and Kazman. Software Architecture in Practice provides a comprehensive, superb, and highly readable overview of the software engineering practices termed “software architecture”, which include the design, analysis, documentation, and implementation of

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
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

What exactly is thread deadlock?

Performance testing is a key component of system testing, since a non-performant application is often viewed as just as poor as an application that contains other varieties of defects. Care and attention are required to ensure that even simple processes will not cause contention in a production environment – and sometimes these issues are difficult

 
 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