In servoy 3.5 you could automatically bring in all of your relations from you db. How is this done in servoy 4.1 with team sharing enabled. I updated some constraints on my backend db and I need to update the relations in servoy.
there is an action Load Relations in context menu of each server
I have tried several times using the load relations, but they do not update. I know what changes I made in the db but they do not update in servoy.
Did you make your changes while Servoy was running? In that case you have to do “reload table structure” from the same context menu before Servoy sees the changes.
I tried “Reload table/table structures from Db” then I tried “Load Relations” . Nothing changes. I can look at my constraints in the mysql console, but they do not update in servoy. Does it matter that I am using team sharing?
Running servoy 4.1 with mysql 5.0.22
You can only create new relations with Load Relations functionality. You should see the matching relations in the wizard and (if a relation with that name doesn’t exist) the relation will be created.
Laurian,
when I click on “Load Relations” I do not get a wizard. I assume that the wizard would look like it did in 3.5. Nothing happens at all. Is there a setting to enable this wizard or a known bug that’s causing it not to display? Just to clarify, I go to my desired server right click, in the context menu i click ‘reload tables\ table structure from Db’, then click ‘load relations’. When I go through the following sequence nothing happens.
Hmm, the wizard should display … Do you have any errors in the logs (probably in .log from workspace.metadata) ? I guess this is for a valid server.
Laurian,
The server I am trying to use is a valid mysql database connection.
I cleared the contents of the .log then reopened servoy and tried to load relations.
Below is the contents of the .log file:
SESSION 2009-02-19 09:22:33.034 -----------------------------------------------
eclipse.buildId=M20071023-1652
java.version=1.6.0_11
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Framework arguments: --launcher.XXMaxPermSize 256M
Command-line arguments: -os win32 -ws win32 -arch x86 --launcher.XXMaxPermSize 256M
!ENTRY com.servoy.eclipse.core 1 0 2009-02-19 09:22:41.096
!MESSAGE Time taken to read in the solution SMC_MRP: 2265
!ENTRY org.eclipse.ui.workbench 2 0 2009-02-19 09:22:42.486
!MESSAGE A handler conflict occurred. This may disable some commands.
!SUBENTRY 1 org.eclipse.ui.workbench 2 0 2009-02-19 09:22:42.486
!MESSAGE Conflict for ‘AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction’:
HandlerActivation(commandId=AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction,
handler=ActionDelegateHandlerProxy(null,org.eclipse.ui.cheatsheets.CheatSheetExtensionFactory:helpMenuAction),
expression=AndExpression(ActionSetExpression(org.eclipse.ui.cheatsheets.actionSet,org.eclipse.ui.internal.WorkbenchWindow@c54654),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@c54654)),sourcePriority=16640)
HandlerActivation(commandId=AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction,
handler=ActionDelegateHandlerProxy(null,org.eclipse.ui.cheatsheets.CheatSheetExtensionFactory:helpMenuAction),
expression=AndExpression(ActionSetExpression(org.eclipse.ui.cheatsheets.actionSet,org.eclipse.ui.internal.WorkbenchWindow@c54654),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@c54654)),sourcePriority=16640)
!ENTRY org.eclipse.ui 4 0 2009-02-19 09:23:43.185
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.ClassCastException: com.servoy.eclipse.ui.views.solutionexplorer.Zh cannot be cast to com.servoy.j2db.develop.node.Ze
at com.servoy.eclipse.ui.wizards.Zc.init(Zc.java:11)
at com.servoy.eclipse.ui.views.solutionexplorer.actions.Zab.Za(Zab.java:12)
at com.servoy.eclipse.ui.views.solutionexplorer.actions.Zab.run(Zab.java:5)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:546)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
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 org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
I see there already is a case in our system about this: 179256: Cannot Load Relations . This has been fixed in latest code. You can either update to 4.1.0 i6 or wait for 4.1.1 to be released.
When is 4.1.1 going to be released? I have same problem -in addition to another problem that is also fixed in 4.1.1.
I need to know for planning -including a presentation using the new Servoy/Eclipse environment…
Updating to 4.1 i6 allowed the the Load Relation dialog to display. However, when I try to load the relations it crashes. here is the error I receive in my /.metadata/.log
!ENTRY org.eclipse.core.jobs 4 2 2009-02-20 09:44:53.027
!MESSAGE An internal error occurred during: “Save solution data”.
!STACK 0
java.lang.NullPointerException
at com.servoy.eclipse.core.repository.Zf.Za(Zf.java:78)
at com.servoy.eclipse.core.repository.EclipseRepository$2.runInWorkspace(EclipseRepository.java:17)
at org.eclipse.core.internal.resources.InternalWorkspaceJob.run(InternalWorkspaceJob.java:38)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
I even wiped out all my relations and still I get this error.
Do you have errors in the other log as well (or other errors in the same log)? This seems like some relation cannot be created and then , when it tries to save , a null pointer exception occurs.
I never read it! My entire fault! Well, now we all know…
pbakker:
hi Carlos,Your question has already been answered: viewtopic.php?f=8&t=11978\
Paul