Hello,
I am using Servoy Servoy Developer
Version 3.1.8-build 412
Java version 14.1-b02 (Windows Vista)
Sybase Cenral 10
local vista machine.
I wanted to Create a new Database and store it in my Servoy Data Folder. I did this using Sybase Central and had no problem. I started Servoy and i did not find the repository. I then closed Sybase Central and reopend servoy, then created a Data Base Connection to the new Data Base I created.
The problem I am having is that I am having conflicts with Servoy and Sybase Central. I can get everything working and see my tables, but if I close out of Servoy and reopen, my database connection in servoy dissapears and I have to recreate. I also have to set up a new connection to the dabase in sybase central each time I close Sybase Central.
I know I just need to get the Sybase Central Service open and to start when Servoy Starts without creating a conflict with the servoy repository.
Thanks in Advance,
Erich
Have you added your new database to the Sybase config file (/application_server/sybase_db/sybase.config)? If you did, did you make sure it is spelled correctly? An error in the config file will cause the server not start properly.
Is the connection information actually disappearing or is it just showing the database is not connected?
Finally, you can check the sybase_log.txt file in the same folder as the config file and see if there are any errors occuring there.
Regards,
Jason
Hi Jason,
I added it to the config file.
If I start servoy first, then try to make a database sever connection it does not work(JZ00L: Login Failed Error).
If I create the server connection to the Database via Sybase Central I can see the server running in the tray. If I then open servoy I cannot find the repository, but I can create the database connection in the servoy preferences.
If the servoy repository is running I can not set up the Sybase Server connection via sybase cenral. After enough going back and forth I can get them both to work and the solution to show the data in the new database.
Once I close the servoy solution after the creation of the servoy database Server connection. When I reopen the connection is gone,this is the part I dont understand the most. It has to be something elementry, this is a fresh install of servoy and sybase central
Erich
Erich,
Is the server definition stored in the servoy.properties file?
Servoy saves the list of server defs in \application_server\servoy.properties
They look something like:
server.6.URL=jdbc\:sybase\:Tds\:localhost\:2638?ServiceName\=servoy_repository&CHARSET\=utf8
server.6.catalog=<none>
server.6.connectionValidationType=0
server.6.dataModelCloneFrom=example_data
server.6.driver=com.sybase.jdbc3.jdbc.SybDriver
server.6.enabled=true
server.6.maxConnectionsActive=10
server.6.maxConnectionsIdle=10
server.6.maxPreparedStatementsIdle=100
server.6.password=encrypted\:aD4kOmHPzcM\=
server.6.schema=<none>
server.6.serverName=repository_server
server.6.userName=DBA
server.6.validationQuery=
Maybe the file is missing write permission.
Rob
Hi ROb,
I did a new install of servoy 4.0 and sybase central 10. After having problems starting the database service in sybase and the database server connections in servoy, I just created the new database from within servoy and everything worked without a problem. For now, this got me up and running, and I love the new development enviorment.
Thanks for all the help