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 Andrea Faustini <an...@sosinel.com> on 2005/07/15 17:09:06 UTC
Slide client and Oracle XML Repository - error when using jdbc/Oracle
I'm using the Slide Client libraries to upload a file via jdbc (container
Tomcat) to an Oracle XML DB Repository (using WebDAV protocol).
My problem is similar to the "PUT error when using jdbc/Oracle" thread, (all
works fine with samll files but if the size is over 30k i got the HHTP500
Internal Server Error caused by Oracle ORA-600 error) but i'm not using
Jakarta Slide Server and all works fine using File or byte[] instead of
InputStream at the constructor declaration:
Anyone can help me? Information for debug help follows:
----------------------------------------------------------------------------
-
1) Servlet code - I'm connecting to it via WebDAV using the following code:
import java.io.IOException;
import java.io.InputStream;
import java.net.MalformedURLException;
import org.apache.commons.httpclient.HttpException;
import org.apache.commons.httpclient.HttpURL;
import org.apache.log4j.Logger;
import org.apache.webdav.lib.WebdavResource;
public class WebDavSchema {
private static Logger log_ =
Logger.getLogger("com.sosinel.docreg.util.WebDavSchema");
/**
* Costruttore.
*
* @param theUrl String, webdav url;
* @param theUser String, webdav userid;
* @param thePassword String, webdav password;
* @param theNameSchema String, schema name;
* @param theSchema InputStream, data flow.
*/
public WebDavSchema(String theUrl, String theUser, String thePassword,
String theNameSchema, InputStream theSchema){
try
{
log_.debug("theUrl: " + theUrl);
HttpURL hrl = new HttpURL(theUrl);
log_.debug("theUser: " + theUser);
log_.debug("thePassword: " + thePassword);
hrl.setUserinfo(theUser,thePassword);
WebdavResource wdr = new WebdavResource(hrl);
log_.debug("theNameSchema: " + theNameSchema);
wdr.putMethod((wdr.getPath()+"/"+theNameSchema),theSchema);
wdr.close();
}
catch(MalformedURLException mue)
{
log_.debug("Eccezione MalformedURLException: " + mue.toString());
}
catch(HttpException he)
{
log_.debug("Eccezione HttpException: " + he.toString());
}
catch(IOException ioe)
{
log_.debug("Eccezione IOException: " + ioe.toString());
}
}
}
-----------------------------------------------------------------------
2) I got the following HTTP 500 Internal Server Error :
ORA-00600: internal error code, arguments: [kghssc_getbuf], [], [], [], [],
[], [], []
----------------------------------------------------------------------
3) The Oracle alert.log contains the following
Fri Jul 15 14:39:26 2005
Errors in file
/u01/oracle/product/9.2.0.1.0/oradata/orcl/bdump/orcl_s004_3693.trc:
ORA-00600: internal error code, arguments: [kghssc_getbuf], [], [], [], [],
[], [], []
Fri Jul 15 14:39:27 2005
Errors in file
/u01/oracle/product/9.2.0.1.0/oradata/orcl/bdump/orcl_s004_3693.trc:
ORA-00600: internal error code, arguments: [kghssc_getbuf], [], [], [], [],
[], [], []
I don't know how to analyze the trace file... is'n sufficently clear to
me....
Any idea?
Thanks
Andrea Faustini
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 14/07/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 14/07/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Webdav Protocole question about method PUT and File Locking timeout
Posted by Jean-Philippe Encausse <Je...@jalios.com>.
Hi
User A open a File
User B open the same but a LOCK is already on
User A make a PUT (by writting something)
User A wait and a TIMEOUT append
User B can now access the File
User B make a PUT (by writting something)
User B close the file
User A make a PUT (by writting something)
At this time user A has no longer a Lock on the file
and the MS-Word (Webdav client) only make a PUT
What should webdav server do ?
1. SC_OK -> overwrite the file
2. SC_CONFLICT ?
3. SC_LOCKED ?
Something more tricky ?
--
Jean-Philippe Encausse - R&D Jalios SA
Jean-Philippe.Encausse@Jalios.com - http://support.jalios.com
ICQ: 109796741 - AOL: NextOne6666 - MSN: Nextone6666@hotmail.com
Mob: +33 6 80 75 71 09 Office: +33 1 39 23 92 83 - http://www.encausse.com
Do it Once, Use it Twice ~ Do it Twice, Make It Once
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
RE: Slide client and Oracle XML Repository - error when using jdbc/Oracle
Posted by Raman Sandhu <ra...@adeptia.com>.
Hi Andrea
If you want to use input stream these is another API bundled with
VFS(virtual File System) which has both methods to put and get the data thru
input and output streams.
URL to run that is
"webdav://"+_userId+":"+_password+"@"+getServerName()+":"+getServerPort()+ge
tFileLocation()
// Sample Code
FileSystemManager fsManager = VFS.getManager();
FileObject fileObject = fsManager.resolveFile(getUrl());
FileContent content = fileObject.getContent();
InputStream input = content.getInputStream();
Thanks
Raman
-----Original Message-----
From: Andrea Faustini [mailto:andrea.faustini@sosinel.com]
Sent: Friday, July 15, 2005 8:39 PM
To: slide-user@jakarta.apache.org
Subject: Slide client and Oracle XML Repository - error when using
jdbc/Oracle
I'm using the Slide Client libraries to upload a file via jdbc (container
Tomcat) to an Oracle XML DB Repository (using WebDAV protocol).
My problem is similar to the "PUT error when using jdbc/Oracle" thread, (all
works fine with samll files but if the size is over 30k i got the HHTP500
Internal Server Error caused by Oracle ORA-600 error) but i'm not using
Jakarta Slide Server and all works fine using File or byte[] instead of
InputStream at the constructor declaration:
Anyone can help me? Information for debug help follows:
----------------------------------------------------------------------------
-
1) Servlet code - I'm connecting to it via WebDAV using the following code:
import java.io.IOException;
import java.io.InputStream;
import java.net.MalformedURLException;
import org.apache.commons.httpclient.HttpException;
import org.apache.commons.httpclient.HttpURL;
import org.apache.log4j.Logger;
import org.apache.webdav.lib.WebdavResource;
public class WebDavSchema {
private static Logger log_ =
Logger.getLogger("com.sosinel.docreg.util.WebDavSchema");
/**
* Costruttore.
*
* @param theUrl String, webdav url;
* @param theUser String, webdav userid;
* @param thePassword String, webdav password;
* @param theNameSchema String, schema name;
* @param theSchema InputStream, data flow.
*/
public WebDavSchema(String theUrl, String theUser, String thePassword,
String theNameSchema, InputStream theSchema){
try
{
log_.debug("theUrl: " + theUrl);
HttpURL hrl = new HttpURL(theUrl);
log_.debug("theUser: " + theUser);
log_.debug("thePassword: " + thePassword);
hrl.setUserinfo(theUser,thePassword);
WebdavResource wdr = new WebdavResource(hrl);
log_.debug("theNameSchema: " + theNameSchema);
wdr.putMethod((wdr.getPath()+"/"+theNameSchema),theSchema);
wdr.close();
}
catch(MalformedURLException mue)
{
log_.debug("Eccezione MalformedURLException: " + mue.toString());
}
catch(HttpException he)
{
log_.debug("Eccezione HttpException: " + he.toString());
}
catch(IOException ioe)
{
log_.debug("Eccezione IOException: " + ioe.toString());
}
}
}
-----------------------------------------------------------------------
2) I got the following HTTP 500 Internal Server Error :
ORA-00600: internal error code, arguments: [kghssc_getbuf], [], [], [], [],
[], [], []
----------------------------------------------------------------------
3) The Oracle alert.log contains the following
Fri Jul 15 14:39:26 2005
Errors in file
/u01/oracle/product/9.2.0.1.0/oradata/orcl/bdump/orcl_s004_3693.trc:
ORA-00600: internal error code, arguments: [kghssc_getbuf], [], [], [], [],
[], [], []
Fri Jul 15 14:39:27 2005
Errors in file
/u01/oracle/product/9.2.0.1.0/oradata/orcl/bdump/orcl_s004_3693.trc:
ORA-00600: internal error code, arguments: [kghssc_getbuf], [], [], [], [],
[], [], []
I don't know how to analyze the trace file... is'n sufficently clear to
me....
Any idea?
Thanks
Andrea Faustini
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 14/07/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 14/07/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org