You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Nick Longinow <ni...@vanhooseassociates.com> on 2004/11/08 18:27:02 UTC
Oracle Store "Out of Memory" on putMethod ??
Hi
I noticed in the CommonRDBMSAdapter.java code that it uses a different logic
path when COMPRESS is true, so I tried that in domain.xml and it now will
import (putMethod via webdav client) for most files.
However, for a larger file (25M) I have seeing the adaptor throw an out of
memory error. What can I configure to fix this ? Also, should I be using a
BindingStore in my domain.xml ?
java.lang.OutOfMemoryError
org.apache.slide.common.ServiceAccessException: Service
org.apache.slide.store.impl.rdbms.JDBCStore@1295fe8 access error :
java.lang.OutOfMemoryError
org.apache.slide.store.AbstractStore.createRevisionContent(AbstractStore.jav
org.apache.slide.store.ExtendedStore.createRevisionContent(ExtendedStore.jav
org.apache.slide.store.BindingStore.createRevisionContent(BindingStore.java:
org.apache.slide.store.BindingStore.createRevisionContent(BindingStore.java:
org.apache.slide.webdav.method.PutMethod.executeRequest(PutMethod.java:392)
Domain.xml snippet:
<store name="OracleStore" classname="org.apache.slide.store.BindingStore">
<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.driver.OracleDriver</parameter>
Nick
-----Original Message-----
From: Nick Longinow [mailto:nicklonginow@vanhooseassociates.com]
Sent: Monday, November 08, 2004 11:18 AM
To: 'Slide Users Mailing List'
Subject: RE: Anyone able to use Slide 2.1B2 with Oracle store ?
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:r.novak@iqsoft.at]
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 <ni...@vanhooseassociates.com>
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: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org