Installation/Demos

Questions and answers for all installation-related topics for Servoy products

Installation/Demos

Postby bstaud » Sat May 31, 2003 3:09 am

0. 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://<IP>/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
bstaud
 
Posts: 6
Joined: Sat May 31, 2003 2:24 am
Location: Grass Valley, CA

Postby Jan Aleman » Sat May 31, 2003 12:54 pm

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.
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

Postby Guest » Sat May 31, 2003 4:12 pm

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]
Guest
 

Re: Installation/Demos

Postby david » Mon Jun 02, 2003 9:48 pm

bstaud wrote: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
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Postby Jan Aleman » Mon Jun 02, 2003 10:02 pm

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.
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

Servoy Versus OpenBase SQL

Postby bstaud » Tue Jun 03, 2003 8:52 pm

>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
bstaud
 
Posts: 6
Joined: Sat May 31, 2003 2:24 am
Location: Grass Valley, CA

Postby Jan Aleman » Tue Jun 03, 2003 10:50 pm

Excellent! That was a fast reaction from OpenBase!
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth


Return to Installation

Who is online

Users browsing this forum: No registered users and 3 guests