Pervasive SQL 11 Connection Problems on Servoy 7.4.1 Rel 202
Posted: Tue Aug 12, 2014 8:38 pmWhen trying to establish and debug connections to a pervasive SQL 11 database using Servoy 7.4.1 Releease 2028 developer running on OSX Mavericks, the following error occurs:
An internal error occurred during: "Loading servers/tables needed by current solution".com/pervasive/pscs/Manager
The definition that gets saved in the server.properties file is as follows:
server.7.URL=jdbc\:pervasive\://cpt-app.internal.cptechnologies.local\:1583/CPTJAVA?transport-\=tcp
server.7.catalog=<none>
server.7.connectionValidationType=0
server.7.driver=com.pervasive.jdbc.v2.Driver
server.7.enabled=true
server.7.maxConnectionsActive=30
server.7.maxConnectionsIdle=10
server.7.maxPreparedStatementsIdle=100
server.7.password=encrypted\:M5X/mmP2pAxLAfPInt6rjw\=\=
server.7.schema=<none>
server.7.serverName=pervasive
server.7.skipSysTables=false
server.7.userName=CPTECHNOLOGIES\\Administrator
When this server is enabled, the error occurs and the postgres solution databases do not load. If the database is not enabled, the postegres databases load fine and are available to the developer. Please note that this database loads and opens fine on the application server using the same credentials and JDBC files in the application server drivers directory.
An internal error occurred during: "Loading servers/tables needed by current solution".com/pervasive/pscs/Manager
The definition that gets saved in the server.properties file is as follows:
server.7.URL=jdbc\:pervasive\://cpt-app.internal.cptechnologies.local\:1583/CPTJAVA?transport-\=tcp
server.7.catalog=<none>
server.7.connectionValidationType=0
server.7.driver=com.pervasive.jdbc.v2.Driver
server.7.enabled=true
server.7.maxConnectionsActive=30
server.7.maxConnectionsIdle=10
server.7.maxPreparedStatementsIdle=100
server.7.password=encrypted\:M5X/mmP2pAxLAfPInt6rjw\=\=
server.7.schema=<none>
server.7.serverName=pervasive
server.7.skipSysTables=false
server.7.userName=CPTECHNOLOGIES\\Administrator
When this server is enabled, the error occurs and the postgres solution databases do not load. If the database is not enabled, the postegres databases load fine and are available to the developer. Please note that this database loads and opens fine on the application server using the same credentials and JDBC files in the application server drivers directory.