Sep 05, 2011  Sybase central crash when connecting via Remote. Extract or Generate ddl/schema from sybase ase 15.5. Rename transaction log. Noob question about Sybase service. Access to long varchars in SQL Central Debugger Watch List. Portable version of SA and MobiLink. DateXX.mlg (e.g. 140815AA.mlg) was created when run dbbackup with '-xo' option. Oct 23, 2015 - Named sql query using the sql-query maping element; 18.2. Although you can use whatever database you feel comfortable using, we will use. Hibernate uses slf4j for logging, for our purposes here use the simple backend. A central feature of Hibernate, proxies (lazy loading), depends upon the. We bought a software while back and initially it came with Sybase. According to that software vendor, we now have to pay them additional $200 per workstation (x16) license to upgrade Sysbase v12 to v17 in addition to their software upgrade. Sales man didn't know exactly how this works, but am i corr.

1. Sybase Online Editor
2. Sybase Log Segment Full

I can install and run Sybase Central v 4.3 on Windows XP without issues.

However, I am not so lucky when I use 64-bit Windows Server 2008 R2. It does install but it will not run. I tried running in compatibility mode (Win XP) but it did not work.

Anybody who solved this issue feel free to share your workaround.

Thank you!

EDIT: This command launches it:

EDIT: This describes the problem:

migrated from stackoverflow.comFeb 10 '10 at 3:56

This question came from our site for professional and enthusiast programmers.

3 Answers

We use a workaround: Execute with administrative rights and enable compatibilty with 'Windows Vista Service Pack 2'.

You can take a look at program link used to launch Sybase Central. Navigate to location and identify the batch script involving java application (Sybase Central is very old java application). Then go to cmd and use environment settings from script as example and launch javaw or java command to see what exactly fails.

The issue should not be Sybase specific, it most likely java 1.4 issue on Winx64 platform. It should be resolvable with googling the error messages you see in your cmd session.

You can change the theme as previously suggested (Windows classic seems to work for me) but it's a bit of a pain changing theme every time you want to run Sybase Central, or you can use W2K compatibility mode. I've seen some recommendations about changing the Java version by editing the scjview.bat file but my installation doesn't have that file just the scjview.exe

I've recently become responsible for administering an application which is essentially a front end to a Sybase SQL Anywhere 9 database, including the database itself. I'd like to use unload table to efficiently export the data for backup and, in the case of a few tables, ETL to get it into a reporting database / small scale data warehouse.

The problem is that the client application crashes and leaves dead connections and shared locks on a pretty regular basis, which seems to prevent unload table from getting the (brief) exclusive locks it needs. Currently I use Sybase Central to verify that these connections are in fact zombies and drop them myself at the end of the day / week.

Is there a command or script to drop all connections? Being able to drop everything at once after verifying that they're unneeded would be quite helpful but I haven't found a way to do it.

Bart De Vos

Sybase Online Editor

Sybase Log Segment Full

1 Answer

Gleening through the manual you might want to dbstop command. I think that will disconnect all users witht he -y option. You might also want to make sure your database and log file are synced. I got the impression that dbstop will do that, but I've never done anything like this before.

NixphoeNixphoe

Not the answer you're looking for? Browse other questions tagged sybasesqlanywhere or ask your own question.