Menu ▾ ▴

Update record in application

General Discussion
MILOS KAMPIJUT
2015-08-20
2015-08-24

  • MILOS KAMPIJUT

    MILOS KAMPIJUT - 2015-08-20

    I can insert the record into application , but i can't update it.

    I allways recive error "Internal server error".

    From 4WSLOG:

    DEBUG 20/08/2015 09:03:40 ADMIN Checking unique key:
    select 1 from SKLADISCNIPROMET where zapstev=?

    10
    00000

    DEBUG 20/08/2015 09:03:40 ADMIN PARAM1: null

    10
    00000

    DEBUG 20/08/2015 09:03:40 ADMIN UPDATE SKLADISCNIPROMET SET SKLADISCE=?,DATUM=?,VRSTAPROMETA=?,ARTIKEL=?,KOLICINA=?,CENA=?,REFERENT=?,
    OPOMBA=? WHERE ZAPSTEV=?
    PARAM1: 'SKL1'
    PARAM2: 1900-01-01
    PARAM3: 'VRPROM10'
    PARAM4: 'IZD1'
    PARAM5: 0
    PARAM6: 0
    PARAM7: 'MK'
    PARAM8: 'qqqq'
    PARAM9: 1

    10
    00000

    DEBUG 20/08/2015 09:03:40 ADMIN Processed rows: 1

    10
    00000

    DEBUG 20/08/2015 09:03:40 java.lang.NullPointerException
    at org.wag.renderer.java.JSONVORenderer.addAttribute(JSONVORenderer.java:148)
    at org.wag.interpreter.web.SetDetaiResource.setDetail(SetDetaiResource.java:451)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)

    at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker.

    _dispatch(AbstractResourceMethodDispatchProvider.java:205)
    at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.
    java:75)
    at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288)
    at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)

    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1469)

at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400)

at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349)

at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339)

    after that i reload the form adn the changed data are there.
    What is wrong?

    T

     

    • mcarniel

      mcarniel - 2015-08-20

      Hi!

      Again, the information provided is too little to help you!
      Which is the panel connected to that operation? a grid? a form?
      How have the components in that panel been configured? All of them have
      been set as "managed"? saved in insert? in edit?
      What about the object linked to the panel? are you saving a single table?
      if yes, which is the structure of the table? Did you use "special" field
      types when definiing the table or just VARCHAR, NUMERIC, etc.?
      Can u include the table structure (SQL script...) ?

      2015-08-20 9:10 GMT+02:00 MILOS KAMPIJUT miloskam@users.sf.net:

      I can insert the record into application , but i can't update it.

      I allways recive error "Internal server error".
      From 4WSLOG:

      DEBUG 20/08/2015 09:03:40 ADMIN Checking unique key:
      select 1 from SKLADISCNIPROMET where zapstev=?

      10
      00000

      DEBUG 20/08/2015 09:03:40 ADMIN PARAM1: null

      10
      00000

      DEBUG 20/08/2015 09:03:40 ADMIN UPDATE SKLADISCNIPROMET SET
      SKLADISCE=?,DATUM=?,VRSTAPROMETA=?,ARTIKEL=?,KOLICINA=?,CENA=?,REFERENT=?,
      OPOMBA=? WHERE ZAPSTEV=?
      PARAM1: 'SKL1'
      PARAM2: 1900-01-01
      PARAM3: 'VRPROM10'
      PARAM4: 'IZD1'
      PARAM5: 0
      PARAM6: 0
      PARAM7: 'MK'
      PARAM8: 'qqqq'
      PARAM9: 1

      10
      00000

      DEBUG 20/08/2015 09:03:40 ADMIN Processed rows: 1

      10
      00000

      DEBUG 20/08/2015 09:03:40 java.lang.NullPointerException
      at
      org.wag.renderer.java.JSONVORenderer.addAttribute(JSONVORenderer.java:148)
      at
      org.wag.interpreter.web.SetDetaiResource.setDetail(SetDetaiResource.java:451)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at
      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at
      com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)

      at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker.

      _dispatch(AbstractResourceMethodDispatchProvider.java:205)
      at
      com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.
      java:75)
      at
      com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288)
      at
      com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
      at
      com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
      at
      com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)

      at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1469)

      at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400)

      at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349)

      at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339)

      after that i reload the form adn the changed data are there.
      What is wrong?

      T

      Update record in application
      https://sourceforge.net/p/xwsplatform/discussion/general/thread/dca321a0/?limit=25#2b3b

      Sent from sourceforge.net because you indicated interest in
      https://sourceforge.net/p/xwsplatform/discussion/general/

      To unsubscribe from further messages, please visit
      https://sourceforge.net/auth/subscriptions/

       

  • mcarniel

    mcarniel - 2015-08-20

    In addition: is the problem you reported specific to that panel or does it happen in avery panel of the same type?

     

  • MILOS KAMPIJUT

    MILOS KAMPIJUT - 2015-08-20

    I have the same situation on all Windows .
    It is combine with grid and detail.
    The grid is only for list ( no input , delete ,…) and the detail is for input , update, delete,….

    I’m saving single table.

    This is one table :

    -- PostgreSQL database dump

    SET statement_timeout = 0;
    SET client_encoding = 'UTF8';
    SET standard_conforming_strings = on;
    SET check_function_bodies = false;
    SET client_min_messages = warning;

    SET search_path = public, pg_catalog;

    SET default_tablespace = '';

    SET default_with_oids = false;

    --
    -- Name: artikli; Type: TABLE; Schema: public; Owner: super; Tablespace:
    --

    CREATE TABLE artikli (
    sifra character varying(10) NOT NULL,
    naziv character varying(50),
    em character varying(10),
    cena numeric(16,2),
    skupina character varying(10)
    );

    ALTER TABLE public.artikli OWNER TO super;

    --
    -- Name: artikli_pkey; Type: CONSTRAINT; Schema: public; Owner: super; Tablespace:
    --

    ALTER TABLE ONLY artikli
    ADD CONSTRAINT artikli_pkey PRIMARY KEY (sifra);

    --
    -- Name: fk_artikli_enotamere; Type: FK CONSTRAINT; Schema: public; Owner: super
    --

    ALTER TABLE ONLY artikli
    ADD CONSTRAINT fk_artikli_enotamere FOREIGN KEY (em) REFERENCES enotamere(sifraem);

    --
    -- Name: fk_artikli_skupineartiklov; Type: FK CONSTRAINT; Schema: public; Owner: super
    --

    ALTER TABLE ONLY artikli
    ADD CONSTRAINT fk_artikli_skupineartiklov FOREIGN KEY (skupina) REFERENCES skupineartiklov(sifraskart);

    --
    -- PostgreSQL database dump complete

     

    • mcarniel

      mcarniel - 2015-08-20

      what about the grid definition? can u provide a screenshot of those
      settings?

      2015-08-20 9:52 GMT+02:00 MILOS KAMPIJUT miloskam@users.sf.net:

      I have the same situation on all Windows .
      It is combine with grid and detail.
      The grid is only for list ( no input , delete ,…) and the detail is for
      input , update, delete,….

      I’m saving single table.
      This is one table : -- PostgreSQL database dump

      SET statement_timeout = 0;
      SET client_encoding = 'UTF8';
      SET standard_conforming_strings = on;
      SET check_function_bodies = false;
      SET client_min_messages = warning;

      SET search_path = public, pg_catalog;

      SET default_tablespace = '';

      SET default_with_oids = false;

      --
      -- Name: artikli; Type: TABLE; Schema: public; Owner: super; Tablespace:
      --

      CREATE TABLE artikli (
      sifra character varying(10) NOT NULL,
      naziv character varying(50),
      em character varying(10),
      cena numeric(16,2),
      skupina character varying(10)
      );

      ALTER TABLE public.artikli OWNER TO super;

      --
      -- Name: artikli_pkey; Type: CONSTRAINT; Schema: public; Owner: super;
      Tablespace:
      --

      ALTER TABLE ONLY artikli
      ADD CONSTRAINT artikli_pkey PRIMARY KEY (sifra);

      --
      -- Name: fk_artikli_enotamere; Type: FK CONSTRAINT; Schema: public; Owner:
      super
      --

      ALTER TABLE ONLY artikli
      ADD CONSTRAINT fk_artikli_enotamere FOREIGN KEY (em) REFERENCES
      enotamere(sifraem);

      --
      -- Name: fk_artikli_skupineartiklov; Type: FK CONSTRAINT; Schema: public;
      Owner: super
      --

      ALTER TABLE ONLY artikli
      ADD CONSTRAINT fk_artikli_skupineartiklov FOREIGN KEY (skupina) REFERENCES
      skupineartiklov(sifraskart);

      --
      -- PostgreSQL database dump complete

      Update record in application
      https://sourceforge.net/p/xwsplatform/discussion/general/thread/dca321a0/?limit=25#94de

      Sent from sourceforge.net because you indicated interest in
      https://sourceforge.net/p/xwsplatform/discussion/general/

      To unsubscribe from further messages, please visit
      https://sourceforge.net/auth/subscriptions/

       

  • MILOS KAMPIJUT

    MILOS KAMPIJUT - 2015-08-21

    It is in attachment.

     
    4ws_1.rtf

  • mcarniel

    mcarniel - 2015-08-24

    Hi!

    I had a look at the screenshots you attached. They are related to the grid and you told me that the grid is readonly and that you are saving data through the detail.So I need to know the settings FOR THE DETAIL!

     

  • mcarniel

    mcarniel - 2015-08-24

    Can u please attach also the settings for the object linked to the grid/detail?

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.