Required to restart Servoy Developer after DB change

Questions and answers regarding the use of eclipse environment as seen in Servoy Developer

Required to restart Servoy Developer after DB change

Postby deezzub » Tue Nov 11, 2014 1:38 pm

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 707 times


Why is it required to restart Servoy Developer?
Sebastian Schlatow
deezzub
 
Posts: 328
Joined: Tue May 28, 2013 3:02 pm
Location: Oldenburg, Germany

Re: Required to restart Servoy Developer after DB change

Postby jcompagner » Mon Nov 24, 2014 6:56 pm

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)
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 7977
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet


Return to Eclipse Environment

Who is online

Users browsing this forum: No registered users and 3 guests