Sybase SQL Anywhere and Servoy 6.1

Classic Servoy
1

We are still on Sybase SQL Anywhere 9, and need to upgrade ( it appears Value Lists don’t work properly )

Which Sybase version is recommended for Servoy 6.1 ?

greg

2

Hi Greg,

I guess the proper answer to this is:
Pretty much any version of any relational database server with a proper JDBC driver will work with any version of Servoy.

So there is not so much a recommendation to use a specific version with Servoy 6.1 other than you might want to use a version you have support on from the database vendor.

So what issue(s) do you see with your value-lists?

3

Actually, that’s never been true. When we started in Servoy 3, Sybase 5 didn’t work properly

I did file a case for the value list, and they found it not repeatable.

For some reason when I sort a value list, it shows all rows. If I remove the sort, it is distinct again ( but not sorted ). It works in Servoy 3.1.

I can only guess it is due to Sybase 9. I even sent in a small test file

It’s time for an upgrade anyway …

greg

Pretty much any version of any relational database server with a proper JDBC driver will work with any version of Servoy.

So what issue(s) do you see with your value-lists?

4

Well I did say ‘pretty much any’ and stated the condition of a proper JDBC driver ;)

Anyway, are you perhaps doing to the sort over a relation ? If so is this an inner-join or an outer-join relation?

5

Hi Greg,

gdurniak:
We are still on Sybase SQL Anywhere 9, and need to upgrade ( it appears Value Lists don’t work properly )

Which Sybase version is recommended for Servoy 6.1 ?

greg

I have a client currently running Sybase SQL Anywhere 12 with Servoy 5.2.x & they are testing with Servoy 7.0 (& I had done some minimal testing with 6.1).
Seems to be ok, but might get more feedback on Wednesday when I am next there.
Try and make sure you are using the latest Sybase JDBC driver from their support/download site.
Rafi

6

I seems that Sybase 9 uses JDBC 2.0

http://iablog.sybase.com/hinsperg/?p=333

and it appears Servoy requires JDBC 3.0 and higher

http://wiki.servoy.com/display/SERV61/D … onnections

Surprised that Tech Support didn’t mention that …

greg

7

Are these server options still appropriate for Sybase 10 and higher ( for the repository ) ?

start dbsrv10

-n repository_server

Database server name

-ti 0

Disconnect connections that haven’t submitted a request for the specified number of minutes. The default is 240 (4 hours). The maximum value is 32767. The -ti option is provided to disconnect inactive connections, freeing their locks.

Setting the value to zero disables checking of inactive connections, so that no connections are disconnected.

-x tcpip{dobroadcast=no}

specify which communications protocols, in addition to shared memory, you want to use to listen for client connection broadcasts.

Server usage: Setting DoBroadcast=NO prevents the database server from broadcasting to find other servers with the same name when starting up. This is useful in certain rare circumstances, but it is not generally recommended.

-qs

suppresses startup error dialogs

-qw

suppresses the Server Messages window (Windows platforms) and also suppresses messages on the console (non-Windows platforms).

-o “D:\servoy 6 databases\sybase_log.txt”

Print all Server Messages window output to the specified console log, as well as to the Server Messages window