2009-01-30 09:44:06,023 CONFIG: org.jamwiki.utils.WikiLogger - JAMWiki log initialized from C:\Programme\Apache Software Foundation\Tomcat 6.0\webapps\jamwiki-war-0.6.7\WEB-INF\classes\logging.properties with pattern %t/jamwiki.log.%g 2009-01-30 09:44:06,054 WARNING: org.jamwiki.Environment - Property file C:\Programme\Apache Software Foundation\Tomcat 6.0\webapps\jamwiki-war-0.6.7\WEB-INF\classes\jamwiki.properties does not exist 2009-01-30 09:44:06,069 CONFIG: org.jamwiki.Environment - Loading properties from C:\Programme\Apache Software Foundation\Tomcat 6.0\webapps\jamwiki-war-0.6.7\WEB-INF\classes\sql.ansi.properties 2009-01-30 09:44:19,398 CONFIG: org.jamwiki.Environment - Loading properties from C:\Programme\Apache Software Foundation\Tomcat 6.0\webapps\jamwiki-war-0.6.7\WEB-INF\classes\sql.ansi.properties 2009-01-30 09:44:19,617 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: CREATE TABLE jam_virtual_wiki ( virtual_wiki_id INTEGER NOT NULL, virtual_wiki_name VARCHAR(100) NOT NULL, default_topic_name VARCHAR(200) NOT NULL, create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, CONSTRAINT jam_p_vwiki PRIMARY KEY (virtual_wiki_id), CONSTRAINT jam_u_vwiki_name UNIQUE (virtual_wiki_name) ) 2009-01-30 09:44:19,617 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: CREATE TABLE jam_wiki_user ( wiki_user_id INTEGER NOT NULL, login VARCHAR(100) NOT NULL, display_name VARCHAR(100), create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, last_login_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, create_ip_address VARCHAR(39) NOT NULL, last_login_ip_address VARCHAR(39) NOT NULL, remember_key VARCHAR(100) NOT NULL, default_locale VARCHAR(8), CONSTRAINT jam_p_wuser PRIMARY KEY (wiki_user_id) ) 2009-01-30 09:44:19,617 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: CREATE TABLE jam_wiki_user_info ( wiki_user_id INTEGER NOT NULL, login VARCHAR(100) NOT NULL, email VARCHAR(100), first_name VARCHAR(100), last_name VARCHAR(100), encoded_password VARCHAR(100) NOT NULL, CONSTRAINT jam_p_wiki_uinfo PRIMARY KEY (wiki_user_id), CONSTRAINT jam_f_wuinfo_wuser FOREIGN KEY (wiki_user_id) REFERENCES jam_wiki_user(wiki_user_id), CONSTRAINT jam_u_wuinfo_login UNIQUE (login) ) 2009-01-30 09:44:19,633 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: CREATE UNIQUE INDEX jam_u_wuser_login on jam_wiki_user (lower(login)) 2009-01-30 09:44:19,633 SEVERE: org.jamwiki.db.WikiDatabase - Unable to set up database tables java.lang.Exception: Failure while executing CREATE UNIQUE INDEX jam_u_wuser_login on jam_wiki_user (lower(login)) at org.jamwiki.db.DatabaseConnection.executeUpdate(DatabaseConnection.java:224) at org.jamwiki.db.AnsiQueryHandler.createTables(AnsiQueryHandler.java:182) at org.jamwiki.db.WikiDatabase.setup(WikiDatabase.java:487) at org.jamwiki.db.AnsiDataHandler.setup(AnsiDataHandler.java:1086) at org.jamwiki.WikiBase.reset(WikiBase.java:168) at org.jamwiki.servlets.SetupServlet.initialize(SetupServlet.java:142) at org.jamwiki.servlets.SetupServlet.handleJAMWikiRequest(SetupServlet.java:73) at org.jamwiki.servlets.JAMWikiServlet.handleRequestInternal(JAMWikiServlet.java:74) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.jamwiki.authentication.JAMWikiExceptionMessageFilter.doFilter(JAMWikiExceptionMessageFilter.java:71) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.jamwiki.authentication.JAMWikiAnonymousProcessingFilter.doFilter(JAMWikiAnonymousProcessingFilter.java:54) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jamwiki.servlets.JAMWikiFilter.doFilter(JAMWikiFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509) at java.lang.Thread.run(Unknown Source) Caused by: org.h2.jdbc.JdbcSQLException: Syntax Fehler in SQL Befehl CREATE UNIQUE INDEX JAM_U_WUSER_LOGIN ON JAM_WIKI_USER (LOWER([*]LOGIN)) ; erwartet ) Syntax error in SQL statement CREATE UNIQUE INDEX JAM_U_WUSER_LOGIN ON JAM_WIKI_USER (LOWER([*]LOGIN)) ; expected ); SQL statement: CREATE UNIQUE INDEX jam_u_wuser_login on jam_wiki_user (lower(login)) [42001-107] at org.h2.message.Message.getSQLException(Message.java:103) at org.h2.message.Message.getSQLException(Message.java:114) at org.h2.message.Message.getSyntaxError(Message.java:139) at org.h2.command.Parser.read(Parser.java:2518) at org.h2.command.Parser.parseIndexColumnList(Parser.java:726) at org.h2.command.Parser.parseCreate(Parser.java:3509) at org.h2.command.Parser.parsePrepared(Parser.java:321) at org.h2.command.Parser.parse(Parser.java:288) at org.h2.command.Parser.parse(Parser.java:260) at org.h2.command.Parser.prepareCommand(Parser.java:232) at org.h2.engine.Session.prepareLocal(Session.java:406) at org.h2.engine.Session.prepareCommand(Session.java:367) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1048) at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:114) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.jamwiki.db.DatabaseConnection.executeUpdate(DatabaseConnection.java:216) ... 55 more 2009-01-30 09:44:19,633 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_watchlist 2009-01-30 09:44:19,648 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_watchlist 2009-01-30 09:44:19,648 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_recent_change 2009-01-30 09:44:19,648 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_recent_change 2009-01-30 09:44:19,648 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_role_map 2009-01-30 09:44:19,648 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_role_map 2009-01-30 09:44:19,648 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_role 2009-01-30 09:44:19,648 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_role 2009-01-30 09:44:19,648 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_group 2009-01-30 09:44:19,648 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_group 2009-01-30 09:44:19,648 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_category 2009-01-30 09:44:19,648 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_category 2009-01-30 09:44:19,664 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_file_version 2009-01-30 09:44:19,664 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_file_version 2009-01-30 09:44:19,664 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_file 2009-01-30 09:44:19,664 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_file 2009-01-30 09:44:19,664 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: ALTER TABLE jam_topic drop constraint jam_f_topic_topicv 2009-01-30 09:44:19,664 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing ALTER TABLE jam_topic drop constraint jam_f_topic_topicv 2009-01-30 09:44:19,664 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_topic_version 2009-01-30 09:44:19,664 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_topic_version 2009-01-30 09:44:19,664 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_topic 2009-01-30 09:44:19,664 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP TABLE jam_topic 2009-01-30 09:44:19,664 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP INDEX jam_u_wuser_login on jam_wiki_user 2009-01-30 09:44:19,680 SEVERE: org.jamwiki.db.AnsiQueryHandler - Failure while executing DROP INDEX jam_u_wuser_login on jam_wiki_user 2009-01-30 09:44:19,680 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_wiki_user_info 2009-01-30 09:44:19,680 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_wiki_user 2009-01-30 09:44:19,680 INFO: org.jamwiki.db.DatabaseConnection - Executing SQL: DROP TABLE jam_virtual_wiki 2009-01-30 09:44:19,680 SEVERE: org.jamwiki.servlets.SetupServlet - Setup error java.lang.Exception: Failure while executing CREATE UNIQUE INDEX jam_u_wuser_login on jam_wiki_user (lower(login)) at org.jamwiki.db.DatabaseConnection.executeUpdate(DatabaseConnection.java:224) at org.jamwiki.db.AnsiQueryHandler.createTables(AnsiQueryHandler.java:182) at org.jamwiki.db.WikiDatabase.setup(WikiDatabase.java:487) at org.jamwiki.db.AnsiDataHandler.setup(AnsiDataHandler.java:1086) at org.jamwiki.WikiBase.reset(WikiBase.java:168) at org.jamwiki.servlets.SetupServlet.initialize(SetupServlet.java:142) at org.jamwiki.servlets.SetupServlet.handleJAMWikiRequest(SetupServlet.java:73) at org.jamwiki.servlets.JAMWikiServlet.handleRequestInternal(JAMWikiServlet.java:74) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.jamwiki.authentication.JAMWikiExceptionMessageFilter.doFilter(JAMWikiExceptionMessageFilter.java:71) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.jamwiki.authentication.JAMWikiAnonymousProcessingFilter.doFilter(JAMWikiAnonymousProcessingFilter.java:54) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jamwiki.servlets.JAMWikiFilter.doFilter(JAMWikiFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509) at java.lang.Thread.run(Unknown Source) Caused by: org.h2.jdbc.JdbcSQLException: Syntax Fehler in SQL Befehl CREATE UNIQUE INDEX JAM_U_WUSER_LOGIN ON JAM_WIKI_USER (LOWER([*]LOGIN)) ; erwartet ) Syntax error in SQL statement CREATE UNIQUE INDEX JAM_U_WUSER_LOGIN ON JAM_WIKI_USER (LOWER([*]LOGIN)) ; expected ); SQL statement: CREATE UNIQUE INDEX jam_u_wuser_login on jam_wiki_user (lower(login)) [42001-107] at org.h2.message.Message.getSQLException(Message.java:103) at org.h2.message.Message.getSQLException(Message.java:114) at org.h2.message.Message.getSyntaxError(Message.java:139) at org.h2.command.Parser.read(Parser.java:2518) at org.h2.command.Parser.parseIndexColumnList(Parser.java:726) at org.h2.command.Parser.parseCreate(Parser.java:3509) at org.h2.command.Parser.parsePrepared(Parser.java:321) at org.h2.command.Parser.parse(Parser.java:288) at org.h2.command.Parser.parse(Parser.java:260) at org.h2.command.Parser.prepareCommand(Parser.java:232) at org.h2.engine.Session.prepareLocal(Session.java:406) at org.h2.engine.Session.prepareCommand(Session.java:367) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1048) at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:114) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.jamwiki.db.DatabaseConnection.executeUpdate(DatabaseConnection.java:216) ... 55 more 2009-01-30 09:44:19,695 CONFIG: org.jamwiki.WikiConfiguration - Configuration values loaded from C:\Programme\Apache Software Foundation\Tomcat 6.0\webapps\jamwiki-war-0.6.7\WEB-INF\classes\jamwiki-configuration.xml 2009-01-30 09:44:19,711 INFO: org.jamwiki.servlets.JAMWikiServlet - Loaded page /jamwiki-war-0.6.7/en/Special:Setup (0.782 s.) 2009-01-30 09:44:19,711 INFO: org.jamwiki.servlets.JAMWikiServlet - Loaded page /jamwiki-war-0.6.7/en/Special:Setup (0.782 s.)