DDL statement when connected with MS Access DB - possible?

Hello there,

I'm just wondering if we could have the create statement when we are connected with MS Access DB.

I tried the following. I could get connected but unable to create the table.

<html>
 <head>
   <title>Welcome to the world of JDBC</title>
 </head>
 <body>
  <h2>
    <%
      try{
          String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
          String url = "jdbc:odbc:BookDb";    
          
          Class.forName(driver).newInstance();
          conn = DriverManager.getConnection(url);
          out.println("Hey dude! you are connected to the Book DB");

if (conn != null) {
             stmt = conn.createStatement();
             String publisher = "CREATE TABLE Publisher (" +
                  "PublisherName VARCHAR(50)," +
                  "AuthorId LONG VARCHAR(5))";

stmt.executeUpdate(publisher);
             out.println("Publisher table created successfully");
          }

}
       catch(Exception e) {
          System.err.println("Cannot connect to the DB");
       }
       finally {
         if (conn != null) {
            try {
              conn.close();
            }
            catch(Exception e) {
              System.err.println("Cannot close connection");   
            }
          }
       }
    %>
  </h2>
 </body>
</html>

Please advice.

Thanks.

Charles Chikito

Moved to the JDBC forum.

P.S. Doing JDBC inside a JSP?

"Chikito Charles", please check your private messages for an important administrative matter.