postgresql error trying to bring documnet as a null

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JustinKarouz
    New Member
    • Feb 2021
    • 2

    postgresql error trying to bring documnet as a null

    Trying to change the docname to bring back a blank i instead get a resultSet error:
    Java Side;
    String filepath = foldername.trim () +"templates/" + control.getCore ports() + docname1 + ".docx";

    String outpath = foldername.trim () +"merged/"+ docname1 + ".docx";

    postgresql part

    update test.coltran set docstored = l_uuid_32, docname1 = p_filnam where bilbatchno = l_bilbatchno;

    INSERT into test.table
    (id, data, name)
    VALUES
    (l_uuid_32, pg_read_binary_ file(p_filnam), p_filnam);
    end if;

    now if this file is null it gives a result list error
  • Banfa
    Recognized Expert Expert
    • Feb 2006
    • 9067

    #2
    You have setup your table to allow NULLs in that/those columns haven't you?

    What is your table structure?

    Comment

    Working...