JSP & MySQL | Error when creating table

Question

I'm using Eclipse EE, Tomcat 6 server connected to MySQL server on win7. I was able to connect to a database through JSP and send commands like SELECT and DESCRIBE but if I try to create a table the JSP code will simply not run! Why is that? (Checked my SQL codes on the MySQL command line and it worked. )

JSP error:

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at

JSP Coding:

try // DB login
    {
        String connectionURL = "jdbc:mysql://localhost/ofir";
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        con = DriverManager.getConnection(connectionURL, "root", "");
        stmt = con.createStatement();
        connected = true;
    }
    catch(Exception ex)
    {
        out.println("Unable to connect to database.");
        connected = false;
    }
    rs = stmt.executeQuery("CREATE table users (fname varchar(50), nname varchar(20), pass varchar(50), email varchar(50), gender boolean, age int(3), region varchar(10), notes varchar(1000))"); // Line of the error

*To be noted about the code- all variables are declared globally using ' <%! '

Mecon · Accepted Answer · 2015-05-22 15:40:46Z

2

For CREATE TABLE, we have to use stmt.executeUpdate(sql) . Not stmt.executeQuery(sql)

answered May 22, 2015 at 15:40

Mecon

1,0172 gold badges7 silver badges18 bronze badges

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

3 Comments

Ofir Over a year ago

Okay, so at what situations do I need to use one of them?

Mecon Over a year ago

It retuns an int. The int represents the number of rows that were affected. But its only applicable for statements where you INSERT or UPDATE rows. For your case (CREATE Table), it will always return 0 because it didn't really change any rows. You can ignore the return value for your case.

Mecon Over a year ago

Here is the actual documentation : docs.oracle.com/javase/7/docs/api/java/sql/…

Collectives™ on Stack Overflow

JSP & MySQL | Error when creating table

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related