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" <[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>
> > > <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:[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]>
