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 Richard Emberson <re...@edgedynamics.com> on 2004/11/09 02:14:50 UTC

Oracle configuration help

 From the webdav client when I try to put a file into "files" I get:

java.sql.SQLException: Io exception: Broken pipe


My configuration:

     <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.driver.OracleDriver</parameter>
         olympia password edgedb
         <parameter 
name="url">jdbc:oracle:thin:@myhost:1521:mysid</parameter>
         <parameter name="user">myuser</parameter>
         <parameter name="password">mypassword</parameter>
         <parameter name="dbcpPooling">true</parameter>
         <parameter name="maxPooledConnections">5</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>
      <scope match="/" store="OracleStore"/>
     </definition>

webdav command:

$ cd files
$ put /home/myname/TFILE
Uploading  '/home/myname/TFILE' to '/foobar/slide/files/TFILE' failed.
Internal Server Error (500)

server stack trace:

2004-11-08 17:05:53,365 INFO  [STDOUT]  - TP-Processor5, 08-Nov-2004 
17:05:53, unauthenticated, PROPFIND, 404 "Not Found", 41 ms, /files/TFILE
2004-11-08 17:05:58,575 INFO  [STDOUT]  - 08 Nov 2004 17:05:58 - 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - WARNING - 
java.sql.SQLException: Io exception: Broken pipe
2004-11-08 17:05:58,575 ERROR [STDERR]  - java.sql.SQLException: Io 
exception: Broken pipe
2004-11-08 17:05:58,577 ERROR [STDERR]  -       at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

2004-11-08 17:05:58,578 ERROR [STDERR]  -       at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
2004-11-08 17:05:58,578 ERROR [STDERR]  -       at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
2004-11-08 17:05:58,578 ERROR [STDERR]  -       at 
oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:648)
2004-11-08 17:05:58,578 ERROR [STDERR]  -       at 
oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatement.java:485)
2004-11-08 17:05:58,578 ERROR [STDERR]  -       at 
oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java:393)
2004-11-08 17:05:58,578 ERROR [STDERR]  -       at 
org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:165)
........
2004-11-08 17:05:58,605 INFO  [STDOUT]  - 08 Nov 2004 17:05:58 - 
org.apache.slide.transaction.SlideTransaction - WARNING - Rollback 
failure: Resource manager 
org.apache.slide.store.impl.rdbms.JDBCStore@d03e03 Error code 
XA_RBCOMMFAIL in Transaction 13 xid TP-Processor5-1099962353436-13- in 
thread TP-Processor5
2004-11-08 17:05:58,605 INFO  [STDOUT]  - TP-Processor5, 08-Nov-2004 
17:05:53, unauthenticated, PUT, 500 "Internal Server Error", 5170 ms, 
/files/TFILE

-- 
This email message is for the sole use of the intended recipient(s) and
may contain confidential information.  Any unauthorized review, use,
disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org