How to deploy AnySQL in Unix/Linux host?

    AnySQL was wrote in Java language, so it could be run in Unix/Linux, the downloaded file is for Windows, but you can move it to Unix/Linux by the following steps (first you need to install JRE 1.4 or above version, else you cannot run it):

1, Where to install it? For example: /usr/AnySQL.
2, Make a sub directory "jlib", For example: /usr/AnySQL/jlib.
3, Copy oasql.jar and oracle.jar to jlib directory, For example: /usr/AnySQL/jlib
4, Create a shell file named with "asql" to start AnySQL.
5, Put the directory to PATH variable, you can just type asql to start AnySQL.

    The shell file "asql" to start AnySQL could be (What I am currently using):

#!/bin/sh

ASQL_CMD=`which $0`
ASQL_HOME=`dirname $ASQL_CMD`
$JAVA_HOME/bin/java -server -Xms8m -Xmx16m \
    -cp $ASQL_HOME/jlib/oasql.jar com.asql.tools.ASQL $*

    No Oracle client required, and you could run it in character mode. Welcome to deploy it under Unix/Linux.

Post a comment

SCode:
Mail(*, but will not be displayed):
Home: