28 Dec
2016
28 Dec
'16
7:45 p.m.
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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
28 Dec
28 Dec
7:54 p.m.
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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
29 Dec
29 Dec
6:33 p.m.
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=%…
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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
30 Dec
30 Dec
6:19 a.m.
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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
6:49 a.m.
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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
7:54 p.m.
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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
8:01 p.m.
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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
8:29 p.m.
Hi there,
I’m glad you found your problem.
On 30 Dec 2016, at 20:01, novnovice
<novnovice(a)gmail.com> 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#HHardwarea…
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-serve…
8:31 p.m.
On 30 Dec 2016, at 20:29, Vincent Massol
<vincent(a)massol.net> wrote:
Hi there,
I’m glad you found your problem.
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
On 30 Dec 2016, at 20:01, novnovice
<novnovice(a)gmail.com> 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#HHardwarea…
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-serve…
8:32 p.m.
On 30 Dec 2016, at 20:31, Vincent Massol
<vincent(a)massol.net> wrote:
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#HOut…
which explains it already…
Thanks
-Vincent
On 30 Dec 2016, at 20:29, Vincent Massol <vincent(a)massol.net> wrote:
Hi there,
I’m glad you found your problem.
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? On 30 Dec 2016, at 20:01, novnovice
<novnovice(a)gmail.com> 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#HHardwarea…
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
>
> 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-serve…
31 Dec
31 Dec
12:10 a.m.
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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
9:59 a.m.
On 31 Dec 2016, at 00:10, novnovice
<novnovice(a)gmail.com> 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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
4:16 p.m.
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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
4:56 p.m.
On 31 Dec 2016, at 16:16, novnovice
<novnovice(a)gmail.com> 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-serve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
2869
days inactive
2872
days old
13 comments
2 participants
participants (2)
-
novnovice -
Vincent Massol