<%@ page import="org.opencms.setup.*,java.util.*" session="true" %><%-- --%><%-- --%><% // next page String nextPage = "step_6_module_selection.jsp"; // previous page String prevPage = "step_3_database_selection.jsp"; CmsSetupDb db = null; boolean createDb = false; boolean createTables = false; boolean dbExists = false; boolean dropDb = false; if (Bean.isInitialized()) { String temp; Object a; if ((a = session.getAttribute("createDb")) != null) { createDb = "true".equals(a.toString()); } if (((a = session.getAttribute("createTables")) != null) && (a.toString().length() > 0)) { createTables = "true".equals(a.toString()); } else { // if not explicitly set, we will certainly create the // tables when creating a new database createTables = createDb; } if(createDb || createTables) { db = new CmsSetupDb(Bean.getWebAppRfsPath()); temp = request.getParameter("dropDb"); dropDb = (temp != null) && "Yes".equals(temp); if (Bean.getDatabase().startsWith("db2") || Bean.getDatabase().startsWith("as400")) { dbExists = true; dropDb = true; createDb = false; } /* check if database exists */ if(!dropDb) { if (Bean.getDatabase().startsWith("oracle") || Bean.getDatabase().startsWith("db2") || Bean.getDatabase().startsWith("as400")) { db.setConnection(Bean.getDbDriver(), Bean.getDbWorkConStr(), Bean.getDbConStrParams(), Bean.getDbWorkUser(), Bean.getDbWorkPwd()); } else { db.setConnection(Bean.getDbDriver(), Bean.getDbWorkConStr(), Bean.getDbConStrParams(), Bean.getDbCreateUser(), Bean.getDbCreatePwd()); } dbExists = db.noErrors(); if(dbExists) { db.closeConnection(); } else { db.clearErrors(); } } if( !dbExists || dropDb) { db.closeConnection(); if (!Bean.getDatabase().startsWith("db2") && !Bean.getDatabase().startsWith("as400")) { db.setConnection(Bean.getDbDriver(), Bean.getDbCreateConStr(), Bean.getDbConStrParams(), Bean.getDbCreateUser(), Bean.getDbCreatePwd()); } } else { if (createDb || createTables) { nextPage = "step_5_database_creation.jsp"; } } } } boolean dbError = false; boolean enableContinue = false; if(!createDb && !createTables && dbExists) { enableContinue = true; } %><%= Bean.getHtmlPart("C_HTML_START") %> Alkacon OpenCms Setup Wizard <%= Bean.getHtmlPart("C_HEAD_START") %> <%= Bean.getHtmlPart("C_STYLES") %> <%= Bean.getHtmlPart("C_STYLES_SETUP") %> <%= Bean.getHtmlPart("C_HEAD_END") %> Alkacon OpenCms Setup Wizard - Create database & tables <%= Bean.getHtmlPart("C_CONTENT_SETUP_START") %> <% if (Bean.isInitialized()) { %>
<% if (!createDb && !createTables && !dbExists) { enableContinue = true; %> <%= Bean.getHtmlPart("C_BLOCK_START", "Create Database") %>
   You have not created the Alkacon OpenCms database.
You cannot import the modules successfully without the database and tables!
<%= Bean.getHtmlPart("C_BLOCK_END") %> <% } else { if (dbExists && createTables && !dropDb && db != null) { db.closeConnection(); %> <%= Bean.getHtmlPart("C_BLOCK_START", "Create Database") %>
   An existing database has been detected. Drop it ?
 
      
<%= Bean.getHtmlPart("C_BLOCK_END") %> <% } else { if (createDb && dropDb && db != null) { // Drop Database %> <%= Bean.getHtmlPart("C_BLOCK_START", "Dropping database ...") %> <% db.closeConnection(); db.setConnection(Bean.getDbDriver(), Bean.getDbWorkConStr(), Bean.getDbConStrParams(), Bean.getDbCreateUser(), Bean.getDbCreatePwd()); db.dropDatabase(Bean.getDatabase(), Bean.getReplacer()); if (db.noErrors()) { %> <% enableContinue = true; } else { enableContinue = false; dbError = true; %> <% } %>
   Database has been successfully dropped.
  

Database could not be dropped!

<% List errors = db.getErrors(); Iterator it = errors.iterator(); while (it.hasNext()) { out.println(it.next() + "
"); out.println("-------------------------------------------" + "
"); } db.clearErrors(); %>
<%= Bean.getHtmlPart("C_BLOCK_END") %>
 
<% } if (createDb && db != null) { // Create Database %> <%= Bean.getHtmlPart("C_BLOCK_START", "Creating database ...") %> <% db.createDatabase(Bean.getDatabase(), Bean.getReplacer()); if (db.noErrors()) { %> <% enableContinue = true; } else { enableContinue = false; dbError = true; %> <% } %>
   Database has been successfully created.
  

Database could not be created!

<% List errors = db.getErrors(); Iterator it = errors.iterator(); while (it.hasNext()) { out.println(it.next() + "
"); out.println("-------------------------------------------" + "
"); } db.clearErrors(); %>
<%= Bean.getHtmlPart("C_BLOCK_END") %>
 
<% } if (db != null) { db.closeConnection(); } if (createTables && db != null) { db.setConnection(Bean.getDbDriver(), Bean.getDbWorkConStr(), Bean.getDbConStrParams(), Bean.getDbWorkUser(),Bean.getDbWorkPwd()); //Drop Tables (intentionally quiet) db.dropTables(Bean.getDatabase()); db.clearErrors(); db.closeConnection(); // reopen the connection in order to display errors db.setConnection(Bean.getDbDriver(), Bean.getDbWorkConStr(), Bean.getDbConStrParams(), Bean.getDbWorkUser(),Bean.getDbWorkPwd()); //Create Tables %> <%= Bean.getHtmlPart("C_BLOCK_START", "Creating tables ...") %> <% db.createTables(Bean.getDatabase(), Bean.getReplacer()); if(db.noErrors()) { %> <% enableContinue = true; } else { enableContinue = false; dbError = true; %> <% } %>
   Tables have been successfully created.
  

Tables could not be created!

<% List errors = db.getErrors(); Iterator it = errors.iterator(); while (it.hasNext()) { out.println(it.next() + "
"); out.println("-------------------------------------------" + "
"); } db.clearErrors(); db.closeConnection(); %>
<%= Bean.getHtmlPart("C_BLOCK_END") %> <% } } } %>
<%= Bean.getHtmlPart("C_CONTENT_END") %> <%= Bean.getHtmlPart("C_BUTTONS_START") %>
<% if (db != null) { db.closeConnection(); } if (enableContinue && !dbError) { out.println(""); } %> <%= Bean.getHtmlPart("C_BUTTONS_END") %> <% } else { %> <%= Bean.displayError("")%> <%= Bean.getHtmlPart("C_CONTENT_END") %> <% } %> <%= Bean.getHtmlPart("C_HTML_END") %>