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</parameter>
<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]
