• Resolving NoClassDefFoundError Errors in WebSphere ear Files

    by  • January 9, 2012 • 0 Comments

    In some odd cases, the ear file that you have deployed to WebSphere may at some point throw a java.lang.NoClassDefFoundError runtime error even though you are certain that the ear file contains all the proper jar files and they are located in all the right places. For instance: java.lang.NoClassDefFoundError: org.apache.woden.resolver.URIResolver This problem may be...

    Read more →

    Use Global properties Files in WebSphere

    by  • January 9, 2012 • 0 Comments

    There are certain cases where you need to use a properties file (ResourceBundle) that can be used in one or more WebSphere Enterprise Applications. One example would be to allow the Application Manager to manage and control properties such as database passwords or other sensitive information that should not come bundled inside various ear/war/jar...

    Read more →

    Where are the Crystal Reports Service Packs?

    by  • December 22, 2011 • 0 Comments

    Although it has improved over time, navigating through the SAP site can be a bit frustrating if you’re trying to find specific Crystal Reports related information. If you’re looking to download Crystal Reports Service Packs, Hot Fixes, Utilities, Sample Reports and Sample Applications, follow this link: http://www.sdn.sap.com/irj/boc/downloads. You can also get there by going...

    Read more →

    Use Local .rpt Files in Crystal Reports Java API

    by  • December 21, 2011 • 0 Comments

    Assume your Java application is using Crystal Reports from the Repository Server and for whatever reason, for instance testing or debugging, you want to use a local copy of the Crystal Report .rpt file in your project, and not the one from the CR Server. Your original code may look similar to this: And...

    Read more →

    Concatenate Strings from a Column Into a Single Row

    by  • December 20, 2011 • 0 Comments

    Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a solution with the GROUP_CONCAT() aggregate function, such as SQLite and MySQL. In DB2 you can use the XMLAGG() function to aggregate the strings from different rows into a single XML string, and then transform...

    Read more →

    Count Word Occurrences in Oracle String

    by  • November 17, 2011 • 0 Comments

    As of Oracle 11 you can use the REGEXP_COUNT function to count the number of occurrences of a word or string in a varchar. However, if you’re using Oracle 10 you may be able to achieve something similar as shown below. In this example we count how many times the word ‘two’ appears in...

    Read more →

    Automate Tomcat startup/shutdown on Linux

    by  • November 9, 2011 • 0 Comments

    If you need to automatically start/stop Tomcat each time you start/stop/reboot your Linux server, you can do so by creating a start/stop script under the /etc/init.d directory. The sample script below is called /etc/init.d/tomcat and runs Tomcat as a user called “tomcat” – because most likely you do not want Tomcat to run as...

    Read more →

    Use Static IP on Ubuntu Server

    by  • November 9, 2011 • 0 Comments

    By default, Ubuntu uses DHCP in order to get an IP address. If you need a static IP instead, you need to update your interface configuration. This is done in file /etc/network/interfaces By default, the contents of this file will probably look similar to this: Most likely, your main interface will be eth0 (or...

    Read more →

    File and Partition Recovery in Linux

    by  • November 8, 2011 • 0 Comments

    If you need to recover files and/or partitions on Linux, TestDisk and PhotoRec may be useful. Both are very powerful and free tools that run on Linux and may also work if you need to recover data from USB Hard Drives, USB Memory Drives, Memory Cards, CD-ROMS, iPod, etc. Despite its name “PhotoRec”, this...

    Read more →

    Mount a USB Hard Drive to Ubuntu Server

    by  • November 8, 2011 • 0 Comments

    Unlike on the Ubuntu Desktop edition, USB devices are not automatically mounted on Ubuntu Server. You will have to do it manually. Luckily it’s quite simple. First, you need to find out which device needs to be mounted: sudo fdisk -l Most likely, your USB Hard Drive will be /dev/sdb1. Now we create a...

    Read more →