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]

Reply via email to