Hi all

			

			I want to delete all the data from more than 10 tables at a strech ie, i would like to use batch update to do this. I have table names in a string array.
			

			

			

			String tables [] = {"tab1","tab2",........};
			

			

			

			And i did something like
			

			

			

			PreparedStatement pst = con.prepareStatement("delete from ? where user_id = ?");
			

			for( int ctr = 0; ctr
			< tables.length; ctr++)
			

			{
			

			pst.setString( 1, tables[ctr]);
			

			pst.setString( 2, "userid");
			

			pst.addBatch();
			

			}
			

			pst.executeBatch();
			

			

			

			when i try to execute the above sql, I am getting SQLException, because the query is interpreted as
			

			

			

			

			delete from 'tab1' where user_id = '11';
			

			

			

			tablename is the problem , ie the single quotes. with Statement i succesfully executed the above sql but it performs poorly when compared to PreparedStatement .
			

			

			Could anyone tell how to solve the above problem.