How do you start Sybase Central under Linux?

Classic Servoy
1

Hi all,

I have only just started using a Sybase repository and database for a new solution, as there’s a possibility that I’ll want to create a runtime version of this solution, and the Servoy docs say that I have to be using Sybase to do this (I’ve been using PostgreSQL 'til now). Now I have a problem – I have set up a database using the dbinit command in the Servoy docs, but now I need to run Sybase Central to alter some other things in the database.

The problem is, I can’t figure out how to run Sybase Central under Linux!

I am sure I’m missing something obvious here, but I just can’t get it to work. I have been trying:

java -jar sybcentral43.jar

whilst inside the correct directory (I have installed Sybase iAnywhere to my home dir), and I get the following output:

lee@hex:~/sybase/shared/sybcentral43$ /home/lee/sybase/jre142/bin/java -jar sybasecentral.jar 
Exception in thread "main" java.lang.NoClassDefFoundError: com/sybase/util/ExceptionHandlerClient
        at java.lang.ClassLoader.defineClass0(Native Method)
        at java.lang.ClassLoader.defineClass(Unknown Source)
        at java.security.SecureClassLoader.defineClass(Unknown Source)
        at java.net.URLClassLoader.defineClass(Unknown Source)
        at java.net.URLClassLoader.access$100(Unknown Source)
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClassInternal(Unknown Source)

I’ve tried setting up the environment as per http://www.ianywhere.com/downloads/whit … slinux.pdf but it still gives that error! I have also tried:

export CLASSPATH=/home/lee/sybase/java/asaplugin.jar:/home/lee/sybase/java/isql.jar:/home/lee/sybase/java/asa.jar:/home/lee/sybase/java/xerces.jar:/home/lee/sybase/java/xml4j.jar:/home/lee/sybase/java/jlong.jar:/home/lee/sybase/java/debugger.jar:/home/lee/sybase/java/jlogon.jar:/home/lee/sybase/java/jodbc.jar:/home/lee/sybase/shared/java/JComponents142.jar:/home/lee/sybase/shared/jConnect-5_5/classes/jconn2.jar

I am out of ideas.

Any suggestions?

Thanks,
lee

2

Turns out that despite extensive googling and RTFMing I was still doing things completely wrong.

Sybase Central is now working, hurrah.

This article is quite handy, although for some reason I had to start it as follows:

lee@hex:~/sybase/bin$ LD_LIBRARY_PATH="/home/lee/sybase/jre142/lib/i386/client:/home/lee/sybase/jre142/lib/i386:/home/lee/sybase/jre142/lib/i386/native_threads:/home/lee/sybase/drivers/lib:/home/lee/sybase/lib:$LD_LIBRARY_PATH" ../shared/sybcentral43/scjview

or alternatively,

lee@hex:~/sybase/bin$ LD_LIBRARY_PATH="/home/lee/sybase/jre142/lib/i386/client:/home/lee/sybase/jre142/lib/i386:/home/lee/sybase/jre142/lib/i386/native_threads:/home/lee/sybase/drivers/lib:/home/lee/sybase/lib:$LD_LIBRARY_PATH" 
lee@hex:~/sybase/bin$ export LD_LIBRARY_PATH
lee@hex:~/sybase/bin$ ../shared/sybcentral43/scjview

as asa_config.sh wasn’t doing this, for reasons unknown.

3

Future reference for myself, the easiest way to get it to run , as of Sybase SQL Anywhere Studio 9.0.1, is:

sh ~sybase/bin/asa_config.sh
~sybase/shared/sybcentral143/scjview