there is no special reason, i just don't use binding atm.
(http://jakarta.apache.org/slide/howto-bind.html)

I just mount the whole thing with "netdrive" and use ACL, DELTAV.
I run the Oracle full text indexer vs. the Blobs to get fulltext search.

Roman

Am Di 09.11.2004 14:40, Nick Longinow <[EMAIL PROTECTED]> schrieb:

> Roman
> 
> I notice you don't use the BindingStore classname within the store
> definition, ie,
> <store name="OracleStore" classname="org.apache...BindingStore">
> Could I ask why not ?
> Nick 
> 
> -----Original Message-----
> From: Roman Novak [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, November 09, 2004 5:07 AM
> To: Slide Users Mailing List
> Subject: RE: Anyone able to use Slide 2.1B2 with Oracle store ?
> 
> An extract of Domain.xml:
> 
> <?xml version="1.0"?>
> <slide>
>     <namespace name="slide">
>             <definition>
>             <store name="OracleStore">
>               <nodestore
> classname="org.apache.slide.store.impl.rdbms.JDBCStore">
>                 <parameter
> name="adapter">org.apache.slide.store.impl.rdbms.OracleRDBMSAdapter</paramet
> er>
>                 <parameter
> name="driver">oracle.jdbc.OracleDriver</parameter>
>                 <parameter
> name="url">jdbc:oracle:thin:@10.64.1.14:1527:db920</parameter>
>                 <parameter name="user">slide</parameter>
>                 <parameter name="password">yourpasswordhere</parameter>
>                 <parameter name="dbcpPooling">true</parameter>
>               </nodestore>
>               <contentstore>
>                 <reference store="nodestore" />
>               </contentstore>
>               <securitystore>
>                 <reference store="nodestore" />
>               </securitystore>
>               <lockstore>
>                 <reference store="nodestore" />
>               </lockstore>
>               <revisiondescriptorsstore>
>                 <reference store="nodestore" />
>               </revisiondescriptorsstore>
>               <revisiondescriptorstore>
>                 <reference store="nodestore" />
>               </revisiondescriptorstore>
>              </store>
>              <scope match="/" store="OracleStore"/> 
>             </definition>
>         <configuration>
> ....
> 
> Am Di 09.11.2004 10:43, Roman Novak <[EMAIL PROTECTED]> schrieb:
> 
> > The "complete" environment is as follows:
> > 
> > - Slide 2.1B2 binary distribution
> > - JBoss 3.2.6 (includes Tomcat 5.0.28)
> > - Oracle 9.2.0.4.0
> > - Oracle JDBC driver ojdbc14.jar 
> > 
> > Tested the deployment on Win2K and Linux and hooked in also MySQL for a
> secondary store (just for content).
> > 
> > Am Mo 08.11.2004 17:17, Nick Longinow
> <[EMAIL PROTECTED]> schrieb:
> > 
> > > 
> > > I have tried using various thin drivers without success for anything but
> > > very small files.  It seems that Oracle has some problem writing large
> BLOBS
> > > or CLOBS with the thin drivers, and recommends using the OCI driver (bad
> for
> > > me, don't want users to have to install OCI client).
> > > 
> > > Is anyone able to putMethod large files into an Oracle store ?  If so,
> what
> > > driver and version of Oracle db are you using ?  
> > > Nick
> > > 
> > > -----Original Message-----
> > > From: Roman Novak [mailto:[EMAIL PROTECTED] 
> > > Sent: Thursday, November 04, 2004 9:33 AM
> > > To: Slide Users Mailing List
> > > Subject: Re: Anyone able to use Slide 2.1B2 with Oracle store ?
> > > 
> > > Yes, I am using it and it works.
> > > 
> > > I use ojdbc14.jar + a Oracle9i DB (didn't test with 8i)
> > > 
> > > Roman
> > > 
> > > Am Do 04.11.2004 15:08, Nick Longinow
> <[EMAIL PROTECTED]>
> > > schrieb:
> > > 
> > > > Hi
> > > > 
> > > >  
> > > > 
> > > > I'm using a simple Oracle store, and am unable to get it to even do a
> put
> > > of
> > > > a file.
> > > > 
> > > > Can anyone help me ?
> > > > 
> > > >  
> > > > 
> > > > java.sql.SQLException: Io exception: End of TNS data channel
> > > > 
> > > >         at
> > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
> > > > 
> > > >         at
> > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:231)
> > > > 
> > > >         at
> > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:345)
> > > > 
> > > >         at
> > > > 
> > > > oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:855)at
> > > > 
> > > >
> > >
> oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatem
> > > > 
> > > >
> > >
> oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.jav
> > > > 
> > > >
> > >
> org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:1
> > > > 
> > > >
> > >
> 65)org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.close(StandardRDBM
> > > > 
> > > >
> > >
> org.apache.slide.store.impl.rdbms.CommonRDBMSAdapter.storeContent(CommonRDBM
> > > > 
> > > >
> > >
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(
> > > > 
> > > >
> > >
> org.apache.slide.webdav.method.PutMethod.executeRequest(PutMethod.java:392)
> > > > 
> > > >  
> > > > 
> > > > Domain.xml is
> > > > 
> > > >  
> > > > 
> > > >                 <store name="OracleStore" >
> > > > 
> > > >                    <nodestore
> > > > classname="org.apache.slide.store.impl.rdbms.JDBCStore">
> > > > 
> > > >                       <parameter
> > > >
> > >
> name="adapter">org.apache.slide.store.impl.rdbms.OracleRDBMSAdapter</paramet
> > > > er>
> > > > 
> > > >                       <parameter
> > > > name="driver">oracle.jdbc.driver.OracleDriver</parameter>
> > > > 
> > > >                       <parameter
> > > > name="url">jdbc:oracle:thin:@xx.xx.x.xx:1524:mysid</parameter>
> > > > 
> > > >                       <parameter name="user">username</parameter>
> > > > 
> > > >                       <parameter name="password">password</parameter>
> > > > 
> > > >                       <parameter name="dbcpPooling">true</parameter>
> > > > 
> > > >                       <parameter
> > > name="maxPooledConnections">10</parameter>
> > > > 
> > > >                       <parameter
> > > name="isolation">READ_COMMITTED</parameter>
> > > > 
> > > >                       <parameter name="compress">false</parameter>
> > > > 
> > > >                    </nodestore>
> > > > 
> > > >                    <contentstore>
> > > > 
> > > >                       <reference store="nodestore" />
> > > > 
> > > >                    </contentstore>
> > > > 
> > > >                    <securitystore>
> > > > 
> > > >                       <reference store="nodestore" />
> > > > 
> > > >                    </securitystore>
> > > > 
> > > >                    <lockstore>
> > > > 
> > > >                       <reference store="nodestore" />
> > > > 
> > > >                    </lockstore>
> > > > 
> > > >                    <revisiondescriptorsstore>
> > > > 
> > > >                       <reference store="nodestore" />
> > > > 
> > > >                    </revisiondescriptorsstore>
> > > > 
> > > >                    <revisiondescriptorstore>
> > > > 
> > > >                       <reference store="nodestore" />
> > > > 
> > > >                    </revisiondescriptorstore>
> > > > 
> > > >                 </store>
> > > > 
> > > > Nick
> > > > 
> > > >  
> > > > 
> > > >  
> > > > 
> > > >  
> > > > 
> > > 
> > > 
> > > 
> > > 
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > 
> > > 
> > > 
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > 
> > 
> > 
> > 
> > 
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 




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

Reply via email to