From: | "Dave Cramer" <Dave(at)micro-automation(dot)net> |
---|---|
To: | "Rolf Schillinger" <rolf(at)sir-wum(dot)de>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: multiple resource sets |
Date: | 2001-05-03 18:20:10 |
Message-ID: | 03a501c0d3fd$b0fed050$0401a8c0@INSPIRON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Rolf,
Try this
ResultSet orderlines = _st.executeQuery();
while(orderlines.next()){
println(orderlines.get(1));
}
orderlines.close();
_st.close();
Dave
----- Original Message -----
From: "Rolf Schillinger" <rolf(at)sir-wum(dot)de>
To: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Wednesday, May 02, 2001 10:12 AM
Subject: [JDBC] multiple resource sets
> Hi,
> I`m having huge troubles using postgresql JDBC.
> I do the following:
> while (orderlines.next())
> {
> PreparedStatement as_st=db.prepareStatement("SELECT nr,beschreibung,
> beschreibung_2,preis FROM artikel where nr=?");
> System.out.println(orderlines.getRow()+" : "+orderlines.getString(2));
> }
> As result I get:
> 1 : KKSC025
> 2 : KKTO045
> which is totally okay cause the underlying table data is as follows:
> id | nr | anzahl | eht
> ------------+---------+--------+-----
> 1226969416 | KKSC025 | 22 | BU1
> 1226969416 | KKTO045 | 22 | KT
>
> So far so good.
> I know want to process the results of that orderlines query by adding:
> as_st.setString(1,orderlines.getString(2));
> as=as_st.executeQuery();
> as.close();
> to the above while loop.
> Output now looks like:
> 1 : KKSC025
> 2 : Nalo schmal 45/50 rauchbraun
> 1) is still correct while 2) has the value of as_st/as now.
> I`m getting desperate on that.
> any help would be greatly appreciated.
> thanks, Rolf
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jani Averbach | 2001-05-03 18:42:50 | A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars? |
Previous Message | Bruce Momjian | 2001-05-03 17:49:00 | Re: Returning oid or primary key |