Description of problem:
hsqldb won't start

Version-Release number of selected component (if applicable):
hsqldb-1.8.0.4-4jpp.1

How reproducible:
Every time

Steps to Reproduce:
1./sbin/service hsqldb start
  
Actual results:
Required file is gone:  /var/run/hsqldb.pid
Failed to start org.hsqldb.Server.
See log file '/var/log/hsqldb.log'.

cat /var/log/hsqldb.log
This account is currently not available.

Expected results:
Success for instance 'db0-url'
org.hsqldb.Server started with pid XXXX

Additional info:
Running the following command:
rpm -q --scripts hsqldb

Produces the these results:
preinstall scriptlet (using /bin/sh):
# Add the "hsqldb" user and group
# we need a shell to be able to use su - later
/usr/sbin/groupadd -g 96 -f -r hsqldb 2> /dev/null || :
/usr/sbin/useradd -u 96 -g hsqldb -s /sbin/nologin \
    -d /var/lib/hsqldb -r hsqldb 2> /dev/null || :
--->8 SNIP 8<---

Notice the comment "# we need a shell to be able to use su - later".

/etc/rc.d/init.d/hsqldb partial contents:
--->8 SNIP 8<---
            # Some OSes choke if there are newlines in this string.
            # N.b.!!!  The shell of the -c command is the target user's default
            # login shell, so keep this command shell-independent!
            nohup su "$HSQLDB_OWNER" -c "cd '$SERVER_HOME' && echo "'$$'" >
'$PIDFILE' && exec '$JAVA_EXECUTABLE' $SERVER_JVMARGS $TLS_SWITCHES -classpath
'${SERVER_ADDL_CLASSPATH}${HSQLDB_JAR_PATH}' org.hsqldb.util.MainInvoker
org.hsqldb.$TARGET_CLASS $INVOC_ADDL_ARGS" >> "$LOGFILE" 2>&1 &
--->8 SNIP 8<---

/etc/rc.d/init.d/hsqldb is trying to "su" to an account with /sbin/nologin as
the "target user's default login shell".

Possible workaround:
/usr/sbin/usermod -s /bin/sh hsqldb