executing SQL query with temp tables using 1.6jdk

I created a batch to run a query that has temp tables as the below example IF OBJECT_ID ('tempdb..#TEMP1') IS NOT NULL DROP TABLE #TEMP1 select * into #TEMP1 from cutomer IF OBJECT_ID ('tempdb..#TEMP2') IS NOT NULL DROP TABLE #TEMP2 select * into #TEMP2 from shops select t1.* from #TEMP1 t1, #TEMP2 t2 where t1.id=t2.id I am using the Java code below: PreparedStatement statment = connection.prepareStatement(query); ResultSet rs = statment.executeQuery(); It is working fine when I use 1.8 JRE, but it is throwing the following exception with 1.6 and I have to use 1.6. I am using sqljdbc4.jar only. >com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.