Dear All,
I'd appreciate some help with my configuration of Slide using DB2 for the
content store.
I'm running Slide 2.1 and IBM DB2 8.1. with db2java.zip (renamed to
db2java.jar) in common/lib
I've configured a JNDI resource successfully using the following in
server.xml:
<Resource name="jdbc/mtx" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mtx">
<parameter>
<name>username</name>
<value>db2admin</value>
</parameter>
<parameter>
<name>password</name>
<value>db2admin</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>COM.ibm.db2.jdbc.app.DB2Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:db2:slide</value>
</parameter>
</ResourceParams>
and have the following for my store in Domain.xml:
<store name="db2">
<nodestore
classname="org.apache.slide.store.impl.rdbms.J2EEStore">
<parameter name="datasource">jdbc/mtx</parameter>
<parameter
name="adapter">org.apache.slide.store.impl.rdbms.DB2RDBMSAdapter</parameter>
<parameter name="compress">false</parameter>
</nodestore>
<contentstore>
<reference store="nodestore" />
</contentstore>
<securitystore>
<reference store="nodestore" />
</securitystore>
<lockstore>
<reference store="nodestore" />
</lockstore>
<revisiondescriptorsstore>
<reference store="nodestore" />
</revisiondescriptorsstore>
<revisiondescriptorstore>
<reference store="nodestore" />
</revisiondescriptorstore>
</store>
<scope match="/" store="db2"/>
I created the database tables using the supplied DB2 script.
When I run Slide it starts fine and connects to the database to setup
perfectly.
I can create new collections in Slide fine, but upon trying to create a
resource (either from a file or from string data) I get the following
error:
18-Jan-2005 12:44:53 org.apache.catalina.startup.Catalina start
INFO: Server startup in 15937 ms
http-8080-Processor25, 18-Jan-2005 13:04:01, root, PROPFIND, 207
"Multi-Status", 703 ms, /
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0620E IOException,
error reading from input stream. SQLSTATE=428A1
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_IOException(Unknown
Source)
at
COM.ibm.db2.jdbc.app.DB2PreparedStatement.loadParameters2(Unknown Source)
at
COM.ibm.db2.jdbc.app.DB2PreparedStatement.loadParameters(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown
Source)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.slide.store.impl.rdbms.CommonRDBMSAdapter.storeContent(CommonRDBMSAdapter.java:343)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(StandardRDBMSAdapter.java:1101)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisionContent(StandardRDBMSAdapter.java:1054)
at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createRevisionContent(AbstractRDBMSStore.java:827)
at
org.apache.slide.store.AbstractStore.createRevisionContent(AbstractStore.java:1347)
at
org.apache.slide.store.ExtendedStore.createRevisionContent(ExtendedStore.java:508)
at
org.apache.slide.content.ContentImpl.create(ContentImpl.java:515)
at
org.apache.slide.webdav.util.VersioningHelper.versionControl(VersioningHelper.java:306)
at
org.apache.slide.webdav.method.PutMethod.executeRequest(PutMethod.java:400)
at
org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMethod.java:405)
at
org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:155)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:141)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:536)
org.apache.slide.common.ServiceAccessException: Service
[EMAIL PROTECTED] access error :
[IBM][JDBC Driver] CLI0620E IOException, error reading from input stream.
SQLSTATE=428A1
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(StandardRDBMSAdapter.java:1404)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(StandardRDBMSAdapter.java:1103)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisionContent(StandardRDBMSAdapter.java:1054)
at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createRevisionContent(AbstractRDBMSStore.java:827)
at
org.apache.slide.store.AbstractStore.createRevisionContent(AbstractStore.java:1347)
at
org.apache.slide.store.ExtendedStore.createRevisionContent(ExtendedStore.java:508)
at
org.apache.slide.content.ContentImpl.create(ContentImpl.java:515)
at
org.apache.slide.webdav.util.VersioningHelper.versionControl(VersioningHelper.java:306)
at
org.apache.slide.webdav.method.PutMethod.executeRequest(PutMethod.java:400)
at
org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMethod.java:405)
at
org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:155)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:141)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:536)
http-8080-Processor25, 18-Jan-2005 13:04:02, root, PUT, 500 "Internal
Server Error", 1110 ms, /files/technical/slideTestFile.txt
The sample code I'm using to put the resource used the Webdav Client
library and works fine with the FileStore, just fails with the J2EEStore
and the user/role I'm using has permissions to perform the operation
Regards
Ben
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
