new Record creation application server

Classic Servoy
1

Hi All,

I have created a new Servoy application server version 6.1.4 . The database is postgres 9.0 . When I am creating new record . It is not getting created . The same solution is working fine in Servoy application server 6.1.3 . Is this an issue with Servoy application Server 6.1.4 . Please find the below log issue -

com.servoy.j2db.ApplicationException: Cannot save form data 
    	at com.servoy.j2db.dataprocessing.EditRecordList.stopEditing(EditRecordList.java:783) 
    	at com.servoy.j2db.dataprocessing.EditRecordList.stopEditing(EditRecordList.java:221) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_saveData(JSDatabaseManager.java:2360) 
    	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.mozilla.javascript.MemberBox.invoke(MemberBox.java:158) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:311) 
    	at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1774) 
    	at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:837) 
    	at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:158) 
    	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:406) 
    	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3192) 
    	at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:156) 
    	at com.servoy.j2db.scripting.ScriptEngine.executeFunction(ScriptEngine.java:574) 
    	at com.servoy.j2db.FormController.executeFunction(FormController.java:4933) 
    	at com.servoy.j2db.FormController.executeFunction(FormController.java:4814) 
    	at com.servoy.j2db.FormController.executeFunction(FormController.java:4681) 
    	at com.servoy.j2db.FormController$ScriptExecuter.executeFunction(FormController.java:4526) 
    	at com.servoy.j2db.ui.BaseEventExecutor.fireEventCommand(BaseEventExecutor.java:276) 
    	at com.servoy.j2db.ui.BaseEventExecutor.fireActionCommand(BaseEventExecutor.java:218) 
    	at com.servoy.j2db.server.headlessclient.dataui.WebEventExecutor.handleEvent(WebEventExecutor.java:459) 
    	at com.servoy.j2db.server.headlessclient.dataui.WebEventExecutor.onEvent(WebEventExecutor.java:400) 
    	at com.servoy.j2db.server.headlessclient.dataui.WebEventExecutor$2.onEvent(WebEventExecutor.java:180) 
    	at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:177) 
    	at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:312) 
    	at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:157) 
    	at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92) 
    	at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1279) 
    	at org.apache.wicket.RequestCycle.step(RequestCycle.java:1358) 
    	at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1465) 
    	at org.apache.wicket.RequestCycle.request(RequestCycle.java:545) 
    	at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:486) 
    	at com.servoy.j2db.server.servlets.Zt.doGet(Zt.java:16) 
    	at org.apache.wicket.protocol.http.WicketServlet.doGet(WicketServlet.java:138) 
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) 
    	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615) 
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) 
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) 
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) 
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
    	at java.lang.Thread.run(Unknown Source) 
    Caused by: com.servoy.j2db.dataprocessing.DataException: Unknown Types value. 
    	at com.servoy.j2db.dblayer.Zb.Za(Zb.java:240) 
    	at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1425) 
    	at com.servoy.j2db.dataprocessing.Zv.Za(Zv.java:191) 
    	at com.servoy.j2db.dataprocessing.Zv.performUpdates(Zv.java:1234) 
    	at com.servoy.j2db.dataprocessing.EditRecordList.stopEditing(EditRecordList.java:597) 
    	... 50 more

org.postgresql.util.PSQLException: Unknown Types value. 
    	at org.postgresql.jdbc2.AbstractJdbc2Statement.setNull(AbstractJdbc2Statement.java:1153) 
    	at org.postgresql.jdbc3.AbstractJdbc3Statement.setNull(AbstractJdbc3Statement.java:1492) 
    	at sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    	at java.lang.reflect.Method.invoke(Unknown Source) 
    	at com.servoy.j2db.datasource.Zg.invoke(Zg.java:4) 
    	at com.sun.proxy.$Proxy0.setNull(Unknown Source) 
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) 
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) 
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) 
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) 
    	at com.servoy.j2db.dataprocessing.Zv.Za(Zv.java:766) 
    	at com.servoy.j2db.dataprocessing.Zv.Za(Zv.java:895) 
    	at com.servoy.j2db.dataprocessing.Zv.performUpdates(Zv.java:1234) 
    	at com.servoy.j2db.dataprocessing.EditRecordList.stopEditing(EditRecordList.java:597) 
    	at com.servoy.j2db.dataprocessing.EditRecordList.stopEditing(EditRecordList.java:221) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_saveData(JSDatabaseManager.java:2360) 
    	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.mozilla.javascript.MemberBox.invoke(MemberBox.java:158) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:311) 
    	at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1774) 
    	at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:837) 
    	at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:158) 
    	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:406) 
    	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3192) 
    	at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:156) 
    	at com.servoy.j2db.scripting.ScriptEngine.executeFunction(ScriptEngine.java:574) 
    	at com.servoy.j2db.FormController.executeFunction(FormController.java:4933) 
    	at com.servoy.j2db.FormController.executeFunction(FormController.java:4814) 
    	at com.servoy.j2db.FormController.executeFunction(FormController.java:4681) 
    	at com.servoy.j2db.FormController$ScriptExecuter.executeFunction(FormController.java:4526) 
    	at com.servoy.j2db.ui.BaseEventExecutor.fireEventCommand(BaseEventExecutor.java:276) 
    	at com.servoy.j2db.ui.BaseEventExecutor.fireActionCommand(BaseEventExecutor.java:218) 
    	at com.servoy.j2db.server.headlessclient.dataui.WebEventExecutor.handleEvent(WebEventExecutor.java:459) 
    	at com.servoy.j2db.server.headlessclient.dataui.WebEventExecutor.onEvent(WebEventExecutor.java:400) 
    	at com.servoy.j2db.server.headlessclient.dataui.WebEventExecutor$2.onEvent(WebEventExecutor.java:180) 
    	at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:177) 
    	at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:312) 
    	at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:157) 
    	at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92) 
    	at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1279) 
    	at org.apache.wicket.RequestCycle.step(RequestCycle.java:1358) 
    	at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1465) 
    	at org.apache.wicket.RequestCycle.request(RequestCycle.java:545) 
    	at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:486) 
    	at com.servoy.j2db.server.servlets.Zt.doGet(Zt.java:16) 
    	at org.apache.wicket.protocol.http.WicketServlet.doGet(WicketServlet.java:138) 
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) 
    	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615) 
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) 
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) 
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) 
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
    	at java.lang.Thread.run(Unknown Source)

Please provide your suggestions .

Thanks,
Ashutos.

2

Hi All,

In the in the new record creation query we are getting some unknown types . Please find the query :

14730 ,type: java.lang.Long, 2 ,type: java.lang.Integer, 1 ,type: java.lang.Integer, 1 ,type: java.lang.Integer, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, 1047 ,type: java.lang.Integer, 100 ,type: java.lang.Integer, 0 ,type: java.lang.Integer, 0 ,type: java.lang.Integer, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 2000 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 8 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 2000 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, ‘FTS-14730’ ,type: java.lang.String

Thanks,
Ashutos.

3

Hi All,

Please provide some suggestions on this.

Thanks,
Ashutos.

4

I had this when upgrading to 6.1.4. Servoy is fuzzy about PostgreSQL types it does not understand and refuses to save the record. I had to remove a field of type ‘interval’. I would look for any PostgreSQL specific types in the table…

5

Hi swingman,

Thanks for your reply . I have also seen another thread of yours . I have also made all the interval fields ( datetime type) with display and edit format (dd-MM-yyyy) . But still the issue is persisting . I cannot delete these fields.

Please provide your suggestions on this.

6

Hi All ,

Is this a issue with Servoy Application server 6.1.4 ? . Can I post a Servoy Support request in the Servoy support site ?.