TroyGeek

Connecting to LDAP/Active Directory using JNDI (Java)

Learn how to connect and search LDAP or Active Directory (Microsoft's LDAP Implementation) using Java's JNDI API.

My Article in SysAdmin Magazine!

I have an article coming up in SysAdmin magazine that focuses on using Oracle Statspack to monitor and report on Oracle database performance.

Lean Software Development - An Agile Toolkit

Recommended Book: Lean Software Development describes some of the ways you can take the lean principles of the manufacturing world and apply them to the field software development.

OpenSuse 10.2 Screenshots

Various screenshots from the aesthetically appealing OpenSuse 10.2 Linux Desktop.

Copying and Pasting Java Code in RAD Loses Your Formatting

Have you tried copying your java code from Rational Application Developer (RAD) to another application and found that your code loses its formatting? This article explains why.

Using SQLPLUS, Import, and Export Without a Password

Storing passwords in plain text in your shell scripts can be a bad practice. If you need to run an export or import from a script and do not want to store your password in the script, you can perform the import/export as SYSDBA. As long as you're in the dba/oradba group and can log into Oracle as SYSDBA without a password you can perform your imports and exports without a password as well.

Dropping Your Default Oracle Temporary Tablespace

Dropping your default oracle temporary tablespace can be tricky. You cannot simply issue a drop tablespace command because oracle does not allow it. This article will cover the steps needed to drop and recreate your default temporary tablespace.

A Look at Oracle's Project Raptor

Oracle has released a new graphical tool called "Project Raptor". It's like Oracle's Enterpise Manager, but it is geared more towards an application developer than a DBA. WIth this tool you can create objects, select and modify data, and much more. Best of all, it's free!

Statspack 101: Interpreting Your Statspack Report

In my last article, I discussed how to install Oracle's Statspack Utility; a free tool for monitoring your Oracle database instance. That article also discussed how to generate a Statspack Report. This article will help you interpret a lot of the information you will find in a statspack report.

Statspack 101: Installing Oracle's Statspack Utility

Oracle's Statspack is a free utility that allows you to monitor and report on performance problems with your Oracle database. In this tutorial we will install Statspack on an Oracle 9i database though it should work similarly with other versions of Oracle.

How Oracle Searches for Configuration Files

Do you have trouble finding which tnsnames.ora or listener.ora is the one on your computer that Oracle is actually looking at? There's a few places that Oracle looks for its configuration files (tnsnames.ora, sqlnet.ora, listener.ora, and oratab).

Working with XML data in an Oracle Database: Part 1

Is your application using XML to store data? With Oracle 9i and above you can store your XML in the database and query it to pull out the pieces of data that you need.

Searching for Files in UNIX and Linux

This article explains how to use the 'find' command to search for files, files that contain certain strings, large files, files that changed within the last day as well as taking a look at the 'locate' command.

Extracting Oracle DDL from a SQL Command Line

Need to extract DDL from a table in an Oracle database but don't have a tool to do so? Don't fret, you can query Oracle's Metadata API to retrieve the DDL or even XML on the given object. This works with oracle 9i and above.

Importing and Exporting data in MySQL

Have you ever needed to export data from a MySQL database to back it up or recreate a database on a separate computer? The mysqldump utility will allow you export the entire database and the mysql utility will let you load it back in.

Changing the Default Workspace in WSAD on Windows

Have you ever clicked that 'Use this workspace as the default and do not show this dialog box again' checkbox in IBM's WSAD (Websphere Studio Application Developer) and then was unable to get the prompt back to change to a different workspace? Well here's a solution.

Editing Your Oracle spfile

If you use a spfile instead of a pfile in Oracle you may have noticed that your spfile.ora file is a binary file. Here is one method to create a pfile from your spfile, modify your pfile to make changes, and then create a new spfile from that pfile.

Using Connection Pooling in Apache Tomcat

Creating physical database connections within your JSP and Servlets is a resource intensive task. Using a connection pool is much more effective and faster for your web application. This article will detail how to use Apache Common's DBCP utility that comes with Tomcat to set up connection pooling within your web application.

Installing Eclipse and Tomcat Together on Windows

Ever want to use Eclipse to write your JSP code in Tomcat? In this article you will learn how to install Eclipse, Tomcat, and how to configure the sysdeo plugin with eclipse so that you can start, stop, and restart Tomcat within Eclipse.