SVY 8 : SQL server connection issue
Posted: Tue Jan 03, 2017 11:24 pm
Hi,
I'm trying to install a new application server for servoy 8.1.1
I keep getting error messages when connecting to the repository database
In log file :
The credentials and URL are 100% correct, I copied them from a Servoy 7 installation and re-tested the connection string several times.
Is there something wrong with the shipped driver ?
Thanks
I'm trying to install a new application server for servoy 8.1.1
I keep getting error messages when connecting to the repository database
C:\Servoy_8_Demo\application_server>servoy_server.bat
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
Log file: C:\Servoy_8_Demo\application_server\servoy_log.txt
Creating repository.
Error creating repository: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Cannot find the object "servoy_groups" because it does not exist or you do not have permissions.
In log file :
01-03 22:17:23,556 WARN [main] persistence.Server - Table name availability_group_listener_ip_addresses from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,556 WARN [main] persistence.Server - Table name availability_read_only_routing_lists from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,556 WARN [main] persistence.Server - Table name column_xml_schema_collection_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,556 WARN [main] persistence.Server - Table name database_audit_specification_details from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,556 WARN [main] persistence.Server - Table name dm_cryptographic_provider_properties from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,556 WARN [main] persistence.Server - Table name dm_db_mirroring_auto_page_repair from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,556 WARN [main] persistence.Server - Table name dm_db_missing_index_group_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_db_xtp_nonclustered_index_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_exec_background_job_queue_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_exec_query_resource_semaphores from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_exec_query_transformation_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_filestream_non_transacted_handles from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_fts_semantic_similarity_population from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_hadr_availability_group_states from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_hadr_availability_replica_cluster_nodes from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_hadr_availability_replica_cluster_states from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_hadr_availability_replica_states from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_hadr_database_replica_cluster_states from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_hadr_database_replica_states from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_os_buffer_pool_extension_configuration from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_os_server_diagnostics_log_configurations from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_resource_governor_configuration from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_resource_governor_resource_pool_affinity from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_resource_governor_resource_pool_volumes from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_resource_governor_resource_pools from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_resource_governor_workload_groups from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,571 WARN [main] persistence.Server - Table name dm_tran_active_snapshot_database_transactions from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name filetable_system_defined_objects from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name fulltext_semantic_language_statistics_database from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name message_type_xml_schema_collection_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name parameter_xml_schema_collection_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name registered_search_property_lists from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name resource_governor_configuration from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name resource_governor_resource_pool_affinity from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name resource_governor_resource_pools from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name resource_governor_workload_groups from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name server_audit_specification_details from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name service_contract_message_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name system_components_surface_area_configuration from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name system_internals_allocation_units from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name system_internals_partition_columns from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:23,587 WARN [main] persistence.Server - Table name xml_schema_component_placements from server repository_server is too long (>30 chars) -- this is not supported by all databases [ ]
2017-01-03 22:17:24,587 ERROR [main] com.servoy.j2db.util.Debug - Throwable [ ]
com.servoy.j2db.persistence.RepositoryException: Error creating repository
at com.servoy.j2db.server.main.ApplicationServer.Za(ApplicationServer.java:305)
at com.servoy.j2db.server.main.Zqb.Za(Zqb.java:6)
at com.servoy.j2db.server.main.Zqb.start(Zqb.java:109)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:71)
Caused by: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Cannot find the object "servoy_groups" because it does not exist or you do not have permissions.
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1840)
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1804)
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:1644)
at com.servoy.j2db.server.main.ApplicationServer.Za(ApplicationServer.java:307)
... 3 more
Caused by: java.sql.SQLException: Cannot find the object "servoy_groups" because it does not exist or you do not have permissions.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)
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 com.servoy.j2db.datasource.Zg.invoke(Zg.java:8)
at com.sun.proxy.$Proxy4.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at com.servoy.j2db.server.Za.Zn.createGroupsIndex(Zn.java:52)
at com.servoy.j2db.server.Za.Zn.recreateServoyGroups(Zn.java:1410)
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:1879)
... 6 more
The credentials and URL are 100% correct, I copied them from a Servoy 7 installation and re-tested the connection string several times.
server.0.serverName=repository_server
server.0.URL=jdbc:jtds:sqlserver://localhost/servoy_repository
server.0.driver=net.sourceforge.jtds.jdbc.Driver
server.0.userName=sa
server.0.password=*********
server.0.schema=<none>
server.0.catalog=<none>
Is there something wrong with the shipped driver ?
Thanks