Hi, I created few StringBuffer for my queryString: StringBuffer sb = new StringBuffer(500); StringBuffer sb1 = new StringBuffer(500); StringBuffer sb2 = new StringBuffer(500); StringBuffer sb3 = new StringBuffer(500); And then executing these query as follows: stmt.executeQuery(sb1.toString()); stmt.executeQuery(sb2.toString()); stmt.executeQuery(sb3.toString()); rs = stmt.executeQuery(sb.toString()); I am trying to create a temp table by the sb1 and updating the temp table by sb2 and sb3. Finally I am executing the sb. I am not sure whether I am able to do this? Is there any one can help??
Creating a table, updating it, and querying it are all SQL operations. Therefore, yes, you can do it with JDBC. The tricky part is putting the right SQL into those StringBuffers.
Nazmul Bhuiyan
Greenhorn
Joined: May 23, 2002
Posts: 17
posted
0
Yes I got the right SQL and is running ok in the database properly. But when I am running it through JDBC then I am getting null result set. What I did is: 1. Create the temp table by one sql 2. Insert date by another sql 3. and then update that table couple of times by different SQLs 4. Then select * from that temp table I executed query 1, 2, 3. When I tried to executeed query 4 and I am getting the resultSet null. Please help
0
