I have one more troublesome intermittant problem with my solution. This is a problem that has been present for many versions of Servoy.
The solution has many tab panels on it. The tabpanels are related tab panels and the default controllor is on the internal form (the form displayed via the tab panel). On intermittant occasion the application will forget my foundset. It will suddenly display all records through the tab panel (even those not defined by the tab relationship). The internal tabpanels have portals on them and the portals will be completely jumbled as well. If I navigate to another form all appears normal on that form. Navigating back to the jumbled form will fix the problem.
I cannot prove this, but I have a sneaking suspicion that this occurs when Servoy reallocates memory.
Do you have anyway of looking into this further? Is there a way to start the client with more memory. If this solves the problem it would help reduce the possibilities of where to look for the bug.
John McCann
I wanted to add that when this happens the java log says this.
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near the keyword ‘is’. [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near the keyword ‘is’.
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near the keyword ‘is’. [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near the keyword ‘is’.
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.performCustomQuery(Unknown Source)
at sun.reflect.GeneratedMethodAccessor134.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine_Stub.performCustomQuery(Unknown Source)
at com.servoy.j2db.dataprocessing.ae.if(Unknown Source)
at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_getDataSetByQuery(Unknown Source)
at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:289)
at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1242)
at org.mozilla.javascript.gen.c228.call(OnShow:12)
at com.servoy.j2db.scripting.f.executeFunction(Unknown Source)
at com.servoy.j2db.FormPanel.a(Unknown Source)
at com.servoy.j2db.FormPanel.a(Unknown Source)
at com.servoy.j2db.FormPanel.a(Unknown Source)
at com.servoy.j2db.FormPanel.cl(Unknown Source)
at com.servoy.j2db.FormManager$5.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
java.lang.NullPointerException
java.lang.NullPointerException
at com.servoy.j2db.scripting.m.get(Unknown Source)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1095)
at org.mozilla.javascript.gen.c193.call(ElementsVisible:2)
at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1242)
at org.mozilla.javascript.gen.c192.call(OnShow:15)
at com.servoy.j2db.scripting.f.executeFunction(Unknown Source)
at com.servoy.j2db.FormPanel.a(Unknown Source)
at com.servoy.j2db.FormPanel.a(Unknown Source)
at com.servoy.j2db.FormPanel.a(Unknown Source)
at com.servoy.j2db.FormPanel.cl(Unknown Source)
at com.servoy.j2db.dataui.l$1.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
John McCann
Servoy Client
Version R2 2.1.2-build 315
Java version 1.4.2_06-b03 (Windows 2003)