Servoy 6.0.2
Sybase SQL Anywhere 11
Windows 7
Using the Servoy 6 all-in-one installer, we are attempting to load the Servoy Application Server (no developer) on top of a Sybase SQL Anywhere 11 database engine.
SQL Anywhere is running as a service and is connected to our application database. We then install Servoy selecting ‘Connect to an existing database’, and, after changing the default connection from PostgreSQL to Sybase, it installs with no error messages.
From the instructions in the wiki, we do the following:
http://wiki.servoy.com/display/public/DOCS/Installing+on+existing+databases
Copy a servoy.properties file from another installation (for example a Servoy Developer installation) into the /application_server directory.
An excerpt from our servoy.properties file:
server.6.URL=jdbc:sybase:Tds:localhost:2638?ServiceName=servoy_repository&CHARSET=utf8
server.6.catalog=
server.6.connectionValidationType=0
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=
server.6.serverName=repository_server
server.6.skipSysTables=false
server.6.userName=DBA
http://wiki.servoy.com/display/public/DOCS/Servoy+Repository+upgrade
To create or upgrade the Servoy Repository data model, shut down the Servoy Application Server if it’s running, open a command line or terminal window and execute the following command in the {servoyInstall}/application_server/ directory:
servoy_server.bat -upgradeRepository
Executing the aforementioned command start the Servoy Application Server and will create or upgrade the table structure required for the Servoy Repository to the version the Servoy Application Server requires.
We start the Sevoy Application Server service, but the servoy_repository table is not created and an error is posted in the Windows event log:
‘The Servoy Application Server service terminated with service-specific error Incorrect function…’
Futhermore, a window pops up with the following message:
‘If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 1.’
The Servoy Application Server log has the following:
2011-11-08 17:10:43,733 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database!
2011-11-08 17:10:52,344 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot start repository:
com.servoy.j2db.persistence.RepositoryException: Error checking repository
at com.servoy.j2db.server.Za.Za.Zb(Za.java:1777)
at com.servoy.j2db.server.Za.Za.(Za.java:1132)
at com.servoy.j2db.server.Za.Za.(Za.java:2060)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1256)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:198)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:238)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc3.tds.Tds.for(Unknown Source)
at com.sybase.jdbc3.tds.Tds.case(Unknown Source)
at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.handleHAFailover(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.(Unknown Source)
at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at com.servoy.j2db.Za.Zp.createConnection(Zp.java:6)
at com.servoy.j2db.Za.Ze.createConnection(Ze.java:4)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at com.servoy.j2db.Za.Za.getConnection(Za.java:162)
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:238)
at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:895)
at com.servoy.j2db.server.Za.Za.Zb(Za.java:1154)
… 10 more
2011-11-08 17:10:52,344 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database!
How do I get this working? Any help appreciated!
Thanks!