Re: Unable to connect to Oracle database

Tue, 30 Apr 2002 06:00:14 -0700

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:
002d01c1f03a$8d4cbaf0$342aa8c0@russ"> 
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(Name
space.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.retrieveO
bject(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" <[EMAIL PROTECTED]>
To: "Slide Users Mailing List" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
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" <[EMAIL PROTECTED]>
To: "Slide Users Mailing List" <[EMAIL PROTECTED]>
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>
       <revisi
ondescriptorstore>
           <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:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>




--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>


--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>


--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>




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
);




<?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:[EMAIL PROTECTED]: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:[EMAIL PROTECTED]: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:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to