You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Mark Papiani <mp...@hotmail.com> on 2001/05/25 18:16:44 UTC

slide servlet/ mySQL startup error

Hi,


I had slide working with the file content store. I have now setup slide via 
JDBC to mySQL using the insructions and product versions as suggested at: 
http://faq.globalvision.com.au/

The connection to mySQL from the webdav servlet seems to work because after 
I start tomcat the servlet contains:

>mysql -u MYslideuser -pMYslidepass -e "select * from objects" myDB
+-------------+----------------------------------------+
| uri         | classname                              |
+-------------+----------------------------------------+
| /           | org.apache.slide.structure.SubjectNode |
| /tempaction | org.apache.slide.structure.ActionNode  |
+-------------+----------------------------------------+

tomcat output to screen at servlet start, during Dav Explorer attempted 
connect and also part of the Domain.xml are included below.

Any thoughts on what the slide tomcat error means please:

...
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-1 Flag: 0
...
Loading namespace webdav configuration
org.apache.slide.structure.ObjectNotFoundException: No object found at 
/actions
...


Thanks
Mark

--------------------------------------------------------------

>tomcat
Using classpath: 
/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/lib/ant.jar:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/lib/jasper.jar:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/lib/jaxp.jar:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/lib/parser.jar:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/lib/servlet.jar:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/lib/test:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/lib/webserver.jar:/sbcimp/run/tp/sun/jdk/v1.2.1_04/java1.2/lib/tools.jar:.:/home/papianma/webserver/lib:/home/ares_dev/ares_tree/links/java/src.jar:/home/ares_dev/ares_tree/links/jserv/lib/ApacheJServ.jar:/home/ares_dev/ares_tree/links/jsdk/lib/jsdk.jar:/home/ares_dev/ares_tree/links/JConnect/JConnect.jar:/home/ares_dev/ares_tree/lib/xalan.jar:/home/ares_dev/ares_tree/lib/xerces.jar
d556uss:papianma:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/logs> 
Starting tomcat. Check logs/tomcat.log for error messages
2001-05-25 04:50:11 - ContextManager: Adding context Ctx( /examples )
2001-05-25 04:50:11 - ContextManager: Adding context Ctx( /admin )
2001-05-25 04:50:11 - ContextManager: Adding context Ctx(  )
2001-05-25 04:50:11 - ContextManager: Adding context Ctx( /test )
2001-05-25 04:50:11 - ContextManager: Adding context Ctx( /slide )
25 May 2001 16:50:13 - INFO - Initializing Domain
25 May 2001 16:50:14 - INFO - Domain configuration : 
{org.apache.slide.security=true}
25 May 2001 16:50:14 - INFO - Initializing namespace : webdav
25 May 2001 16:50:14 - INFO - Loading namespace definition
25 May 2001 16:50:15 - INFO - Registering Data Source name memory of class 
class org.apache.slide.store.StandardStore with parameters {} on scope /
25 May 2001 16:50:15 - INFO - Initializing service 
org.apache.slide.store.StandardStore@16abc5b
25 May 2001 16:50:16 - INFO - Loading namespace webdav parameters
25 May 2001 16:50:16 - INFO - Loading namespace webdav base data
WARNING: No active transaction
WARNING: No active transaction
WARNING: No active transaction
25 May 2001 16:50:17 - INFO - Loading object /
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-1 Flag: 0
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-2 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-3 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-4 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-5 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-6 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-7 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-8 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-9 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-10 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-11 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-12 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-13 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-14 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-15 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-16 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-17 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-18 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-19 Flag: 2097152
Enlist error(Transaction 1 in main) = -3  
slidestore.reference.JDBCDescriptorsStore@9798fb Branch: 
main-990805817880-1-20 Flag: 2097152
25 May 2001 16:50:18 - WARNING - 
org.apache.slide.common.ServiceAccessException
25 May 2001 16:50:18 - INFO - Namespace base configuration was already done 
before
25 May 2001 16:50:18 - INFO - Loading namespace webdav configuration
org.apache.slide.structure.ObjectNotFoundException: No object found at 
/actions
        at java.lang.Throwable.fillInStackTrace(Native Method)
        at java.lang.Throwable.fillInStackTrace(Compiled Code)
        at java.lang.Throwable.<init>(Compiled Code)
        at java.lang.Exception.<init>(Compiled Code)
        at 
org.apache.slide.common.SlideException.<init>(SlideException.java:95)
        at 
org.apache.slide.structure.StructureException.<init>(StructureException.java:86)
        at 
org.apache.slide.structure.ObjectNotFoundException.<init>(ObjectNotFoundException.java:87)
        at slidestore.reference.JDBCDescriptorsStore.retrieveObject(Compiled 
Code)
        at 
org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:170)
        at 
org.apache.slide.common.NamespaceConfig.getActionNode(NamespaceConfig.java:1031)
        at 
org.apache.slide.common.NamespaceConfig.initializeNamespaceConfig(Compiled 
Code)
        at 
org.apache.slide.common.Namespace.loadConfiguration(Namespace.java:670)
        at org.apache.slide.common.Domain.initNamespace(Domain.java:580)
        at org.apache.slide.common.Domain.init(Compiled Code)
        at 
org.apache.slide.manager.ManagerServlet.init(ManagerServlet.java:332)
        at javax.servlet.GenericServlet.init(GenericServlet.java:258)
        at 
org.apache.tomcat.core.ServletWrapper.doInit(ServletWrapper.java:317)
        at org.apache.tomcat.core.Handler.init(Handler.java:215)
        at org.apache.tomcat.core.ServletWrapper.init(Compiled Code)
        at 
org.apache.tomcat.context.LoadOnStartupInterceptor.contextInit(Compiled 
Code)
        at org.apache.tomcat.core.ContextManager.initContext(Compiled Code)
        at org.apache.tomcat.core.ContextManager.init(Compiled Code)
        at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:195)
        at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
2001-05-25 04:50:19 - PoolTcpConnector: Starting HttpConnectionHandler on 
9058
2001-05-25 04:50:19 - PoolTcpConnector: Starting Ajp12ConnectionHandler on 
9059




I then get the following logged by tomcat when I try and connect Dav 
Explorer to the slide servlet:




jakarta-tomcat-3.2.1/logs> #about to try and connect Dav Explorer
ln4d556uss:papianma:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/logs>
ln4d556uss:papianma:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/logs>
ln4d556uss:papianma:/home/papianma/cmd/tomcat/jakarta-tomcat-3.2.1/logs> 
java.lang.NullPointerException
        at 
org.apache.slide.common.NamespaceConfig.getParameter(NamespaceConfig.java:528)
        at 
org.apache.slide.webdav.method.WebdavMethod.isMsProprietarySupport(WebdavMethod.java:571)
        at 
org.apache.slide.webdav.method.PropFindMethod.parseRequest(Compiled Code)
        at 
org.apache.slide.webdav.method.WebdavMethod.run(WebdavMethod.java:322)
        at 
org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:208)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
        at org.apache.tomcat.core.Handler.service(Handler.java:286)
        at 
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
        at 
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
        at 
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
        at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
        at org.apache.tomcat.service.TcpWorkerThread.runIt(Compiled Code)
        at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(Compiled 
Code)
        at java.lang.Thread.run(Thread.java:485)
25 May 2001 17:03:11 - WARNING - Internal Server Error
Internal Server Error
org.apache.slide.webdav.WebdavException: Internal Server Error
        at java.lang.Throwable.fillInStackTrace(Native Method)
        at java.lang.Throwable.fillInStackTrace(Compiled Code)
        at java.lang.Throwable.<init>(Compiled Code)
        at java.lang.Exception.<init>(Compiled Code)
        at 
org.apache.slide.common.SlideException.<init>(SlideException.java:95)
        at 
org.apache.slide.webdav.WebdavException.<init>(WebdavException.java:101)
        at 
org.apache.slide.webdav.WebdavException.<init>(WebdavException.java:111)
        at 
org.apache.slide.webdav.method.WebdavMethod.run(WebdavMethod.java:337)
        at 
org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:208)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
        at org.apache.tomcat.core.Handler.service(Handler.java:286)
        at 
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
        at 
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
        at 
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
        at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
        at org.apache.tomcat.service.TcpWorkerThread.runIt(Compiled Code)
        at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(Compiled 
Code)
        at java.lang.Thread.run(Thread.java:485)
25 May 2001 17:03:11 - INFO - PROPFIND (time: 207 ms) URI = /



Domain.xml:
-----------


    <definition>

      <store name="memory">
        <nodestore classname="slidestore.reference.JDBCDescriptorsStore">
         <parameter name="driver">org.gjt.mm.mysql.Driver</parameter>
         <parameter 
name="url">mysql://localhost:3306/myDB?user=MYslideuser&amp;password=MYslidepass</parameter>
         <!-- parameter 
name="url">jdbc:mysql://localhost:3306/myDB?user=MYslideuser&amp;password=MYslidepass</parameter
-->
         <!--parameter name="user">sa</parameter -->
         <!-- parameter name="password"></parameter-->
         <parameter name="jdbcversion">1</parameter>
        </nodestore>
        <securitystore>
          <reference store="nodestore" />
        </securitystore>
        <lockstore>
          <reference store="nodestore" />
        </lockstore>
        <revisiondescriptorsstore>
          <reference store="nodestore" />
        </revisiondescriptorsstore>
        <revisiondescriptorstore>
          <reference store="nodestore" />
        </revisiondescriptorstore>

        <contentstore classname="slidestore.reference.JDBCContentStore">
         <parameter name="driver">org.gjt.mm.mysql.Driver</parameter>
         <parameter 
name="url">mysql://localhost:3306/myDB?user=MYslideuser&amp;password=MYslidepass</parameter>
         <!-- parameter 
name="url">jdbc:mysql://localhost:3306/myDB?user=MYslideuser&amp;password=MYslidepass</parameter 
-->
         <!-- parameter name="user">sa</parameter -->
         <!-- parameter name="password"></parameter -->
         <parameter name="jdbcversion">1</parameter>
        </contentstore>

        <!-- contentstore classname="slidestore.reference.FileContentStore">
          <parameter name="rootpath">files</parameter>
        </contentstore -->

      </store>

      <scope match="/" store="memory" />

    </definition>


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


Re: slide servlet/ mySQL startup error

Posted by Remy Maucherat <re...@apache.org>.
> Hi,
>
>
> I had slide working with the file content store. I have now setup slide
via
> JDBC to mySQL using the insructions and product versions as suggested at:
> http://faq.globalvision.com.au/
>
> The connection to mySQL from the webdav servlet seems to work because
after
> I start tomcat the servlet contains:
>
> >mysql -u MYslideuser -pMYslidepass -e "select * from objects" myDB
> +-------------+----------------------------------------+
> | uri         | classname                              |
> +-------------+----------------------------------------+
> | /           | org.apache.slide.structure.SubjectNode |
> | /tempaction | org.apache.slide.structure.ActionNode  |
> +-------------+----------------------------------------+
>
> tomcat output to screen at servlet start, during Dav Explorer attempted
> connect and also part of the Domain.xml are included below.
>
> Any thoughts on what the slide tomcat error means please:
>
> ...
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@9798fb Branch:
> main-990805817880-1-1 Flag: 0
> ...
> Loading namespace webdav configuration
> org.apache.slide.structure.ObjectNotFoundException: No object found at
> /actions
> ...

All the errors here are transaction related. I think you're using a version
of MySQL which does not support transactions. If that's the case, you should
use the MySQL specific stores (which are direct extensions of the standard
JDBC store, except they ignore SQL exceptions when doing transaction
operations on the connection).

Remy