RE: oracle database for storage

[Raj Kumar]

Title: oracle database for storage

hi,

I think the url you are using is wrong. 

The url for the database should not include jdbc: at the beginning.

The "jdbc:" portion is automatically added by the  JDBCDescriptorsStore class in its connect method.

Hence try connecting using the nodestore element given below.

        <nodestore classname="slidestore.reference.JDBCDescriptorsStore">
         <parameter name="driver">oracle.jdbc.driver.OracleDriver</parameter>
         <parameter name="url">oracle:thin:@localhost:1521:ORCL</parameter>
         <parameter name="user">TP2</parameter>
         <parameter name="password">TP2</parameter>
        </nodestore>

     thanks,

    rajkumar

 

-----Original Message-----
From: Kurapati, Rama [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 12:52 PM
To: '[EMAIL PROTECTED]'
Subject: RE: oracle database for storage

try by checking  jdbc driver in class path

 

Rama

-----Original Message-----
From: Thien Tran [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 3:49 PM
To: '[EMAIL PROTECTED]'
Subject: oracle database for storage

Hi,

I am trying to set up Slide1.0.11 to use Oracle8 database for storage.

I've followed the quick start instructions, and tried to do the necessary steps for Oracle:
- copied oracle\jdbc\lib\classes12.jar to slide\WEB-INF\lib\
- created database instance (name=ORCL), user/pass (TP2/TP2), and created necessary slide database tables.
- uncommented and modified the following sections in the domain.xml as follow:

        <nodestore classname="slidestore.reference.JDBCDescriptorsStore">
         <parameter name="driver">oracle.jdbc.driver.OracleDriver</parameter>
         <parameter name="url">jdbc:oracle:thin:@localhost:1521:ORCL</parameter>
         <parameter name="user">TP2</parameter>
         <parameter name="password">TP2</parameter>
        </nodestore>

        <contentstore classname="slidestore.reference.JDBCContentStore">
        ...

When i restarted Tomcat, i get the following errors:

        Loading namespace slide base data
        WARNING - Service slidestore.reference.JDBCDescriptorsStore@6a0252 connection failed : No suitable driver
        WARNING - Service is missing on root node
        org.apache.slide.common.ServiceMissingOnRootNodeException: Service is missing on root node
                at org.apache.slide.common.Uri.parseUri(Uri.java:373)
                at org.apache.slide.common.Uri.<init>(Uri.java:106)
                at org.apache.slide.common.Namespace.getUri(Namespace.java:580)

Any pointer appreciated.
Thien