[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slide-user
Subject:    Re: Unable to connect to Oracle database
From:       Jagadesh Nandasamy <jaggi () eself ! com>
Date:       2002-04-30 13:22:36
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi Russ,
        I have attached the domain.xml and slide oracle.sql file that i 
have used.
        and also i am using oracle8.1.5 ,  classes12.zip.
        It is working fine for me.
        I would like to know a few things,

         1>  Are you getting this error even when you try to add a URI. 
ies /action/node1/node2...
          2> If you are getting this error (ie. When you try to add a 
file the system
                console shown a bunch of WARNINGS and the transactions 
are rolled back)
                 May be it is due that the size of the file is larger, 
try uploading a file that is
                 about 1kb or less and gradually increase the size and 
see if it works.
                 if this works then the problem is in oracle 
configuration set the file upload size in
                  oracle (i am not sure how this is done :-( ????) to 
some larger size .....

         Hope this helps....
-Jaggi

Russ Leong wrote:

>Hi,
>    the database is definately started as I connect to it using SQL*Plus.
>
>    I tried using the SimpleLogger and set the logger level to 7(debug
>level) and saw some exception. I am not sure if they are related to the
>reason why I can't seem to connect to the database. I would think I can
>ignore them because I get the similar exceptions even when I init the domain
>with the original unchanged Domain.xml, the only difference is the stores
>used,  JDBC and memory store. Can someone verify this? Basically the
>exceptions are reported in the following order when Logging was set to debug
>level when I used JDBCDescriptorsStore and filesystem for contentstore:
>---------------------------------------------------------------------------
>-- org.apache.slide.common.SlideException - DEBUG -
>   at
>org.apache.slide.common.Namespace.initializeServices(Namespace.java:446)
>   at org.apache.slide.common.Namespace.loadDefinition(Namespace.java:718)
>
>-- org.apache.slide.common.SlideException - DEBUG -
>org.apache.slide.structure.ObjectNotFoundException: No object found at
>/users
> at
>slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor
>e.java:584)
> at
>org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:171)
>
>-- org.apache.slide.common.SlideException - DEBUG -
>org.apache.slide.structure.ObjectNotFoundException: No object found at
>/users/root
> at
>slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor
>e.java:584)
> at
>org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:171)
>
>-- org.apache.slide.common.SlideException - DEBUG -
>org.apache.slide.structure.ObjectNotFoundException: No object found at
>/users/guest
> at
>slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor
>e.java:584)
> at
>org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:171)
>
>-- org.apache.slide.common.SlideException - DEBUG -
>org.apache.slide.structure.ObjectNotFoundException: No object found at
>/actions
> at
>slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor
>e.java:584)
> at
>org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:171)
>
>---------------------------------------------------------------------------
>    I think the ObjectNotFoundExceptions are acceptable errors since I only
>created the tables and not inserted any data. But what is the first
>SlideException about? On checking the database tables, I was surprised to
>find some data inserted into OBJECTS(5 rows), PERMISSIONS(1 row) and
>CHILDREN(4 rows) tables. Does this mean the database connection was
>successful?
>    If yes then why does it report "org.apache.slide.store.StandardStore -
>INFO - Delisting service slidestore.reference.JDBCDescriptorsStore@f5824
>from active transaction with failure" during initialization? And why do I
>get "WARNING - No active transaction" when I try to create something with
>Structure class?
>
>    I hope someone can  help me as I am trying hard to read and understand
>the documents and going through the mailing list archive but I seem to be
>missing something out.
>
>Russ
>
>
>
>
>
>
>----- Original Message -----
>From: "Charles" <charles@eself.com>
>To: "Slide Users Mailing List" <slide-user@jakarta.apache.org>
>Sent: Tuesday, April 30, 2002 2:51 PM
>Subject: RE: Unable to connect to Oracle database
>
>
>>hi russ
>>everything looks to be ok. make sure your database is started and running
>>that is the oracle started or not. make sure it is started.
>>
>>charles
>>
>>-----Original Message-----
>>From: Russ Leong [mailto:russ@kikuze.com]
>>Sent: Tuesday, April 30, 2002 7:59 AM
>>To: Slide Users Mailing List
>>Subject: Re: Unable to connect to Oracle database
>>
>>
>>Hi,
>>    the problem I am facing is that it appears to me that the connection
>>
>to
>
>>the database cannot be establish because of the following lines shown
>>
>during
>
>>the initialization.
>>
>>
>>slidestore.reference.JDBCDescriptorsStore - INFO - Connecting to
>>"jdbc:oracle:thin:@192.168.42.8:1521:pm2" as user "pm2"
>>org.apache.slide.store.StandardStore - INFO - Delisting service
>>slidestore.reference.JDBCDescriptorsStore@f5824 from active transaction
>>
>with
>
>>failure
>>org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
>>Transaction 1 xid ApplicationServerThread-1020132947506-1- in thread
>>ApplicationServerThread
>>org.apache.slide.store.StandardStore - INFO - Delisting service
>>slidestore.reference.JDBCDescriptorsStore@f5824 from active transaction
>>
>with
>
>>failure
>>
>>
>>The connection seems to have rolled back? And also because after
>>initialization when I try to eg. add a file. The message "WARNING - No
>>active transaction" is displayed. Leading me to think that the connection
>>failed when I looked at the initialization logs in detail. I have tried
>>
>with
>
>>both classes12 and classes111 but both gave me the same results. I
>>appreciate if someone can shed some light on this. Thanks.
>>
>>Russ
>>
>>
>>----- Original Message -----
>>From: "Jagadesh Nandasamy" <jaggi@eself.com>
>>To: "Slide Users Mailing List" <slide-user@jakarta.apache.org>
>>Sent: Monday, April 29, 2002 6:01 PM
>>Subject: Re: Unable to connect to Oracle database
>>
>>
>>>Hi Russ,
>>>
>>>     Would like to know at what point your system is complaining,
>>>your configuration and initialization seems to be perfect...
>>>what version of oracle JDBC driver you are using
>>>if you are using classes111 try using classes12
>>>
>>>-Jaggi
>>>
>>>Russ Leong wrote:
>>>
>>>>Hi everyone,
>>>>   I have been trying to connect to my database with no success. I am
>>>>
>>sure
>>
>>>>that the database connection parameters are correct, and since there
>>>>
>were
>
>>no
>>
>>>>complains that means the Oracle driver was successfully loaded. I am
>>>>
>>running
>>
>>>>Orion server on my local whereas Oracle 8.1.5 DB is on another machine
>>>>
>on
>
>>my
>>
>>>>network. I have also attached the portion of my domain.xml which
>>>>
>defines
>
>>my
>>
>>>>store setup
>>>>
>>---------------------------------------------------------------------------
>>-
>>
>>>>---------
>>>>
>>C:\project\j2ee\home>java -Dproject.properties=C:\project\j2ee\home\printmg
>>r
>>
>>>>.properties  -jar C:\project\j2ee\home\orion.jar
>>>>Oracle9iAS (1.0.2.2) Containers for J2EE initialized
>>>>29 Apr 2002 16:28:03 - org.apache.slide.common.Domain - INFO -
>>>>
>>Initializing
>>
>>>>Domain
>>>>29 Apr 2002 16:28:03 - org.apache.slide.common.Domain - INFO - Domain
>>>>configuration : {org.apache.slide.security=true}
>>>>29 Apr 2002 16:28:03 - org.apache.slide.common.Domain - INFO -
>>>>
>>Initializing
>>
>>>>namespace : filesystem
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO -
>>>>
>Loading
>
>>>>namespace definition
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO - Node
>>>>store: slidestore.reference.JDBCDescriptorsStore
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO -
>>>>
>>Security
>>
>>>>store references nodestore
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO - Lock
>>>>
>>store
>>
>>>>store references nodestore
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO -
>>>>
>>Revision
>>
>>>>descriptors store references nodestore
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO -
>>>>
>>Revision
>>
>>>>descriptor store references nodestore
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO -
>>>>
>Content
>
>>>>store: slidestore.reference.FileContentStore
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO -
>>>>Registering Store jdbc of class class
>>>>
>>org.apache.slide.store.StandardStore
>>
>>>>with parameters {} on scope /
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO -
>>>>Initializing Store jdbc(org.apache.slide.store.StandardStore)
>>>>29 Apr 2002 16:28:04 - slidestore.reference.JDBCDescriptorsStore -
>>>>
>INFO -
>
>>>>Loading and registering driver: oracle.jdbc.driver.OracleDriver
>>>>29 Apr 2002 16:28:04 - INFO - FileContentStore rootpath:
>>>>C:\project\j2ee\home\apps\printmgr\web\pm\facado\images\filestore
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO -
>>>>
>Loading
>
>>>>namespace filesystem parameters
>>>>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO -
>>>>
>Loading
>
>>>>namespace filesystem base data
>>>>29 Apr 2002 16:28:04 - slidestore.reference.JDBCDescriptorsStore -
>>>>
>INFO -
>
>>>>Connecting to "jdbc:oracle:thin:@192.168.42.8:1521:pm2" as user "p
>>>>m2"
>>>>29 Apr 2002 16:28:06 - org.apache.slide.store.StandardStore - INFO -
>>>>Delisting service slidestore.reference.JDBCDescriptorsStore@63cd51 from
>>>>active transaction with failure
>>>>29 Apr 2002 16:28:06 -
>>>>org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
>>>>Transaction 1 xid ApplicationServerThread-1020
>>>>068884612-1- in thread ApplicationServerThread
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.Namespace - INFO - Init
>>>>namespace filesystem configuration
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.Namespace - INFO -
>>>>
>Import
>
>>>>data into namespace filesystem
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Loading object /
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Loading object /users
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Object already exists at /users
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Loading object /actions
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Object already exists at /actions
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Loading object /actions/create
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Object already exists at /actions/create
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Loading object /actions/read
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Object already exists at /actions/read
>>>>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Loading object /actions/write
>>>>29 Apr 2002 16:28:07 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Object already exists at /actions/write
>>>>29 Apr 2002 16:28:07 - org.apache.slide.common.XMLUnmarshaller - INFO -
>>>>Loading object /
>>>>29 Apr 2002 16:28:07 - org.apache.slide.common.Namespace - INFO -
>>>>
>Finish
>
>>>>init namespace filesystem configuration
>>>>29 Apr 2002 16:28:07 - org.apache.slide.common.Namespace - INFO -
>>>>
>Loading
>
>>>>namespace filesystem configuration
>>>>29 Apr 2002 16:28:07 - org.apache.slide.common.Domain - INFO -
>>>>
>Namespace
>
>>>>configuration complete
>>>>
>>>>
>>>>
>>>><definition>
>>>>   <store name="jdbc">
>>>>       <nodestore
>>>>
>classname="slidestore.reference.JDBCDescriptorsStore">
>
>>>>           <parameter
>>>>name="driver">oracle.jdbc.driver.OracleDriver</parameter>
>>>>           <parameter
>>>>name="url">oracle:thin:@192.168.42.8:1521:pm2</parameter>
>>>>           <parameter name="user">pm2</parameter>
>>>>           <parameter name="password">pm2</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.FileContentStore">
>
>>>>           <parameter
>>>>name="rootpath">C:\temp\repository\filestore</parameter>
>>>>           <parameter name="version">true</parameter>
>>>>       </contentstore>
>>>>   </store>
>>>>   <scope match="/" store="jdbc" />
>>>></definition>
>>>>
>>---------------------------------------------------------------------------
>>-
>>
>>>>---------
>>>>
>>>>Can someone tell me what am I doing wrong here? Thank you very much.
>>>>
>>>>Russ
>>>>
>>>>
>>>>--
>>>>To unsubscribe, e-mail:
>>>>
>><mailto:slide-user-unsubscribe@jakarta.apache.org>
>>
>>>>For additional commands, e-mail:
>>>>
>><mailto:slide-user-help@jakarta.apache.org>
>>
>>>>
>>>>
>>>
>>>
>>>--
>>>To unsubscribe, e-mail:
>>>
>><mailto:slide-user-unsubscribe@jakarta.apache.org>
>>
>>>For additional commands, e-mail:
>>>
>><mailto:slide-user-help@jakarta.apache.org>
>>
>>
>>--
>>To unsubscribe, e-mail:
>>
><mailto:slide-user-unsubscribe@jakarta.apache.org>
>
>>For additional commands, e-mail:
>>
><mailto:slide-user-help@jakarta.apache.org>
>
>>
>>
>>--
>>To unsubscribe, e-mail:
>>
><mailto:slide-user-unsubscribe@jakarta.apache.org>
>
>>For additional commands, e-mail:
>>
><mailto:slide-user-help@jakarta.apache.org>
>
>
>--
>To unsubscribe, e-mail:   <mailto:slide-user-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: <mailto:slide-user-help@jakarta.apache.org>
>
>
>


[Attachment #5 (text/html)]

<html>
<head>
</head>
<body>
Hi Russ,<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; I have attached the domain.xml and slide \
oracle.sql file that i have used.<br>
&nbsp; &nbsp; &nbsp; &nbsp; and also i am using oracle8.1.5 , \
&nbsp;classes12.zip.<br> &nbsp; &nbsp; &nbsp; &nbsp; It is working fine for me.<br>
&nbsp; &nbsp; &nbsp; &nbsp; I would like to know a few things,<br>
<br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&gt; &nbsp;Are you getting this error even when \
you try to add a URI.  ies /action/node1/node2...<br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&gt; If you are getting this error (ie. When you \
try to add a file the system<br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console shown a bunch of \
WARNINGS and the transactions are rolled back)<br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;May be it is due that \
the size of the file is larger, try uploading a file that is<br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;about 1kb or less and \
gradually increase the size and see if it works.<br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if this works then the \
problem is in oracle configuration set the file upload size in<br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; oracle (i am not sure \
how this is done<span -moz-smiley="s2"><span>  :-( </span></span>????) to some larger \
size .....<br> <br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hope this helps....<br>
-Jaggi<br>
<br>
Russ Leong wrote:<br>
<blockquote type="cite" cite="mid:002d01c1f03a$8d4cbaf0$342aa8c0@russ">
  <pre wrap="">Hi,<br>    the database is definately started as I connect to it using \
SQL*Plus.<br><br>    I tried using the SimpleLogger and set the logger level to \
7(debug<br>level) and saw some exception. I am not sure if they are related to \
the<br>reason why I can't seem to connect to the database. I would think I \
can<br>ignore them because I get the similar exceptions even when I init the \
domain<br>with the original unchanged Domain.xml, the only difference is the \
stores<br>used,  JDBC and memory store. Can someone verify this? Basically \
the<br>exceptions are reported in the following order when Logging was set to \
debug<br>level when I used JDBCDescriptorsStore and filesystem for \
contentstore:<br>---------------------------------------------------------------------------<br>-- \
org.apache.slide.common.SlideException - DEBUG -<br>   \
at<br>org.apache.slide.common.Namespace.initializeServices(Namespace.java:446)<br>   \
at org.apache.slide.common.Namespace.loadDefinition(Name space.java:718)<br><br>-- \
org.apache.slide.common.SlideException - DEBUG \
-<br>org.apache.slide.structure.ObjectNotFoundException: No object found \
at<br>/users<br> at<br>slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor<br>e.java:584)<br> \
at<br>org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:171)<br><br>-- \
org.apache.slide.common.SlideException - DEBUG \
-<br>org.apache.slide.structure.ObjectNotFoundException: No object found \
at<br>/users/root<br> \
at<br>slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor<br>e.java:584)<br> \
at<br>org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:171)<br><br>-- \
org.apache.slide.common.SlideException - DEBUG \
-<br>org.apache.slide.structure.ObjectNotFoundException: No object found \
at<br>/users/guest<br> \
at<br>slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor<br>e.java:584)<br> \
at<br>org.apache.slide.store.StandardStore.retrieveO \
bject(StandardStore.java:171)<br><br>-- org.apache.slide.common.SlideException - \
DEBUG -<br>org.apache.slide.structure.ObjectNotFoundException: No object found \
at<br>/actions<br> at<br>slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor<br>e.java:584)<br> \
at<br>org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:171)<br>< \
br>---------------------------------------------------------------------------<br>    \
I think the ObjectNotFoundExceptions are acceptable errors since I only<br>created \
the tables and not inserted any data. But what is the first<br>SlideException about? \
On checking the database tables, I was surprised to<br>find some data inserted into \
OBJECTS(5 rows), PERMISSIONS(1 row) and<br>CHILDREN(4 rows) tables. Does this mean \
the database connection was<br>successful?<br>    If yes then why does it report \
"org.apache.slide.store.StandardStore -<br>INFO - Delisting service <a \
class="moz-txt-link-abbreviated" href="mailto:slid \
estore.reference.JDBCDescriptorsStore@f5824">slidestore.reference.JDBCDescriptorsStore@f5824</a><br>from \
active transaction with failure" during initialization? And why do I<br>get "WARNING \
- No active transaction" when I try to create something with<br>Structure \
class?<br><br>    I hope someone can  help me as I am trying hard to read and \
understand<br>the documents and going through the mailing list archive but I seem to \
be<br>missing something out.<br><br>Russ<br><br><br><br><br><br><br>----- Original \
Message -----<br>From: "Charles" <a class="moz-txt-link-rfc2396E" \
href="mailto:charles@eself.com">&lt;charles@eself.com&gt;</a><br>To: "Slide Users \
Mailing List" <a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user@jakarta.apache.org">&lt;slide-user@jakarta.apache.org&gt;</a><br>Sent: \
Tuesday, April 30, 2002 2:51 PM<br>Subject: RE: Unable to connect to Oracle \
database<br><br><br></pre>  <blockquote type="cite">
    <pre wrap="">hi russ<br>everything looks to be ok. make sure your database is \
started and running<br>that is the oracle started or not. make sure it is \
started.<br><br>charles<br><br>-----Original Message-----<br>From: Russ Leong [<a \
class="moz-txt-link-freetext" \
href="mailto:russ@kikuze.com">mailto:russ@kikuze.com</a>]<br>Sent: Tuesday, April 30, \
2002 7:59 AM<br>To: Slide Users Mailing List<br>Subject: Re: Unable to connect to \
Oracle database<br><br><br>Hi,<br>    the problem I am facing is that it appears to \
me that the connection<br></pre>  </blockquote>
    <pre wrap=""><!---->to<br></pre>
    <blockquote type="cite">
      <pre wrap="">the database cannot be establish because of the following lines \
shown<br></pre>  </blockquote>
      <pre wrap=""><!---->during<br></pre>
      <blockquote type="cite">
        <pre wrap="">the \
initialization.<br><br><br>slidestore.reference.JDBCDescriptorsStore - INFO - \
Connecting to<br><a class="moz-txt-link-rfc2396E" \
href="mailto:jdbc:oracle:thin:@192.168.42.8:1521:pm2">"jdbc:oracle:thin:@192.168.42.8:1521:pm2"</a> \
as user "pm2"<br>org.apache.slide.store.StandardStore - INFO - Delisting \
service<br><a class="moz-txt-link-abbreviated" \
href="mailto:slidestore.reference.JDBCDescriptorsStore@f5824">slidestore.reference.JDBCDescriptorsStore@f5824</a> \
from active transaction<br></pre>  </blockquote>
        <pre wrap=""><!---->with<br></pre>
        <blockquote type="cite">
          <pre wrap="">failure<br>org.apache.slide.transaction.SlideTransactionManager \
- INFO - Rollback<br>Transaction 1 xid ApplicationServerThread-1020132947506-1- in \
thread<br>ApplicationServerThread<br>org.apache.slide.store.StandardStore - INFO - \
Delisting service<br><a class="moz-txt-link-abbreviated" \
href="mailto:slidestore.reference.JDBCDescriptorsStore@f5824">slidestore.reference.JDBCDescriptorsStore@f5824</a> \
from active transaction<br></pre>  </blockquote>
          <pre wrap=""><!---->with<br></pre>
          <blockquote type="cite">
            <pre wrap="">failure<br><br><br>The connection seems to have rolled back? \
And also because after<br>initialization when I try to eg. add a file. The message \
"WARNING - No<br>active transaction" is displayed. Leading me to think that the \
connection<br>failed when I looked at the initialization logs in detail. I have \
tried<br></pre>  </blockquote>
            <pre wrap=""><!---->with<br></pre>
            <blockquote type="cite">
              <pre wrap="">both classes12 and classes111 but both gave me the same \
results. I<br>appreciate if someone can shed some light on this. \
Thanks.<br><br>Russ<br><br><br>----- Original Message -----<br>From: "Jagadesh \
Nandasamy" <a class="moz-txt-link-rfc2396E" \
href="mailto:jaggi@eself.com">&lt;jaggi@eself.com&gt;</a><br>To: "Slide Users Mailing \
List" <a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user@jakarta.apache.org">&lt;slide-user@jakarta.apache.org&gt;</a><br>Sent: \
Monday, April 29, 2002 6:01 PM<br>Subject: Re: Unable to connect to Oracle \
database<br><br><br></pre>  <blockquote type="cite">
                <pre wrap="">Hi Russ,<br><br>     Would like to know at what point \
your system is complaining,<br>your configuration and initialization seems to be \
perfect...<br>what version of oracle JDBC driver you are using<br>if you are using \
classes111 try using classes12<br><br>-Jaggi<br><br>Russ Leong wrote:<br><br></pre>  \
                <blockquote type="cite">
                  <pre wrap="">Hi everyone,<br>   I have been trying to connect to my \
database with no success. I am<br></pre>  </blockquote>
                  </blockquote>
                  <pre wrap="">sure<br></pre>
                  <blockquote type="cite">
                    <blockquote type="cite">
                      <pre wrap="">that the database connection parameters are \
correct, and since there<br></pre>  </blockquote>
                      </blockquote>
                      </blockquote>
                      <pre wrap=""><!---->were<br></pre>
                      <blockquote type="cite">
                        <pre wrap="">no<br></pre>
                        <blockquote type="cite">
                          <blockquote type="cite">
                            <pre wrap="">complains that means the Oracle driver was \
successfully loaded. I am<br></pre>  </blockquote>
                            </blockquote>
                            <pre wrap="">running<br></pre>
                            <blockquote type="cite">
                              <blockquote type="cite">
                                <pre wrap="">Orion server on my local whereas Oracle \
8.1.5 DB is on another machine<br></pre>  </blockquote>
                                </blockquote>
                                </blockquote>
                                <pre wrap=""><!---->on<br></pre>
                                <blockquote type="cite">
                                  <pre wrap="">my<br></pre>
                                  <blockquote type="cite">
                                    <blockquote type="cite">
                                      <pre wrap="">network. I have also attached the \
portion of my domain.xml which<br></pre>  </blockquote>
                                      </blockquote>
                                      </blockquote>
                                      <pre wrap=""><!---->defines<br></pre>
                                      <blockquote type="cite">
                                        <pre wrap="">my<br></pre>
                                        <blockquote type="cite">
                                          <blockquote type="cite">
                                            <pre wrap="">store setup<br></pre>
                                            </blockquote>
                                            </blockquote>
                                            <pre \
wrap="">---------------------------------------------------------------------------<br>-<br></pre>
  <blockquote type="cite">
                                              <blockquote type="cite">
                                                <pre wrap="">---------<br></pre>
                                                </blockquote>
                                                </blockquote>
                                                <pre \
wrap="">C:\project\j2ee\home&gt;java \
-Dproject.properties=C:\project\j2ee\home\printmg<br>r<br></pre>  <blockquote \
type="cite">  <blockquote type="cite">
                                                    <pre wrap="">.properties  -jar \
C:\project\j2ee\home\orion.jar<br>Oracle9iAS (1.0.2.2) Containers for J2EE \
initialized<br>29 Apr 2002 16:28:03 - org.apache.slide.common.Domain - INFO \
-<br></pre>  </blockquote>
                                                    </blockquote>
                                                    <pre \
                wrap="">Initializing<br></pre>
                                                    <blockquote type="cite">
                                                      <blockquote type="cite">
                                                        <pre wrap="">Domain<br>29 Apr \
2002 16:28:03 - org.apache.slide.common.Domain - INFO - Domain<br>configuration : \
{org.apache.slide.security=true}<br>29 Apr 2002 16:28:03 - \
org.apache.slide.common.Domain - INFO -<br></pre>  </blockquote>
                                                        </blockquote>
                                                        <pre \
                wrap="">Initializing<br></pre>
                                                        <blockquote type="cite">
                                                          <blockquote type="cite">
                                                            <pre wrap="">namespace : \
filesystem<br>29 Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO \
-<br></pre>  </blockquote>
                                                            </blockquote>
                                                            </blockquote>
                                                            <pre \
                wrap=""><!---->Loading<br></pre>
                                                            <blockquote type="cite">
                                                              <blockquote \
                type="cite">
                                                                <blockquote \
type="cite">  <pre wrap="">namespace definition<br>29 Apr 2002 16:28:04 - \
org.apache.slide.common.Namespace - INFO - Node<br>store: \
slidestore.reference.JDBCDescriptorsStore<br>29 Apr 2002 16:28:04 - \
                org.apache.slide.common.Namespace - INFO -<br></pre>
                                                                  </blockquote>
                                                                  </blockquote>
                                                                  <pre \
                wrap="">Security<br></pre>
                                                                  <blockquote \
                type="cite">
                                                                    <blockquote \
type="cite">  <pre wrap="">store references nodestore<br>29 Apr 2002 16:28:04 - \
                org.apache.slide.common.Namespace - INFO - Lock<br></pre>
                                                                      </blockquote>
                                                                      </blockquote>
                                                                      <pre \
                wrap="">store<br></pre>
                                                                      <blockquote \
                type="cite">
                                                                        <blockquote \
type="cite">  <pre wrap="">store references nodestore<br>29 Apr 2002 16:28:04 - \
                org.apache.slide.common.Namespace - INFO -<br></pre>
                                                                          \
                </blockquote>
                                                                          \
                </blockquote>
                                                                          <pre \
                wrap="">Revision<br></pre>
                                                                          <blockquote \
                type="cite">
                                                                            \
<blockquote type="cite">  <pre wrap="">descriptors store references nodestore<br>29 \
                Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO \
                -<br></pre>
                                                                              \
                </blockquote>
                                                                              \
                </blockquote>
                                                                              <pre \
                wrap="">Revision<br></pre>
                                                                              \
                <blockquote type="cite">
                                                                                \
<blockquote type="cite">  <pre wrap="">descriptor store references nodestore<br>29 \
                Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO \
                -<br></pre>
                                                                                  \
                </blockquote>
                                                                                  \
                </blockquote>
                                                                                  \
                </blockquote>
                                                                                  \
                <pre wrap=""><!---->Content<br></pre>
                                                                                  \
                <blockquote type="cite">
                                                                                    \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">store: \
slidestore.reference.FileContentStore<br>29 Apr 2002 16:28:04 - \
org.apache.slide.common.Namespace - INFO -<br>Registering Store jdbc of class \
                class<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                <pre wrap="">org.apache.slide.store.StandardStore<br></pre>
                                                                                      \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">with parameters {} on scope /<br>29 Apr 2002 \
16:28:04 - org.apache.slide.common.Namespace - INFO -<br>Initializing Store \
jdbc(org.apache.slide.store.StandardStore)<br>29 Apr 2002 16:28:04 - \
                slidestore.reference.JDBCDescriptorsStore -<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                <pre wrap=""><!---->INFO -<br></pre>
                                                                                      \
                <blockquote type="cite">
                                                                                      \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">Loading and registering driver: \
oracle.jdbc.driver.OracleDriver<br>29 Apr 2002 16:28:04 - INFO - FileContentStore \
rootpath:<br>C:\project\j2ee\home\apps\printmgr\web\pm\facado\images\filestore<br>29 \
                Apr 2002 16:28:04 - org.apache.slide.common.Namespace - INFO \
                -<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                <pre wrap=""><!---->Loading<br></pre>
                                                                                      \
                <blockquote type="cite">
                                                                                      \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">namespace filesystem parameters<br>29 Apr 2002 \
                16:28:04 - org.apache.slide.common.Namespace - INFO -<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                <pre wrap=""><!---->Loading<br></pre>
                                                                                      \
                <blockquote type="cite">
                                                                                      \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">namespace filesystem base data<br>29 Apr 2002 \
                16:28:04 - slidestore.reference.JDBCDescriptorsStore -<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                <pre wrap=""><!---->INFO -<br></pre>
                                                                                      \
                <blockquote type="cite">
                                                                                      \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">Connecting to <a class="moz-txt-link-rfc2396E" \
href="mailto:jdbc:oracle:thin:@192.168.42.8:1521:pm2">"jdbc:oracle:thin:@192.168.42.8:1521:pm2"</a> \
as user "p<br>m2"<br>29 Apr 2002 16:28:06 - org.apache.slide.store.StandardStore - \
INFO -<br>Delisting service <a class="moz-txt-link-abbreviated" \
href="mailto:slidestore.reference.JDBCDescriptorsStore@63cd51">slidestore.reference.JDBCDescriptorsStore@63cd51</a> \
from<br>active transaction with failure<br>29 Apr 2002 16:28:06 \
-<br>org.apache.slide.transaction.SlideTransactionManager - INFO - \
Rollback<br>Transaction 1 xid ApplicationServerThread-1020<br>068884612-1- in thread \
ApplicationServerThread<br>29 Apr 2002 16:28:06 - org.apache.slide.common.Namespace - \
INFO - Init<br>namespace filesystem configuration<br>29 Apr 2002 16:28:06 - \
                org.apache.slide.common.Namespace - INFO -<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                <pre wrap=""><!---->Import<br></pre>
                                                                                      \
                <blockquote type="cite">
                                                                                      \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">data into namespace filesystem<br>29 Apr 2002 \
16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -<br>Loading object /<br>29 \
Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -<br>Loading \
object /users<br>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - \
INFO -<br>Object already exists at /users<br>29 Apr 2002 16:28:06 - \
org.apache.slide.common.XMLUnmarshaller - INFO -<br>Loading object /actions<br>29 Apr \
2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - INFO -<br>Object already \
exists at /actions<br>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller \
- INFO -<br>Loading object /actions/create<br>29 Apr 2002 16:28:06 - \
org.apache.slide.common.XMLUnmarshaller - INFO -<br>Object already exists at \
/actions/create<br>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - \
INFO -<b r>Loading object /actions/read<br>29 Apr 2002 16:28:06 - \
org.apache.slide.common.XMLUnmarshaller - INFO -<br>Object already exists at \
/actions/read<br>29 Apr 2002 16:28:06 - org.apache.slide.common.XMLUnmarshaller - \
INFO -<br>Loading object /actions/write<br>29 Apr 2002 16:28:07 - \
org.apache.slide.common.XMLUnmarshaller - INFO -<br>Object already exists at \
/actions/write<br>29 Apr 2002 16:28:07 - org.apache.slide.common.XMLUnmarshaller - \
INFO -<br>Loading object /<br>29 Apr 2002 16:28:07 - \
                org.apache.slide.common.Namespace - INFO -<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                <pre wrap=""><!---->Finish<br></pre>
                                                                                      \
                <blockquote type="cite">
                                                                                      \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">init namespace filesystem configuration<br>29 \
                Apr 2002 16:28:07 - org.apache.slide.common.Namespace - INFO \
                -<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
                <pre wrap=""><!---->Loading<br></pre>
                                                                                      \
                <blockquote type="cite">
                                                                                      \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">namespace filesystem configuration<br>29 Apr \
                2002 16:28:07 - org.apache.slide.common.Domain - INFO -<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
</blockquote>  <pre wrap=""><!---->Namespace<br></pre>
                                                                                      \
                <blockquote type="cite">
                                                                                      \
                <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">configuration \
complete<br><br><br><br>&lt;definition&gt;<br>   &lt;store name="jdbc"&gt;<br>       \
                &lt;nodestore<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
</blockquote>  <pre wrap=""><!---->classname="slidestore.reference.JDBCDescriptorsStore"&gt;<br></pre>
                
                                                                                      \
<blockquote type="cite">  <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">           \
&lt;parameter<br>name="driver"&gt;oracle.jdbc.driver.OracleDriver&lt;/parameter&gt;<br> \
&lt;parameter<br>name="url"&gt;<a class="moz-txt-link-abbreviated" \
href="mailto:oracle:thin:@192.168.42.8:1521:pm2">oracle:thin:@192.168.42.8:1521:pm2</a>&lt;/parameter&gt;<br> \
&lt;parameter name="user"&gt;pm2&lt;/parameter&gt;<br>           &lt;parameter \
name="password"&gt;pm2&lt;/parameter&gt;<br>       &lt;/nodestore&gt;<br>       \
&lt;securitystore&gt;<br>           &lt;reference store="nodestore" /&gt;<br>       \
&lt;/securitystore&gt;<br>       &lt;lockstore&gt;<br>           &lt;reference \
store="nodestore" /&gt;<br>       &lt;/lockstore&gt;<br>           \
&lt;revisiondescriptorsstore&gt;<br>       &lt;reference store="nodestore" /&gt;<br>  \
&lt;/revisiondescriptorsstore&gt;<br>       &lt;revisi ondescriptorstore&gt;<br>      \
&lt;reference store="nodestore" /&gt;<br>       &lt;/revisiondescriptorstore&gt;<br>  \
                &lt;contentstore<br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
                </blockquote>
                                                                                      \
</blockquote>  <pre wrap=""><!---->classname="slidestore.reference.FileContentStore"&gt;<br></pre>
  <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <blockquote type="cite">
                                                                                      \
<pre wrap="">           \
&lt;parameter<br>name="rootpath"&gt;C:\temp\repository\filestore&lt;/parameter&gt;<br> \
&lt;parameter name="version"&gt;true&lt;/parameter&gt;<br>       \
&lt;/contentstore&gt;<br>   &lt;/store&gt;<br>   &lt;scope match="/" store="jdbc" \
                /&gt;<br>&lt;/definition&gt;<br><br></pre>
                                                                                      \
                </blockquote>
                                                                                      \
</blockquote>  <pre wrap="">---------------------------------------------------------------------------<br>-<br></pre>
  <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">---------<br><br>Can someone tell me what am I \
doing wrong here? Thank you very much.<br><br>Russ<br><br><br>--<br>To unsubscribe, \
e-mail:<br></pre>  </blockquote>
                                                                                      \
</blockquote>  <pre wrap=""><a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-unsubscribe@jakarta.apache.org">&lt;mailto:slide-user-unsubscribe@jakarta.apache.org&gt;</a><br></pre>
  <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap="">For additional commands, e-mail:<br></pre>
                                                                                      \
</blockquote>  </blockquote>
                                                                                      \
<pre wrap=""><a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-help@jakarta.apache.org">&lt;mailto:slide-user-help@jakarta.apache.org&gt;</a><br></pre>
  <blockquote type="cite">
                                                                                      \
<blockquote type="cite">  <pre wrap=""><br><br></pre>
                                                                                      \
</blockquote>  <pre wrap=""><br><br>--<br>To unsubscribe, e-mail:<br></pre>
                                                                                      \
</blockquote>  <pre wrap=""><a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-unsubscribe@jakarta.apache.org">&lt;mailto:slide-user-unsubscribe@jakarta.apache.org&gt;</a><br></pre>
  <blockquote type="cite">
                                                                                      \
<pre wrap="">For additional commands, e-mail:<br></pre>  </blockquote>
                                                                                      \
<pre wrap=""><a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-help@jakarta.apache.org">&lt;mailto:slide-user-help@jakarta.apache.org&gt;</a><br><br><br>--<br>To \
unsubscribe, e-mail:<br></pre>  </blockquote>
                                                                                      \
<pre wrap=""><!----><a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-unsubscribe@jakarta.apache.org">&lt;mailto:slide-user-unsubscribe@jakarta.apache.org&gt;</a><br></pre>
  <blockquote type="cite">
                                                                                      \
<pre wrap="">For additional commands, e-mail:<br></pre>  </blockquote>
                                                                                      \
<pre wrap=""><!----><a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-help@jakarta.apache.org">&lt;mailto:slide-user-help@jakarta.apache.org&gt;</a><br></pre>
  <blockquote type="cite">
                                                                                      \
<pre wrap=""><br><br>--<br>To unsubscribe, e-mail:<br></pre>  </blockquote>
                                                                                      \
<pre wrap=""><!----><a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-unsubscribe@jakarta.apache.org">&lt;mailto:slide-user-unsubscribe@jakarta.apache.org&gt;</a><br></pre>
  <blockquote type="cite">
                                                                                      \
<pre wrap="">For additional commands, e-mail:<br></pre>  </blockquote>
                                                                                      \
<pre wrap=""><!----><a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-help@jakarta.apache.org">&lt;mailto:slide-user-help@jakarta.apache.org&gt;</a><br><br><br>--<br>To \
unsubscribe, e-mail:   <a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-unsubscribe@jakarta.apache.org">&lt;mailto:slide-user-unsubscribe@jakarta.apache.org&gt;</a><br>For \
additional commands, e-mail: <a class="moz-txt-link-rfc2396E" \
href="mailto:slide-user-help@jakarta.apache.org">&lt;mailto:slide-user-help@jakarta.apache.org&gt;</a><br><br><br><br></pre>
  </blockquote>
                                                                                      \
<br>  </body>
                                                                                      \
</html>


["slide_oracle.sql" (text/plain)]

DROP TABLE objects;
DROP TABLE children;
DROP TABLE links;
DROP TABLE permissions;
DROP TABLE locks;
DROP TABLE revisions;
DROP TABLE workingrevision;
DROP TABLE latestrevisions;
DROP TABLE branches;
DROP TABLE revision;
DROP TABLE label;
DROP TABLE property;
DROP TABLE revisioncontent;

CREATE TABLE objects(
       uri       VARCHAR(3200) primary key, 
       classname VARCHAR(4000)
);

CREATE TABLE children(
       uri      VARCHAR(4000), 
       childuri VARCHAR(4000)
);

CREATE TABLE links(
       link   VARCHAR(4000), 
       linkto VARCHAR(4000)
);

CREATE TABLE permissions(
       object         VARCHAR(4000), 
       revisionnumber VARCHAR(20), 
       subject        VARCHAR(4000), 
       action         VARCHAR(4000),
       inheritable    int,
       negative       int
);

CREATE TABLE locks(
       id             VARCHAR(4000), 
       object         VARCHAR(4000), 
       subject        VARCHAR(4000), 
       type           VARCHAR(4000), 
       expirationdate VARCHAR(15),
       inheritable    int, 
       xexclusive     int
);

CREATE TABLE revisions(
       uri             VARCHAR(3200) primary key, 
       isversioned     int, 
       initialrevision VARCHAR(10)
);

CREATE TABLE workingrevision(
       uri          VARCHAR(4000), 
       baserevision VARCHAR(20), 
       xnumber      VARCHAR(20)
);

CREATE TABLE latestrevisions(
       uri        VARCHAR(4000), 
       branchname VARCHAR(4000), 
       xnumber    VARCHAR(20)
);

CREATE TABLE branches(
       uri         VARCHAR(4000), 
       xnumber     VARCHAR(20), 
       childnumber VARCHAR(20)
);

CREATE TABLE revision(
       uri        VARCHAR(4000), 
       xnumber    VARCHAR(20), 
       branchname VARCHAR(4000)
);

CREATE TABLE label(
       uri     VARCHAR(4000), 
       xnumber VARCHAR(20), 
       label   VARCHAR(4000)
);

CREATE TABLE property(
       uri       VARCHAR(4000), 
       xnumber   VARCHAR(20), 
       name      VARCHAR(4000), 
       value     VARCHAR(4000), 
       namespace VARCHAR(4000), 
       type      VARCHAR(100), 
       protected int
);

CREATE TABLE revisioncontent(
       uri     VARCHAR(4000), 
       xnumber VARCHAR(20), 
       content blob
);




["domain.xml" (text/xml)]

<?xml version="1.0"?>

<slide logger="org.apache.slide.util.logger.SimpleLogger" logger-level="1">
  
  <namespace name="YOUR_NAMESPACE">
    
    <definition>
      <store name="memory">
        <nodestore classname="slidestore.reference.JDBCDescriptorsStore">
         <parameter name="driver">oracle.jdbc.driver.OracleDriver</parameter>
         <parameter name="url">jdbc:oracle:thin:system/manager@192.168.0.1:1521:YOUR_DATABASE</parameter>
         <parameter name="user">system</parameter>
         <parameter name="password">manager</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">oracle.jdbc.driver.OracleDriver</parameter>
         <parameter name="url">jdbc:oracle:thin:system/manager@192.168.0.1:1521:YOUR_DATABASE</parameter>
         <parameter name="user">system</parameter>
         <parameter name="password">manager</parameter>
         <parameter name="jdbcversion">1</parameter>

        </contentstore >
        <!--contentstore classname="slidestore.reference.FileContentStore">
          <parameter name="rootpath">D:\\XXXXX\YYYYYY\ZZZZZZ</parameter>
        </contentstore -->
      </store>

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

    </definition>

    
    <configuration>

      <!-- Actions mapping -->
      <default-action>/actions</default-action>
      <read-object>/actions/read</read-object>
      <create-object>/actions/write</create-object>
      <remove-object>/actions/write</remove-object>
      <grant-permission>/actions/manage</grant-permission>
      <revoke-permission>/actions/manage</revoke-permission>
      <read-permissions>/actions/manage</read-permissions>
      <lock-object>/actions/write</lock-object>
      <kill-lock>/actions/manage</kill-lock>
      <read-locks>/actions/read</read-locks>
      <read-revision-metadata>/actions/read</read-revision-metadata>
      <create-revision-metadata>/actions/write</create-revision-metadata>
      <modify-revision-metadata>/actions/write</modify-revision-metadata>
      <remove-revision-metadata>/actions/write</remove-revision-metadata>
      <read-revision-content>/actions/read</read-revision-content>
      <create-revision-content>/actions/write</create-revision-content>
      <modify-revision-content>/actions/write</modify-revision-content>
      <remove-revision-content>/actions/write</remove-revision-content>

      <!-- Paths configuration -->
      <userspath>/users</userspath>
      <guestpath>guest</guestpath>
      <filespath></filespath>
      <parameter name="dav">true</parameter>
      <parameter name="standalone">true</parameter>

      <!-- Roles definition -->
      <role name="admin">slideroles.basic.RootRole</role>
      <role name="user">slideroles.basic.UserRole</role>
      <role name="guest">slideroles.basic.GuestRole</role>

      <!-- Users management -->
      <auto-create-users>true</auto-create-users>

      <!-- Default properties mapping -->
      <default-property name="foo" namespace="nsfoo/" value="bar"
       role="user"/>
      <default-property name="password" namespace="slide/" value=""
       role="user"/>

    </configuration>
    
    <data>
      
      <objectnode classname="org.apache.slide.structure.SubjectNode" uri="/">
        
        <permission action="/actions" subject="admin"/>
        <permission action="/actions/read" subject="user"
         inheritable="false"/>
        <permission action="/actions/read" subject="nobody"
         inheritable="false"/>
        
        <!-- /users represents the unauthenticated user -->
        
        <objectnode classname="org.apache.slide.structure.SubjectNode" 
         uri="/users">
          
          <permission action="/actions" subject="~"/>
          <permission action="/actions" subject="guest"
           inheritable="true" negative="true"/>
          <permission action="/actions/read" subject="user"
           inheritable="false"/>

          <!-- Permission group example -->
          
          <objectnode classname="org.apache.slide.structure.GroupNode" 
            uri="/users/groupA">
             <objectnode classname="org.apache.slide.structure.LinkNode" 
                uri="/users/groupA/john" linkedUri="/users/john" />
             <objectnode classname="org.apache.slide.structure.LinkNode" 
                uri="/users/groupA/root" linkedUri="/users/root" />
             <objectnode classname="org.apache.slide.structure.SubjectNode" 
               uri="/users/groupA/singleGroupMember"  />
          </objectnode>

          <!-- /users/root represents the administrator -->
          
          <objectnode classname="slideroles.basic.RootRoleImpl" 
           uri="/users/root">
            <revision>
              <property name="password">root</property>
            </revision>
          </objectnode>
          
          <!-- /users/john represents an authenticated user -->
          
          <objectnode classname="slideroles.basic.UserRoleImpl" 
           uri="/users/john">
            <revision>
              <property name="password">john</property>
            </revision>
          </objectnode>
          
          <!-- /users/guest represents an authenticated or unauthenticated 
               guest user -->
          
          <objectnode classname="slideroles.basic.GuestRoleImpl" 
           uri="/users/guest">
            <revision>
              <property name="password"></property>
            </revision>
          </objectnode>
          
        </objectnode>
        
        <objectnode classname="org.apache.slide.structure.ActionNode" 
         uri="/actions">
          
          <objectnode classname="org.apache.slide.structure.ActionNode" 
           uri="/actions/read"/>
          
          <objectnode classname="org.apache.slide.structure.ActionNode" 
           uri="/actions/write"/>
          
          <objectnode classname="org.apache.slide.structure.ActionNode" 
           uri="/actions/manage"/>
          
        </objectnode>
        
        <objectnode classname="org.apache.slide.structure.SubjectNode" 
         uri="/files">
          
          <permission action="/actions/manage" subject="/users/john"/>
          <permission action="/actions/write" subject="+/users/groupA"/>
          <permission action="/actions/read" subject="nobody"/>
          
        </objectnode>
        
      </objectnode>
      
    </data>
    
  </namespace>
  
</slide>



--
To unsubscribe, e-mail:   <mailto:slide-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:slide-user-help@jakarta.apache.org>

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic