sqljdbc4.jar - SQL 2008 - Create database -The statement did not return a result set.

[pi4r0n]

Hello ALL

I got a problem when creating a database. When I got to this statment

statement createDatabase = null;
createDatabase = con.createStatement();

ResultSet result = null;
result = createDatabase.executeQuery("CREATE DATABASE TestDB");

I got an error

The statement did not return a result set.

There is no stac trace but I know its failing on result = createDatabase.executeQuery("CREATE DATABASE TestDB");

Can someone tell my why ?? I am sure I am missing something.

Important: this method will still create the database somehow.

    public static boolean createNewDatabase() throws SQLException, ClassNotFoundException {

        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String connectionUrl = "jdbc:sqlserver://10.10.10.10:1433; user=sa; password=password;";
        Connection con = DriverManager.getConnection(connectionUrl);

        boolean databaseStatus = false;
        String createDatabaseQuery;

        try {

            if (!(con.isClosed())) {
                Statement createDatabase = null;
                createDatabase = con.createStatement();
                
                ResultSet result = null;
                result = createDatabase.executeQuery("CREATE DATABASE TestDB");
                
                databaseStatus = true;
            }

        } catch (SQLException e) {
            /**if (e.getSQLState().equals("S0003")) {
                JOptionPane.showMessageDialog(frame, "Database TestDB already exists. Abording database deployment.");
                databaseStatus = false;
            }*/
            System.out.println(e.getMessage().toString());
        }
        return databaseStatus;
    }

[Tolls]

executeQuery.
"Executes the given SQL statement, which returns a single ResultSet object. "

It's intended for SELECT statements.

[pi4r0n]

LOL :) stupid mistake I have removed ResultSet result = null; statement :)

Thanks Tolls for you help :)

[Tolls]

Well no.
You still shouldn't be using executeQuery.
You should be using executeUpdate.