Resultset error

nukn

New Member
I am trying to get several rows from my Progress database in a Java application via JDBC driver. The code I use in application goes as follows:

Code:
[SIZE=2]Statement getImages = con.createStatement();
[/SIZE][SIZE=2][/SIZE] 
[SIZE=2]String mySql= [/SIZE]
[LEFT][B][SIZE=2][COLOR=#7f0055]new[/COLOR][/SIZE][/B][SIZE=2] String ([/SIZE][SIZE=2][COLOR=#2a00ff]"SELECT Image.Id, Image.URL, Image.Commentary [/COLOR][/SIZE]
[SIZE=2][COLOR=#2a00ff]FROM Image, Object [/COLOR][/SIZE]
[SIZE=2][COLOR=#2a00ff]WHERE Image.ObjectId=Object.Id and Image.ObjectId='"[/COLOR][/SIZE][SIZE=2]+ObjectId+[/SIZE][SIZE=2][COLOR=#2a00ff]"'"[/COLOR][/SIZE][SIZE=2]);[/SIZE]
[SIZE=2][/SIZE] 
[SIZE=2]ResultSet r = getImages.executeQuery(mySql);[/SIZE][/LEFT]

if I run the query (with some certain value of ObjectId) in SQL Explorer, it returns correct number of rows (as may as I've inserted). But in Java application ResultSet r contains only one of these rows and apparently a random one! Had anybody encontered this, how can this be helped?
Thanks in advance.​
 
Back
Top