no result set ????

From: Morgana <fajcro_at_tin.it>
Date: Wed, 22 Oct 2003 19:31:30 GMT
Message-ID: <mWAlb.32398$e5.1139878@news1.tin.it>

Hi, i've written this code...

Statement stmt2 = db7.createStatement(); ResultSet titoloset =stmt2.executeQuery("with a as (select bla bla) select a.name from a");
while (titoloset.next())
ComboSettPubblicazioni.addItem(makeObj(titoloset.getString("cod_settore")));

In db7 there's the connection...i've used that in other queries and it is right...

I have this error : no ResultSet !!!

The query is correct... i've tried it in oracle shell... it seems that the problem is in executeQuery... it reads 'with a as...' and it doesnt' recognize it as an usually query... boh... Someone can help me ???

Morgana Received on Wed Oct 22 2003 - 14:31:30 CDT