Installation/Demos

Classic Servoy
1
  1. Need a separate topic for those of us who are trying to install and get a Servoy demo up and running.

Specifically,

  1. It appears that Firebird is not installed on the MacOS X environment.
    So an external repository is required?
    And you can’t do anything wthout a repository server. Period.

  2. Installed the OpenBaseJDBS.jar in the drivers folder, and created an empty OpenBase database called “repository_server” with a user and password.

  3. Server Config:
    Server name: repository_server
    user name: bstaud
    Password: ******
    URL: jdbc:openbase:///repository_server
    Driver: com.openbase.jdbc.ObDriver

  4. File:Repository:Check Repository reports:
    Cannot find recent repository … create/upgrade?
    OK
    Cannot create repository
    java.sql.SQLException: SQL ERROR - [position 89, near " in
    "r_id int , PRIMARY KEY ( c’] create error: column name expected but
    not found.
    SQL: CREATE TABLE servoy_clients (client_id varchar(50) NOT
    NULL , IP varchar(50),user_id int , PRIMARY KEY ( client_id))

What Now, Coach?

Bill

2

It looks like openbase does not support the way Servoy creates primary keys. I’ll check with the dev team if there is anything we can do about it. Or maybe you can get Openbase to support this further widely accepted way of creating a primary key constraint on a table.

3

Could the External repository_server schema be applied manually?

In OpenBase I created the table thusly:
CREATE TABLE servoy_clients (client_id varchar(50) NOT
NULL , IP varchar(50),user_id int ) ;
CREATE PRIMARY KEY ( client_id) ;

However, Servoy still thinks it has to “create”, and finds a duplicate tablename.

Bill
[/code]

4

bstaud:
Specifically,

  1. It appears that Firebird is not installed on the MacOS X environment.
    So an external repository is required?
    And you can’t do anything wthout a repository server. Period.

Quoting Jan:
Did you restart your mac after installation? You have to restart as Firebird runs as a service. If you didnt restart you can restart now and then try the following: delete all databases from the datases directory EXCEPT empty.gdb delete servoy.properties in the main servoy folder.

Got things going for me.

  • david
5

Could the External repository_server schema be applied manually?

Currently not, it is very complex and has a lot of dependencies. The way Servoy applies primary keys is according to the SQL-92 standard that unfortunately openbase does not appear to support.

We are working on a library that will allow different syntax depending on the backend database being used. That still needs quite some work though so it will not appear in the upcoming 1.1 release but later. Untill then the easiest solution is to use Firebird for your repository, you can perfectly have your repository on Firebird and all your other data in Openbase. Once we support Openbase you can then move your repository to Openbase. The other unsupport option is to create a repository in Firebird and then move that entire schema to Openbase manually.

6

openbase does not appear to support.

Over the weekend (6/1/03) OpenBase implemented the
Servoy flavor of CREATE TABLE and CREATE INDEX,
and it works, so now I can continue evaluation of Servoy.

Bill

7

Excellent! That was a fast reaction from OpenBase!