Page 1 of 1

Required to restart Servoy Developer after DB change

PostPosted: Tue Nov 11, 2014 1:38 pm
by deezzub
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_user<db:/svy_framework/sec_user>#secuser1922.1073763250=?
MSG: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/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_user<db:/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_user<db:/svy_framework/sec_user>#secuser1922.1073763250=?
Wrapped java.lang.RuntimeException: Can't get new foundset for: QBSelect(SELECT bin_svy_framework:dbo:sec_user<db:/svy_framework/sec_user>#secuser1919.1073763250=user_id<-9,36,0> FROM bin_svy_framework:dbo:sec_user<db:/svy_framework/sec_user>#secuser1919 <anonymous> ((bin_svy_framework:dbo:sec_user<db:/svy_framework/sec_user>#secuser1919.1073763250=user_id<-9,36,0>)=([<anonymous>=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)



Code: Select all
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" );
   }
}


2014-11-11_12_35_19-Servoy_Developer_after_jdbc_url_change.png
Servoy Developer error after JDBC url change
2014-11-11_12_35_19-Servoy_Developer_after_jdbc_url_change.png (62.4 KiB) Viewed 3609 times


Why is it required to restart Servoy Developer?

Re: Required to restart Servoy Developer after DB change

PostPosted: Mon Nov 24, 2014 6:56 pm
by jcompagner
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)