[xwiki-users] Need help configuring xwiki for sql server; possible documentation error
I am configuring xwiki to run with sql server. The xwiki database is created, and the xwiki user is the owner of the db. I can enter records in a table I made in that db as the xwiki user. I am using the jtds driver. Here is the jtds section on the sql server config page: <property name="connection.url">jdbc:jtds:sqlserver://<server-url>:1433/XWiki;tds=8.0;lastupdatecount=true</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.SQLServerDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.mssql.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> There may be a couple of issues with this template. The first line contains <server-url>. My first run through was generating a mile long error number 11007. Near the bottom was the parse error The element type "server-url" must be terminated by the matching end-tag "</server-url>" Either the tag was put in there in error or the expectation was that the clever xwiki installer would see that as a placeholder and do something with it. I swapped in localhost, and it solved that issue. It might be worth adjusting the docs? Note I am running on the default port for sql server. After this I got errors. I compared the sql server config page with the examples (mysql, postgres etc) in the hibernate file and made two more changes. The first line loses the jtds so <property name="connection.url">jdbc:sqlserver://localhost:1433/XWiki;tds=8.0;lastupdatecount=true</property> and I added two mappings at the end (all other example dbs show these) <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> I was still getting error number 11007. I can't mine the error detail to get to a next step. It's close - the xwiki initialization seems to get into the 90% range before bombing out. The bottom level error is root cause java.sql.SQLException: No suitable driver I'm using jtds-1.3.1.jar; that's supposed to be the right one for sql server 2012. Here is the db section of the hibernate file. Note I've tried both jtds and jdbc in the first line, not sure which is correct. <property name="connection.url">jtds:sqlserver://localhost:1433/XWiki;tds=8.0;lastupdatecount=true</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.SQLServerDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.mssql.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> Here is the full error: HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL [http://localhost:8080/xwiki/bin/view/Main/] type Exception report message com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL [http://localhost:8080/xwiki/bin/view/Main/] description The server encountered an internal error that prevented it from fulfilling this request. exception javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL [http://localhost:8080/xwiki/bin/view/Main/] org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL [http://localhost:8080/xwiki/bin/view/Main/] com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:926) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause java.lang.RuntimeException: Failed to locate wiki descriptor for alias [localhost] org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:80) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47) org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48) com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause org.xwiki.wiki.manager.WikiManagerException: Failed to locate XWiki.XWikiServerClass document for wiki alias [localhost] org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:128) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140) org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146) org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47) org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48) com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause org.xwiki.query.QueryException: Exception while translating [where doc.object(XWiki.XWikiServerClass).server = :wikiAlias and doc.name like 'XWikiServer%'] XWQL query to the [hql] language. Query statement = [where doc.object(XWiki.XWikiServerClass).server = :wikiAlias and doc.name like 'XWikiServer%'] org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:130) org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72) org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140) org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146) org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47) org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48) com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.XWikiServerClass] com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:996) com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1811) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1864) com.xpn.xwiki.XWiki.getXClass(XWiki.java:6065) com.xpn.xwiki.XWiki.getClass(XWiki.java:6078) com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:497) org.xwiki.query.xwql.internal.QueryContext$PropertyInfo.isCustomMapped(QueryContext.java:153) org.xwiki.query.xwql.internal.QueryContext$ObjectInfo.isCustomMapped(QueryContext.java:122) org.xwiki.query.xwql.internal.hql.ObjectPrinter.print(ObjectPrinter.java:37) org.xwiki.query.xwql.internal.hql.Printer.print(Printer.java:70) org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:61) org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:97) org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72) org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140) org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146) org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47) org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48) com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause org.hibernate.HibernateException: Could not create a DBCP pool. There is an error in the Hibernate configuration file, please review it. com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:232) org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143) org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84) org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459) org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90) org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:259) com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:703) com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:861) com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1811) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1864) com.xpn.xwiki.XWiki.getXClass(XWiki.java:6065) com.xpn.xwiki.XWiki.getClass(XWiki.java:6078) com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:497) org.xwiki.query.xwql.internal.QueryContext$PropertyInfo.isCustomMapped(QueryContext.java:153) org.xwiki.query.xwql.internal.QueryContext$ObjectInfo.isCustomMapped(QueryContext.java:122) org.xwiki.query.xwql.internal.hql.ObjectPrinter.print(ObjectPrinter.java:37) org.xwiki.query.xwql.internal.hql.Printer.print(Printer.java:70) org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:61) org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:97) org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72) org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140) org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146) org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47) org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48) com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause java.sql.SQLException: Cannot create JDBC driver of class 'net.sourceforge.jtds.jdbc.Driver' for connect URL 'jtds:sqlserver://localhost:1433/XWiki;tds=8.0;lastupdatecount=true' org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2161) org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2033) org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:215) org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143) org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84) org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459) org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90) org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:259) com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:703) com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:861) com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1811) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1864) com.xpn.xwiki.XWiki.getXClass(XWiki.java:6065) com.xpn.xwiki.XWiki.getClass(XWiki.java:6078) com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:497) org.xwiki.query.xwql.internal.QueryContext$PropertyInfo.isCustomMapped(QueryContext.java:153) org.xwiki.query.xwql.internal.QueryContext$ObjectInfo.isCustomMapped(QueryContext.java:122) org.xwiki.query.xwql.internal.hql.ObjectPrinter.print(ObjectPrinter.java:37) org.xwiki.query.xwql.internal.hql.Printer.print(Printer.java:70) org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:61) org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:97) org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72) org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140) org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146) org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47) org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48) com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause java.sql.SQLException: No suitable driver org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2152) org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2033) org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:215) org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143) org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84) org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459) org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90) org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:259) com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:703) com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:861) com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1811) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1864) com.xpn.xwiki.XWiki.getXClass(XWiki.java:6065) com.xpn.xwiki.XWiki.getClass(XWiki.java:6078) com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:497) org.xwiki.query.xwql.internal.QueryContext$PropertyInfo.isCustomMapped(QueryContext.java:153) org.xwiki.query.xwql.internal.QueryContext$ObjectInfo.isCustomMapped(QueryContext.java:122) org.xwiki.query.xwql.internal.hql.ObjectPrinter.print(ObjectPrinter.java:37) org.xwiki.query.xwql.internal.hql.Printer.print(Printer.java:70) org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:61) org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:97) org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72) org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121) org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140) org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146) org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61) org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47) org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92) org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61) org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65) org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93) org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48) com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) note The full stack trace of the root cause is available in the Apache Tomcat/8.0.30 logs. Apache Tomcat/8.0.30 -- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
I also tried a step back, using the driver style in the sqlserver config page <property name="connection.url">jdbc:jtds:sqlserver://localhost:1433/XWiki;tds=8.0;lastupdatecount=true</property> Now the error is HTTP Status 500 - org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [init.vm] type Exception report message org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [init.vm] description The server encountered an internal error that prevented it from fulfilling this request. exception javax.servlet.ServletException: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [init.vm] org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [init.vm] org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:227) com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:361) com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:790) com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:667) com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:645) com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:623) com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:107) com.xpn.xwiki.web.XWikiAction.renderInit(XWikiAction.java:602) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:260) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getCurrentInitializerJobStatus' in class com.xpn.xwiki.api.XWiki threw exception java.lang.NullPointerException at 173:init.vm[line 1, column 26] org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:223) org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280) org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:567) org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71) org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142) org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342) org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:259) org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222) com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:361) com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:790) com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:667) com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:645) com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:623) com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:107) com.xpn.xwiki.web.XWikiAction.renderInit(XWikiAction.java:602) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:260) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) root cause java.lang.NullPointerException com.xpn.xwiki.api.XWiki.getCurrentInitializerJobStatus(XWiki.java:194) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:142) org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:539) org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:198) org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280) org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:567) org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71) org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142) org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342) org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:259) org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222) com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:361) com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:790) com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:667) com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:645) com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:623) com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:107) com.xpn.xwiki.web.XWikiAction.renderInit(XWikiAction.java:602) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:260) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) javax.servlet.http.HttpServlet.service(HttpServlet.java:622) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136) note The full stack trace of the root cause is available in the Apache Tomcat/8.0.30 logs. Apache Tomcat/8.0.30 -- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
I decided to try the Microsoft JDBC driver and had more success with that. Still curious about the issues I mentioned in the original post and about why the jtds config failed. After browsing to the xwiki page, it went to 100% progress, then down to 95% for a long time. It has added many tables to the xwiki database. Now it's sitting on a page http://localhost:8080/xwiki/bin/distribution/XWiki/Distribution?xredirect=%2... and the browser window is completely black. It's been like that for at least 90 minutes. Is it completed and just didn't draw the success page correctly? Or did it fail? I hesitate to try the main xwiki page again in case that re initialized the installation process again. -- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
It had the black screen for 8 hours or so. I tried to nav to xwiki after a few hours but nothing changed. I restarted the server in the evening and after going to xwiki it started the intialization process again and completed. Now it's going through the UI setup process. Why did it 'black out'? -- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
Oh well...exciting installation process. After completing the UI installation step,it was moving on to whatever is next, and after about 30 minutes of spinning I get a major error page: Step 5 - Report Failed to execute the [velocity] macro. Cause: [Java heap space]. Click on this message for details. java.lang.OutOfMemoryError: Java heap space I know the instructions mention being sure you have given Jave enough memory. But I have no idea how to interpret "enough" so I just tried it with the default settings. This is a vm (hypverv). Can I adjust memory in the middle of the installation? This is from the tomcat status page: JVM Free memory: 0.65 MB Total memory: 247.50 MB Max memory: 247.50 MB Memory Pool Type Initial Total Maximum Used Eden Space Heap memory 34.12 MB 68.31 MB 68.31 MB 68.31 MB (100%) Survivor Space Heap memory 4.25 MB 8.50 MB 8.50 MB 7.84 MB (92%) Tenured Gen Heap memory 85.37 MB 170.68 MB 170.68 MB 170.68 MB (100%) Code Cache Non-heap memory 2.43 MB 91.62 MB 240.00 MB 90.78 MB (37%) Compressed Class Space Non-heap memory 0.00 MB 14.37 MB 1024.00 MB 13.81 MB (1%) Metaspace Non-heap memory 0.00 MB 122.81 MB -0.00 MB 119.80 MB The 100% items don't look good. Should I double 'memory'; and can I do that via the tomcat ui midstream of this install? Or do I need to restart the install? -- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
Finally, success. Almost for certain the issue was lack of memory for tomcat. With min 512 and max 1024 xwiki is running normally. The part of this long thread that is not about tomcat memory, I'd guess, is the fact that the hibernate instructions for mssql may be incomplete, and that I couldn't get the jtds driver to work. -- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
And a recommendation - make the 'provide enough memory for tomcat' statement in the instructions a bit more explicit; possibly advise what I used, 512-1024. The out of the box tomcat memory settings are very low. Generally the xwiki setup instructions are very good. Thank you. -- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi there, I’m glad you found your problem.
On 30 Dec 2016, at 20:01, novnovice <[email protected]> wrote:
And a recommendation - make the 'provide enough memory for tomcat' statement in the instructions a bit more explicit; possibly advise what I used, 512-1024. The out of the box tomcat memory settings are very low.
Yes this is known and advertised but if we can make it more explicitly I’m all for it but we’ll need your help to tell where we should have put it. Right now we have it in 2 places: 1) in the installation page: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HHardwarean... 2) in the tomcat page: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat ("Make sure you give enough memory to Java”, with a link). Thanks -Vincent
Generally the xwiki setup instructions are very good. Thank you.
-- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server...
On 30 Dec 2016, at 20:29, Vincent Massol <[email protected]> wrote:
Hi there,
I’m glad you found your problem.
On 30 Dec 2016, at 20:01, novnovice <[email protected]> wrote:
And a recommendation - make the 'provide enough memory for tomcat' statement in the instructions a bit more explicit; possibly advise what I used, 512-1024. The out of the box tomcat memory settings are very low.
Yes this is known and advertised but if we can make it more explicitly I’m all for it but we’ll need your help to tell where we should have put it.
Right now we have it in 2 places: 1) in the installation page: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HHardwarean... 2) in the tomcat page: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat ("Make sure you give enough memory to Java”, with a link).
I’ve modified the text to: "Make sure you [[give enough memory to Java>>#HOutOfMemoryError]] since by default Tomcat is configured with not enough memory for XWiki.” on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat. Would that have helped you? Thanks -Vincent
Thanks -Vincent
Generally the xwiki setup instructions are very good. Thank you.
-- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server...
On 30 Dec 2016, at 20:31, Vincent Massol <[email protected]> wrote:
On 30 Dec 2016, at 20:29, Vincent Massol <[email protected]> wrote:
Hi there,
I’m glad you found your problem.
On 30 Dec 2016, at 20:01, novnovice <[email protected]> wrote:
And a recommendation - make the 'provide enough memory for tomcat' statement in the instructions a bit more explicit; possibly advise what I used, 512-1024. The out of the box tomcat memory settings are very low.
Yes this is known and advertised but if we can make it more explicitly I’m all for it but we’ll need your help to tell where we should have put it.
Right now we have it in 2 places: 1) in the installation page: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HHardwarean... 2) in the tomcat page: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat ("Make sure you give enough memory to Java”, with a link).
I’ve modified the text to: "Make sure you [[give enough memory to Java>>#HOutOfMemoryError]] since by default Tomcat is configured with not enough memory for XWiki.” on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat.
Would that have helped you?
Note that it’s really a minor change since if you clicked on the link you go to http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat#HOutO... which explains it already… Thanks -Vincent
Thanks -Vincent
Thanks -Vincent
Generally the xwiki setup instructions are very good. Thank you.
-- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server...
Hi and thanks for the reply. For someone like myself who is very inexperienced with configuring java and tomcat, it'd have been useful if there was a statement on the tomcat setup page here something like this: "Make sure you give enough memory to Java. The default memory settings for tomcat are too low to install or run xwiki without issues. Recommended settings are min 512 and max 1024" or something of that order. "Make sure you give enough memory to Java” was noteworthy, I wondered about it, but it didn't clue me in to the fact that out of the box tomcat defaults to way too low. -- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
On 31 Dec 2016, at 00:10, novnovice <[email protected]> wrote:
Hi and thanks for the reply.
For someone like myself who is very inexperienced with configuring java and tomcat, it'd have been useful if there was a statement on the tomcat setup page here something like this:
"Make sure you give enough memory to Java. The default memory settings for tomcat are too low to install or run xwiki without issues. Recommended settings are min 512 and max 1024"
or something of that order.
"Make sure you give enough memory to Java” was noteworthy, I wondered about it, but it didn't clue me in to the fact that out of the box tomcat defaults to way too low.
Err…. You didn’t even try to click the link? :) It’s not possible to repeat information in all places in the wiki obviously. I’m sure you can understand that. For ex you’re on tomcat but other users are on other servlet containers and if we spread out the information about there memory needs across tens of pages in the wiki, it is then very difficult to update it when memory requirements change across time and we’re sure to forget places. This is why the wiki has links… In the case at hand it’s even better because the link on the "give enough memory to Java” sentence was pointing to the troubleshooting section of the **same** page with detailed information and a link to the memory requirements page. So I’d like to improve our doc but there’s only so much we can do. The only option I can think of would be to prepare a VM/docker container with tomcat already set up but even that won’t solve all the needs since some users won’t want to run XWiki in a container. Thanks -Vincent
-- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
Oh - my mistake. First, I didn't respond to what you had asked before, and the answer is that yes the change you have made to the tomcat page would have helped an uninformed experimenter like myself; ie a person with only peripheral exposure to java/tomcat configuration. Second, for some reason I did not see the link at all - just the text - so I had not read the more detailed recommendation. Upshot is that I think you have dealt with it fine. Thank you! -- View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
On 31 Dec 2016, at 16:16, novnovice <[email protected]> wrote:
Oh - my mistake. First, I didn't respond to what you had asked before, and the answer is that yes the change you have made to the tomcat page would have helped an uninformed experimenter like myself; ie a person with only peripheral exposure to java/tomcat configuration. Second, for some reason I did not see the link at all - just the text - so I had not read the more detailed recommendation. Upshot is that I think you have dealt with it fine. Thank you!
Thanks for replying back! :) And a happy new year 2017! -Vincent
View this message in context: http://xwiki.475771.n2.nabble.com/Need-help-configuring-xwiki-for-sql-server... Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (2)
-
novnovice -
Vincent Massol