You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Russ Leong <ru...@kikuze.com> on 2002/04/29 11:00:53 UTC
Unable to connect to Oracle database
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\printmgr
.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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Unable to connect to Oracle database
Posted by Russ Leong <ru...@kikuze.com>.
Hi,
can someone clarify if the following messages(Delist, Rollback) are
normal and ignorable in Slide initialization?
---------------------------
slidestore.reference.JDBCDescriptorsStore - INFO - Connecting to
"jdbc:oracle:thin:pm2/pm2@192.168.42.8:1521:pm2" as user "pm2"
org.apache.slide.store.StandardStore - INFO - Delisting service
slidestore.reference.JDBCDescriptorsStore@63cd51 from active transaction
with failure
org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
Transaction 1 xid ApplicationServerThread-1020310719531-1- in thread
ApplicationServerThread
---------------------------
if it is ignorable, the second thing I would like to know is, if the
following data is the database's PERMISSION table
---------------------------
OBJECT SUBJECT ACTION INHERITABLE NEGATIVE
/ /users/root /actions 1
0
/users /users/root /actions 1 0
---------------------------
am I right to say that for user root, he has all permissions found in
/actions recursive at "/" and "/users"? if so, when I run the following code
:
SlideToken token = new SlideTokenImpl(new CredentialsToken(new
String("root")));
struct.create(token, new SubjectNode(), "/users/tom");
I will get the following messages :
---------------------------
org.apache.slide.common.SlideException - DEBUG -
org.apache.slide.structure.ObjectNotFoundException: No object found at
/users/tom
at
slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor
e.java:584)
at
org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:171)
at
org.apache.slide.structure.StructureImpl.create(StructureImpl.java:322)
org.apache.slide.common.Domain - DEBUG - Checking basic permissions on new
object
org.apache.slide.common.Domain - DEBUG - Basic permissions granted for user
root
WARNING - WARNING: No active transaction
WARNING - WARNING: No active transaction
---------------------------
If anymore information is needed pls let me know, I have been trying to do
this for more than a week and still no progress.....
Russ
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Unable to connect to Oracle database
Posted by Jagadesh Nandasamy <ja...@eself.com>.
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" <ch...@eself.com>
>To: "Slide Users Mailing List" <sl...@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" <ja...@eself.com>
>>To: "Slide Users Mailing List" <sl...@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:
>>>>
>><ma...@jakarta.apache.org>
>>
>>>>For additional commands, e-mail:
>>>>
>><ma...@jakarta.apache.org>
>>
>>>>
>>>>
>>>
>>>
>>>--
>>>To unsubscribe, e-mail:
>>>
>><ma...@jakarta.apache.org>
>>
>>>For additional commands, e-mail:
>>>
>><ma...@jakarta.apache.org>
>>
>>
>>--
>>To unsubscribe, e-mail:
>>
><ma...@jakarta.apache.org>
>
>>For additional commands, e-mail:
>>
><ma...@jakarta.apache.org>
>
>>
>>
>>--
>>To unsubscribe, e-mail:
>>
><ma...@jakarta.apache.org>
>
>>For additional commands, e-mail:
>>
><ma...@jakarta.apache.org>
>
>
>--
>To unsubscribe, e-mail: <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>
>
Re: Unable to connect to Oracle database
Posted by Russ Leong <ru...@kikuze.com>.
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" <ch...@eself.com>
To: "Slide Users Mailing List" <sl...@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" <ja...@eself.com>
> To: "Slide Users Mailing List" <sl...@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:
> <ma...@jakarta.apache.org>
> > >For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> > >
> > >
> > >
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Unable to connect to Oracle database
Posted by Charles <ch...@eself.com>.
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" <ja...@eself.com>
To: "Slide Users Mailing List" <sl...@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:
<ma...@jakarta.apache.org>
> >For additional commands, e-mail:
<ma...@jakarta.apache.org>
> >
> >
> >
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Unable to connect to Oracle database
Posted by Russ Leong <ru...@kikuze.com>.
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" <ja...@eself.com>
To: "Slide Users Mailing List" <sl...@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:
<ma...@jakarta.apache.org>
> >For additional commands, e-mail:
<ma...@jakarta.apache.org>
> >
> >
> >
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Unable to connect to Oracle database
Posted by Jagadesh Nandasamy <ja...@eself.com>.
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\printmgr
>.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: <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>