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.
Joined: May 23, 2002
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