Search Postgresql Archives

pgsql exception.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
while passing util list to Postgres stored procedure getting  an exception saying
org.postgresql.util.PSQLException: Cannot cast an instance of java.util.ArrayList to type Types.ARRAY
 can you help to resolve it? its urgent

Method in Dao
public void savePerson(Person person, List<Address> addresses, List<Email> emails, List<Phone> numbers){
        call.withProcedureName("
person_save1");      
      
        Map<String, Object> out = call.execute(new PGPerson(person),addresses,null,null);
       
    }

SP in Database

CREATE OR REPLACE FUNCTION person_save(person_to_save person, addresses address[], emails email[], numbers phone[])
  RETURNS void AS
$BODY$
DECLARE
    per_id bigint;
BEGIN
IF person_to_save.id
 
 
 
IS NULL OR person_to_save.id
 
 
 
= 0 THEN
    SELECT INTO per_id nextval('people_id_seq');
    INSERT INTO person (id, first_name,last_name,middle_name) values (per_id, person_to_save.first_name, person_to_save.last_name, person_to_save.middle_name);
ELSE
    per_id := person_to_save.id
 
 
 
;
    UPDATE person SET first_name=person_to_save.first_name, last_name=person_to_save.last_name, middle_name=person_to_save.middle_name WHERE id = person_to_save.id
 
 
 
;
END IF;
IF addresses IS NOT NULL THEN
    EXECUTE person_addresses_save(per_id, addresses);
END IF;
IF emails IS NOT NULL THEN
    EXECUTE person_emails_save(per_id, emails);
END IF;
IF numbers IS NOT NULL THEN
    EXECUTE person_phones_save(per_id, numbers);
END IF;
END;$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;
ALTER FUNCTION person_save(person, address[], email[], phone[]) OWNER TO postgres;
COMMENT ON FUNCTION person_save(person, address[], email[], phone[]) IS 'Saves a person.  If the person is new they will insert or if they exist they will update.
Will do the same for the other objects also addresses, emails, phone';


exception raised is

org.postgresql.util.PSQLException: Cannot cast an instance of java.util.ArrayList to type Types.ARRAY


--
Ravi.T
BayLogic Technologies India Pvt. Ltd.
Vizag.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux