try to use jdbc url:
oracle:thin:@192.168.42.8:1521:pm2
in your domain.xml. There was a post talked about this. 



-----Original Message-----
From: Russ Leong [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 5:01 AM
To: Slide Users Mailing List
Subject: 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:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to