The repository_server WAS available and working
until I installed Servoy 1.2
I did put the OpenBase driver jar into the drivers folder.
The Server config was not changed.
Now the repository_server cannot be found.
What Now?
Servoy 1.2, OpenBase 8.0 OS X 10.3
DIAGNOSTIC PROCESS:
DO UNTIL (you give up?)
BEGIN
…ServoyDeveloper : Preferences :
…Tab: DBServers
…Doubleclick: repository_server
…Examine Server Config
…Maybe do trial and error in case something has changed
ASIDE: I believe this window should have a means for
verifying that the connection is available (or not) right then.
But nooooo, you have to
…Click OK
…Click OK
…Restart Servoy, and see the message
…"Cannot find recent repository (version) on current server connection, do you want to create/upgrade?
ASIDE: The Cancel button is the safer option and should be the default.
ASIDE: At this point you should be taken to the DBServers page
directly.
…Click Cancel
…Error: Cannot create repository:
…Click OK
…By now you know something is wrong with the connection or something.
Did you get those errors after only placing the openbase jdbc driver? That is very, very strange. Can you send your servoy.properties file to support at servoy.com and include a short description and/or a link to this post.
Support’s review of my properties file resulted in only the standard diagnostic checks.
A. I did not change to an Openbase database, I already have/had a working Openbase repository_server database before the upgrade to 1.2.
B. The Openbase repository_server database has always been up and working:
it can be jdbc accessed by other tools such as Aqua Data Desk,
which do connect by TCP/IP.
C. From the above, I believe that I do not have to, nor do I want
to, re-create my repository tables, do I? That would be like starting over.
D. I used your proposed command
jdbc:openbase://<12.25.184.102:20223/repository_server
on two different machines with Servoy installed, and the complaint I got, was an immediate error message:
java.sql.SQLException: Can not connect to the openexec at
‘12.25.108.102:20223’
The Server Config did not, previous to R1.2,2 require the explicit port number.
In Openbase the port choices are defaulted to -AUTOMATIC- so I get what I get.
So using my old config,
jdbc:openbase://<12.25.184.102/repository_server
I got to the message:
Cannot find recent repository(version) on current server
connection, do you want to create/upgrade? You might want to
backup your database first before continuing.
How do I know which it will do – create or upgrade? It makes a difference.
Well, I thought maybe it will “upgrade” even though it says it cannot find it.
So I clicked “OK”. That resulted in the following error:
java.sql.SQLException: SQL ERROR - [position 28, near ‘add’ in ‘_solutions add
activeSolu’] alter table command expected but not found.
SQL: alter table servoy_solutions add activeSolutionUpdateSeq int
I do not know the answer, but I can give you a tip!
ALWAYS make a backup of your complete Servoy-directory + databases, before upgrading!! So you can fall-back on what you have.
There can be all kind of (non-Servoy-related) reasons or cases that can happen. powerfailure when you upgrade, etc..etc..
It is the oldest advice, since there are computers, but still a very often used one.
The problem is being caused by the repository upgrade that has to be performed to upgrade from 1.1 to 1.2.
OpenBase does, as we understand now, support the “alter table servoy_solutions add activeSolutionUpdateSeq int” syntax.
The easies solution right now would be if OpenBase implemented that statement (most if not all SQL databases do) the workaround for the time being:
-go back to 1.1 and export all solutions -delete all servoy_ tables in the repository database -install 1.2 which will perform a clean init of the repository
In all cases: make a backup of your Servoy directory and sql database before performing the action.
I am happy to report that Open Base, support@openbase.com,
has quickly changed Open Base to accept “ADD” or “ADD COLUMN” or “COLUMN” in the ALTER TABLE syntax.