IT-eye

Although i still mostly use Oracle JDeveloper for my current projects, i’m interested in the other products on the market.
Lately i’m trying to get some extra knowledge on OpenESB, and for development i use Netbeans.

The development-tool got some good support from the community and a wide range of plugins are available.
Besides that a lot of good resources/tutorials are available.

See here for the patch-info.

Installation
Tools > Plugins > Updates
Select components and hit Update

CWE (Common Weaknesses Enumeration) has published a list with the 25 most programming errors.

The main goal for the Top 25 list is to stop vulnerabilities at the source by educating programmers on how to eliminate all-too-common mistakes before software is even shipped. The list will be a tool for education and awareness that will help programmers to prevent the kinds of vulnerabilities that plague the software industry. Software consumers could use the same list to help them to ask for more secure software. Finally, software managers and CIOs can use the Top 25 list as a measuring stick of progress in their efforts to secure their software.

Take a look at this list and learn from the mistakes made by co-workers.

I was having some strange problems with Spring MVC form input and UTF-8 charset.

In the Netherlands we are using a lot of Diacritic characters. To support those characters I want to use UTF-8. But with Spring MVC something seems to go wrong between the HTTP-request and the controller (in my case an AbstractWizardFormController).

When I was debugging with Firebug I saw that the Diacritic character was sent correctly to the server. But when debugging the controller the character é was changed to é.

The trick is, to use a CharacterEncodingFilter like this in your web.xml:

<filter>
  <filter-name>charsetFilter</filter-name>
  <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  <init-param>
   <param-name>encoding</param-name>
   <param-value>UTF-8</param-value>
  </init-param>
 </filter>
 <filter-mapping>
  <filter-name>charsetFilter</filter-name>
  <url-pattern>/*</url-pattern>
 </filter-mapping>

Recently I worked on a script to clean-up old application server back-ups. As you probably know, Oracle Application Server offers a script to perform a back-up of your configuration and to back-up a database if necessary. For the database back-up the script uses rman and with rman you can set a retention period. The script doesn’t offer the ability to set a retention period for your configuration back-ups of AS. Oracle wants you to remove it by hand. When you remove those file the catalog will not be cleaned. Well that is not that big of an issue, Oracle only displays the back-up files when they are available. But you want it to be tidy, no unnecessary data in the catalog files. With this in mind I wrote the following bash script.

The script ~/${oracle_env} only sets the oracle_home and oracle_sid and resets path, so all the oracle apps can be executed (like opmnctl, etc)

#!/bin/sh
#
#                       Cleanup script for old Oracle AS back-ups

#Help!
function help {
echo "usage `basename $0` -e "oracle_env" -r "retension PERIOD""
echo ""
echo "  -e Oracle environment which needs to be cleaned."
echo "  -r Retention period, in days.Default is 30 days."
exit 1
}

#Clean up after your self
function cleanup {
test -f $TEMP_CAT && rm $TEMP_CAT
test -f $TEMP_ONLINE && rm $TEMP_ONLINE
test -f $LOG_FILE && rm $LOG_FILE
}
trap cleanup 0 1 2 3 6

#Remove file
function remove_file {
FILE_DATE=`echo $1 | awk -F "_" '{print $3"_"$4}' | awk -F "." '{print $1}'`
if [ `check_backup_type $FILE_DATE online` == 0 ]; then
echo -e "n$1 removed"                  >> $LOG_FILE
rm $BCK_DIR/$1
fi
}

#Recreate  online catalog
function recreate_online_catalog {
FDATE=`echo $1 | awk -F "_" '{print $3"_"$4}' | awk -F "." '{print $1}'`
if [ `check_backup_type $FDATE online` == 0 ]; then
echo "$FDATE||backup_instance_online|" >> $TEMP_ONLINE
fi
}

#Recreate catalog
function recreate_catalog {
cat $CAT_FILE | grep -v "online" > $TEMP_CAT
cat $TEMP_ONLINE | sort | uniq >> $TEMP_CAT
}

#Check back-up type
function check_backup_type {
cat $CAT_FILE | grep -E "$1.+$2" > /dev/null 2>&1 ; echo $?
}

#Mail the log file
function mail_logfile {
mail -s "Clean backup files `hostname -a` - Environment: $oracle_env - `date "+%d-%m-%y"`"  $MAILADRES < $LOG_FILE
}

#MAIN SCRIPT
while getopts "e:r:h" options; do
case $options in
e) oracle_env=$OPTARG;;
r) retension=$OPTARG;;
h) help;;
*) help;;
esac
done

if [ -z ${oracle_env} ]; then
help
fi

if [ -z ${retension} ]; then
retension=30
fi

#Set Oracle Environment
. ~/${oracle_env} > /dev/null 2>&amp;1

HOST=`hostname`
BCK_DIR=/path_to_backup/$oracle_env
BCK_CAT_DIR=$ORACLE_HOME/backup_restore/data
CAT_FILE=$BCK_CAT_DIR/catalog.txt
BR_CAT_DIR=$BCK_DIR/br_catalog
BR_CAT_FILE=$BR_CAT_DIR/`ls $BR_CAT_DIR`
MAILADRES=email
LOG_FILE=/tmp/clean_log_$$.txt
TEMP_CAT=/tmp/temp_cat_$$.txt
TEMP_ONLINE=/tmp/temp_online_$$.txt

echo -e "Cleanup old back-ups `hostname -a` $oracle_envn"                              >> $LOG_FILE

#Check if there more then x online back-ups
BCK_COUNT=`cat $CAT_FILE | grep "online" | wc -l`
if [ $BCK_COUNT -lt $retension ]; then
echo -e "There are/is only $BCK_COUNT online back-up(s) leftn"                 >> $LOG_FILE
echo -e "!!!AANDACHT VEREIST!!!n"                                              >> $LOG_FILE
elif [ $BCK_COUNT == $retension ]; then
echo "Geen back-ups te verwijderen"                                     >> $LOG_FILE
else
find $BCK_DIR -name "*.jar" -mtime +${retension} -maxdepth 1 | awk -F "$BCK_DIR/" '{print $2}' | while read fname; do
remove_file $fname
done
ls $BCK_DIR | grep jar | while read file; do
recreate_online_catalog $file
done
recreate_catalog
cp $TEMP_CAT $BR_CAT_FILE
cp $TEMP_CAT $CAT_FILE
fi

echo -e "nCatalog filen"                                                              >> $LOG_FILE
cat $CAT_FILE                                                                           >> $LOG_FILE
echo -e "nCurrent back-up files.n"                                                    >> $LOG_FILE
ls -ltr $BCK_DIR                                                                        >> $LOG_FILE

mail_logfile

xxx

Enterprise Manager Grid Control offers the support for monitoring a Microsoft Internet Information Server 6.0 after installing the extension plug-in which can be found here.
In addition to the earlier post on why use the Exchange Server Plugin, this is a welcome add-on to monitoring for example your Outlook Web Access clients.
With the Microsoft IIS 6.0 plugin you are able to monitor your current connections together with any problem that might have occurred with the OWA service.

Here is an impression on what to expect

When using Qlikview Analyzer Java Client with Qlikview files which are built and used on a high resolution (for example 1920 by 1200). The application in the browser is shown in a smaller resolution so it doesn’t fill the whole screen which results in an ugly scrollbar. When using the Internet Explorer plugin everything looks fine but I prefer to have the freedom of choosing another browser. The following solution will fix the problem:

On your QVServer machine go to C:Program FilesQlikViewServerQvClientsQvJava and right click open in notepad the opendoc.htm and find the line html += ” width=’1000′ height=’700′>”; . This is where the browser height & width settings are set for the java client. you can change it to something like html += ” width=’99%’ height=’720′>”;