Required to restart Servoy Developer after DB change

Classic Servoy
1

I changed the JDBC url to another database server in Servoy Developer. In that case I have to restart Servoy Developer, because I get errors like the following.:

Exception Object: com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_userdb:/svy_framework/sec_user#secuser1922.1073763250=?
MSG: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_userdb:/svy_framework/sec_user#secuser1922.1073763250=?
is a ServoyException
Errorcode: 217
com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_userdb:/svy_framework/sec_user#secuser1922.1073763250=?
at com.servoy.j2db.server.Za.Zo.getSQLQuerySet(Zo.java:1533)
at com.servoy.j2db.server.dataprocessing.Zw.getSQLQuerySet(Zw.java:1305)
at sun.reflect.GeneratedMethodAccessor239.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_userdb:/svy_framework/sec_user#secuser1922.1073763250=?
Wrapped java.lang.RuntimeException: Can’t get new foundset for: QBSelect(SELECT bin_svy_framework:dbo:sec_userdb:/svy_framework/sec_user#secuser1919.1073763250=user_id<-9,36,0> FROM bin_svy_framework:dbo:sec_userdb:/svy_framework/sec_user#secuser1919 ((bin_svy_framework:dbo:sec_userdb:/svy_framework/sec_user#secuser1919.1073763250=user_id<-9,36,0>)=([=C4FE390F-C3F7-4ADE-8A41-5AAE3654EB65]))) (C:\Workspace\servoy_workspace_git\boss\BOSS\boss$initialization.js#323)
at C:\Workspace\servoy_workspace_git\boss\BOSS\boss$initialization.js:323 (setUserLanguage)
at C:\Workspace\servoy_workspace_git\boss\BOSS\boss$initialization.js:130 (onSolutionStart)

function setUserLanguage( ) {
	/** @type {QBSelect<db:/svy_framework/sec_user>} */
	var userLanguageQuery = databaseManager.createSelect( "db:/svy_framework/sec_user" );
	userLanguageQuery.result.addPk( );
	userLanguageQuery.where.add( userLanguageQuery.columns.user_id.eq( globals.svy_sec_lgn_user_id ) );
	/** @type JSFoundSet<db:/svy_framework/sec_user> */
	var fsUserLanguage = databaseManager.getFoundSet( userLanguageQuery );
	userLanguage = fsUserLanguage.sprache;
	if ( userLanguage && userLanguage.length > 0 ) {
		i18n.setLocale( userLanguage.substr( 0, 2 ).toLowerCase( ), userLanguage.substr( 0, 2 ).toUpperCase( ) );
	} else {
		userLanguage = 'de,DE'
		i18n.setLocale( "de", "DE" );
	}
}

[attachment=0]2014-11-11_12_35_19-Servoy_Developer_after_jdbc_url_change.png[/attachment]

Why is it required to restart Servoy Developer?

2014-11-11_12_35_19-Servoy_Developer_after_jdbc_url_change.png
2014-11-11_12_35_19-Servoy_Developer_after_jdbc_url_change.png1007×735 38.8 KB

2

don’t think a full restart is required for the developer
But a full restart of a client will be needed, you need to restart the client completely (maybe even press the shutdown icon on the admin page)