dimanche 8 mars 2015

SELECT INTO statement not working in java program



So I'm trying to execute a SELECT INTO statement in java like this:



stmt.executeUpdate("SELECT * INTO SORTING FROM MESSAGES");


It gives me the error message Statement.executeUpdate() cannot be called with a statement that returns a ResultSet.


How am I supposed to execute a SELECT INTO statement? I have tried executeQuery and that doesnt work.




Aucun commentaire:

Enregistrer un commentaire