How to create a table in MySQL when using java

Question

I'm trying to create a table in mysql through java. I'm using putty for this by the way. Here is a bit of the code I have so far but it doesn't work.

rs=s.executeQuery("CREATE TABLE test(id CHAR(2),name VARCHAR(3),PRIMARY KEY(id)); ");
while(rs.next())
{
  System.out.println(rs.getString(1));
}
catch (SQLException ex)
{
  System.out.println("SQLException:"+ ex.getMessage());
}

I believe you're using the correct API. If this doesn't work, we need to know the error to help you further. — Daniel Kaplan, Dec 18 '13 at 18:09
SQLException:Can not issue data manipulation statements with executeQuery(). s — user3103042, Dec 18 '13 at 18:09
No, it wouldn't, @user3103042. What would be useful is for you to take a little time and create an SSCCE (http://sscce.org). Once you learn to do that, you'll get more help for your questions. Good luck. — james.garriss, Dec 18 '13 at 18:14
Are you able to connect to the db ? If yes, please try with `executeUpdate` instead of `executeQuery`, if not post the rest of your code. — , Dec 18 '13 at 19:23

score 1 · Answer 1 · answered Dec 18 '13 at 18:20

1

executeQuery() is for quires (usually SELECT) that return a ResultSet.

With DML (and DDL) queries you need to use executeUpdate() method.

For more information and examples use Setting Up Tables tutorial.

answered Dec 18 '13 at 18:20

PM 77-1

12,933
21
68
111

score 0 · Answer 2 · edited May 23 '17 at 12:19

0

See this post here: Data Manipulation Statements

You should be using executeUpdate() if you wish to actually modify the database.

edited May 23 '17 at 12:19

Community

1
1

answered Dec 18 '13 at 18:14

Sean M.

118
5

score 0 · Answer 3 · answered Dec 18 '13 at 18:19

Your query is ok! But you don't get a result set! the CREATE TABLE won't give an rows or columns. You have been tricked be the documentation:

Returns: a ResultSet object that contains the data produced by the given query; never null

however

Throws: SQLException - if a database access error occurs,... the given SQL statement produces anything other than a single ResultSet object, ...

In my opinion a call of "execute" would be the proper way.

user2810910 · Answer 4 · 2013-12-18T18:41:02.973

I don't think its ever a good idea to generate your database schema via Java. Use the utility tool that comes with your database to create your schema. This way, you or anyone (such as a DBA) can create your tables, views, indexes, constraints, grant permissions, etc without having to know Java. You can even have your database utility generate an SQL script that you can run to re-generate the schema from scratch. Last point: I believe you will be better off calling your primary key test_id and making it type numberic, long, or int. this way, when you refer to it as a foreign key in another table, you will immediately know it refers back to the test table.

How to create a table in MySQL when using java

4 Answers4

Linked