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]
