String sql1 = "drop table metadata";These 2 lines of command tells the database to delete the metadata table. Then, when the servlet checks if there's a table to create, it will find none, and consequently create the new table with update.
DB.executeQuery(sql1);
Saturday, August 1, 2009
Database table not updating
Earlier when I encountered this problem, I when into database directly and deleted the tables. However, when I uploaded it to the remote server, I realized that I don't have access to the remote server directly! This means I must delete the tables I want to change through java servlet. So, in the ConfigServlet.java file, under checkTables() method, which create tables if no table exist. I inserted the following code in the very beginning:
Labels:
documentation,
IAT352,
project
Subscribe to:
Post Comments (Atom)


No comments:
Post a Comment