Not able to execute the Create table sql query through java

Question

I am trying to create the table through java string but it is displaying error as table doesn't exist but when I run the same query directly on workbench it runs fine. Below is my code

String url = "jdbc:mysql://localhost:3306/" ;
String dbname = "tweetmap";
String username = "root";
String password = "root";
try
{ 
    // SQL Driver needed for connecting to Database
    Class.forName("com.mysql.jdbc.Driver");
    c = DriverManager.getConnection(url+dbname,username,password);
    c.setAutoCommit(true);
    stmt = c.createStatement();

    //Creating the Database if not Already Present
    String sql = "CREATE TABLE if not exists senti "
            + "( latitude double NULL, "
            + "longitude double NULL, "
            +  "Sentiment TEXT  NULL) ";
    stmt.executeUpdate(sql);

    if(sentiment != null){

        stmt1 = c.createStatement();    
        stmt1.executeUpdate("INSERT INTO `senti`(latitude,longitude,Sentiment) VALUE ('"+lati+"','"+longi+"','"+sentiment+"')");
        }
    }
catch(Exception e){
     e.printStackTrace();
}

I think it's bcoz u haven't specify primary key for the table & remove IF NOT EXISTS clause from the query. Try the same. — OO7
– OO7, Commented May 4, 2015 at 4:56
Please refer below link. May that help you. tutorialspoint.com/jdbc/jdbc-create-tables.htm — Pankaj K
– Pankaj K, Commented May 4, 2015 at 4:57
I have written according to this tutorial only, the thing is that when I run my query directly on workbench it works fine and there is no atrribute in my table that requires primary key — esahmo
– esahmo, Commented May 4, 2015 at 5:03

kavi temre · Accepted Answer · 2015-05-04 05:08:32Z

5

this is the problem stmt.executeUpdate(sql);

instead of executeUpdate use execute(String SQL) method.

execute(String SQL) is used for DDL/DML statement while executeUpdate(String SQL) is used only for DML operation

answered May 4, 2015 at 5:08

kavi temre

1,3212 gold badges14 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bhavin Patel · Accepted Answer · 2015-05-04 05:51:47Z

0

Best way to execute any query in JDBC is using execute() method. This method can be used for any kind of query. I hope below link will help you to understand more.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#execute(java.lang.String)

answered May 4, 2015 at 5:51

Bhavin Patel

216 bronze badges

Collectives™ on Stack Overflow

Not able to execute the Create table sql query through java

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related