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]
