ето работает

try {
Class.forName("org.postgresql.Driver");
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
ResultSet rs = null;
Statement statement = null;
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:postgresql:POS", "dimo", "dimo");
statement = conn.createStatement();
String strQuery;
// strQuery = "SELECT tb_inv_header.pos_id, tb_inv_detail.invd_amount as fld_INVD_AMOUNT, tb_article.art_name as fld_ART_NAME, tb_articlegroup.grpname as fld_GRPNAME, tb_pricemodificator.prm_name as fld_PRM_NAME, tb_article.art_id as fld_ART_ID, tb_inv_detail.invd_price_per as fld_INVD_PRICE_PER, ";
//strQuery = strQuery + "tb_inv_detail.invd_price_complete as fld_INVD_PRICE_COMPLETE FROM tb_inv_header Inner Join tb_inv_detail ON tb_inv_header.invh_id = tb_inv_detail.invh_id Inner Join tb_article ON tb_inv_detail.id = tb_article.id Inner Join tb_articlegroup ON tb_article.grpid = tb_articlegroup.grpid left Join tb_pricemodificator ON tb_inv_detail.prm_id = tb_pricemodificator.prm_id";
strQuery = "SELECT art_name as fld_ART_NAME from tb_article";
System.out.println(strQuery);
rs = statement.executeQuery(strQuery);
String lang ="";

while(rs.next()){



lang = rs.getString("fld_ART_NAME");



System.out.println( " " + lang + " " );
}

} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}

а так нет:
strQuery = "SELECT tb_inv_header.pos_id, tb_inv_detail.invd_amount as fld_INVD_AMOUNT, tb_article.art_name as fld_ART_NAME, tb_articlegroup.grpname as fld_GRPNAME, tb_pricemodificator.prm_name as fld_PRM_NAME, tb_article.art_id as fld_ART_ID, tb_inv_detail.invd_price_per as fld_INVD_PRICE_PER, ";
strQuery = strQuery + "tb_inv_detail.invd_price_complete as fld_INVD_PRICE_COMPLETE FROM tb_inv_header Inner Join tb_inv_detail ON tb_inv_header.invh_id = tb_inv_detail.invh_id Inner Join tb_article ON tb_inv_detail.id = tb_article.id Inner Join tb_articlegroup ON tb_article.grpid = tb_articlegroup.grpid left Join tb_pricemodificator ON tb_inv_detail.prm_id = tb_pricemodificator.prm_id";

хотя в pgAdmine запрос дает результат!



REATE TABLE tb_article
(
id int4 NOT NULL,
art_id varchar(25) NOT NULL,
art_name varchar(150) NOT NULL,
art_comment varchar(200),
art_min_storage int4,
art_parent_id int4,
grpid int4,
art_colour varchar(150),
art_size int4,
art_check_amount bool,
art_base_article bool,
art_crea_date date,
art_user_mod int4,
art_mod_date date,
art_user_crea int4,
CONSTRAINT tb_article_pkey PRIMARY KEY (id),
CONSTRAINT fked71bc05191b4dc FOREIGN KEY (grpid)
REFERENCES tb_articlegroup (grpid) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT tb_article_art_id_key UNIQUE (art_id)
)
WITHOUT OIDS;
ALTER TABLE tb_article OWNER TO ...;


CREATE TABLE tb_inv_header
(
invh_id int8 NOT NULL,
invh_number varchar(25),
invh_crea_date timestamp,
pos_id int4 NOT NULL,
usrid int4 NOT NULL,
cus_id int4,
invh_state float8,
invh_pay_type int4,
CONSTRAINT tb_inv_header_pkey PRIMARY KEY (invh_id),
CONSTRAINT fk5b51152c211c062a FOREIGN KEY (cus_id)
REFERENCES tb_customer (cus_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_invh_pos FOREIGN KEY (pos_id)
REFERENCES tb_pos (pos_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_invh_usr FOREIGN KEY (usrid)
REFERENCES tb_user (usrid) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT tb_inv_header_invh_number_key UNIQUE (invh_number)
)
WITHOUT OIDS;
ALTER TABLE tb_inv_header OWNER TO ...;


REATE TABLE tb_package_detail
(
pad_id int4 NOT NULL,
pah_id int4 NOT NULL,
art_id int4 NOT NULL,
pad_price_portion_type float8,
pad_price_portion_amount float8,
CONSTRAINT tb_package_detail_pkey PRIMARY KEY (pad_id),
CONSTRAINT fk_pad_art_artid FOREIGN KEY (art_id)
REFERENCES tb_article (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_pad_pah_id FOREIGN KEY (pah_id)
REFERENCES tb_package_header (pah_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITHOUT OIDS;
ALTER TABLE tb_package_detail OWNER TO ...;

ето похоже глюк. (предполагаю в JDBC драйвере)
Postgres 8.1 для Windows

на Derby работает!