Message4951

Author Lonebuddha
Recipients Lonebuddha
Date 2009-07-27.13:56:55
SpamBayes Score 0.00032208726
Marked as misclassified No
Message-id <1248703016.55.0.233103993006.issue1413@psf.upfronthosting.co.za>
In-reply-to
Content
NPE is raised if there is an array column (value is NULL) in PostgreSQL
table.

Database driver: postgresql-8.4-701.jdbc4.jar

Example:

CREATE TABLE private_info (
    _ppl_seq       INTEGER NOT NULL,
    tax_ident      VARCHAR(16) NOT NULL,
    ethnicity      VARCHAR(16)[]
);

INSERT INTO private_info (_ppl_seq,tax_ident,ethnicity) VALUES
(10,'222-22-1492',ARRAY['white']),
(11,'456-27-7645',NULL);

SELECT ethnicity FROM private_info;

Stack trace is attached.
History
Date User Action Args
2009-07-27 13:56:56Lonebuddhasetrecipients: + Lonebuddha
2009-07-27 13:56:56Lonebuddhasetmessageid: <1248703016.55.0.233103993006.issue1413@psf.upfronthosting.co.za>
2009-07-27 13:56:56Lonebuddhalinkissue1413 messages
2009-07-27 13:56:56Lonebuddhacreate