Can't Change Table Settings on a Specific Table...

Classic Servoy
1

My solution uses a database that I don’t want users to be able to alter.

While setting up Security permissions for one of the tables I unchecked INSERT, UPDATE and DELETE checkboxes.

No they will not recheck no matter what I do.

Here’s my cmd (I deleted a calc field associated with the table in question that I saw was getting errors):

Starting Servoy from C:\Documents and Settings\Administrator.JANUS\Desktop\11-22
-04
Servoy R2 2.1.1 build-313 on Windows XP using Java 1.4.2_04
Loading servoy.properties from C:\Documents and Settings\Administrator.JANUS\ser
voy.properties
Loading - Done
java.rmi.server.ExportException: Port already in use: 2638; nested exception is:

java.net.BindException: Address already in use: JVM_Bind
java.rmi.server.ExportException: Port already in use: 2638; nested exception is:

java.net.BindException: Address already in use: JVM_Bind
at sun.rmi.transport.tcp.TCPTransport.listen(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.exportObject(Unknown Source)
at sun.rmi.transport.tcp.TCPEndpoint.exportObject(Unknown Source)
at sun.rmi.transport.LiveRef.exportObject(Unknown Source)
at sun.rmi.server.UnicastServerRef.exportObject(Unknown Source)
at sun.rmi.registry.RegistryImpl.setup(Unknown Source)
at sun.rmi.registry.RegistryImpl.(Unknown Source)
at java.rmi.registry.LocateRegistry.createRegistry(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.startDataServer(Unknown Sour
ce)
at com.servoy.j2db.develop.J2DBDeveloper.dataBaseInit(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.main(Unknown Source)
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 com.servoy.j2db.startup.Bootstrap.main(Bootstrap.java:119)
at Servoy.main(Servoy.java:27)
Caused by: java.net.BindException: Address already in use: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(Unknown Source)
at java.net.ServerSocket.bind(Unknown Source)
at java.net.ServerSocket.(Unknown Source)
at java.net.ServerSocket.(Unknown Source)
at javax.net.ssl.SSLServerSocket.(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLServerSocketImpl.(Unknown Sourc
e)
at com.sun.net.ssl.internal.ssl.SSLServerSocketFactoryImpl.createServerS
ocket(Unknown Source)
at com.servoy.j2db.util.a.d.createServerSocket(Unknown Source)
at sun.rmi.transport.tcp.TCPEndpoint.newServerSocket(Unknown Source)
… 17 more
Using RMI registry on port 2639
Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
Starting service Tomcat-Apache
Apache Tomcat/4.0.1
java.lang.NullPointerException
java.lang.NullPointerException
at com.servoy.j2db.dataprocessing.am.if(Unknown Source)
at com.servoy.j2db.dataprocessing.am.startEditing(Unknown Source)
at com.servoy.j2db.develop.h.g.n(Unknown Source)
at com.servoy.j2db.develop.h.g.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknow
n Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
ce)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(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.pumpEventsForHierarchy(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog.show(Unknown Source)
at java.awt.Component.show(Unknown Source)
at java.awt.Component.setVisible(Unknown Source)
at com.servoy.j2db.util.b.setVisible(Unknown Source)
at com.servoy.j2db.develop.h.e.H(Unknown Source)
at com.servoy.j2db.develop.c.i.doIt(Unknown Source)
at com.servoy.j2db.cmd.c$2.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)
null

Any suggestions?

Thanks!

2

pls update first to Servoy 2.1.2. final release and verify if your problem still exists.

3

Jan:

2.1.2 seems to have fixed it!

How can I trace where this locked field is eminating from using the debugger?

Here’s the error I get:

com.servoy.j2db.n: Record is locked (In_Queue2, line 8 )

The yellow arrow points to line 7.

Here is line 7 and 8:

inqueue = runtot
if(ccustno == globals.gCustomerNo)

I’m not too handy with the debugger yet. Not sure what is ment by the locked field!

Thanks!

John Michael