Tim,
Here are the last 100 of catalina.out and my browser/tomcat
response. In making 1.3.2 work with Oracle, we needed to change
Item/History/Registration Data tables from Timestamp to Date. The
ORA-01858 makes me think that I've another table attribute value that
needs to be modified, but ...what'a I know?
bash-2.05b$ tail -100 catalina.out
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at ORG.oclc.oai.server.OAIHandler.getResult(OAIHandler.java:306)
at ORG.oclc.oai.server.OAIHandler.doGet(OAIHandler.java:225)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Thread.java:595)
java.lang.NullPointerException
at org.dspace.core.Utils.addEntities(Utils.java:261)
at
org.dspace.app.oai.DSpaceOAICatalog.listSets(DSpaceOAICatalog.java:660)
at
ORG.oclc.oai.server.verb.ListSets.construct(ListSets.java:107)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at ORG.oclc.oai.server.OAIHandler.getResult(OAIHandler.java:306)
at ORG.oclc.oai.server.OAIHandler.doGet(OAIHandler.java:225)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Thread.java:595)
java.lang.NullPointerException
at org.dspace.core.Utils.addEntities(Utils.java:261)
at
org.dspace.app.oai.DSpaceOAICatalog.listSets(DSpaceOAICatalog.java:660)
at
ORG.oclc.oai.server.verb.ListSets.construct(ListSets.java:107)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at ORG.oclc.oai.server.OAIHandler.getResult(OAIHandler.java:306)
at ORG.oclc.oai.server.OAIHandler.doGet(OAIHandler.java:225)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Thread.java:595)
java.lang.NullPointerException
at org.dspace.core.Utils.addEntities(Utils.java:261)
at
org.dspace.app.oai.DSpaceOAICatalog.listSets(DSpaceOAICatalog.java:660)
at
ORG.oclc.oai.server.verb.ListSets.construct(ListSets.java:107)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at ORG.oclc.oai.server.OAIHandler.getResult(OAIHandler.java:306)
at ORG.oclc.oai.server.OAIHandler.doGet(OAIHandler.java:225)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Thread.java:595)
HTTP Status 500 - java.sql.SQLException: ORA-01858: a non-numeric
character was found where a numeric was expected
------------------------------------------------------------------------
--------
type Status report
message java.sql.SQLException: ORA-01858: a non-numeric character was
found where a numeric was expected
description The server encountered an internal error
(java.sql.SQLException: ORA-01858: a non-numeric character was found
where a numeric was expected ) that prevented it from fulfilling this
request.
------------------------------------------------------------------------
--------
Apache Tomcat/5.5.17
Brian A. Helstien, SISD, MLS,
Director, Special Technologies Initiatives,
IDM, University Libraries x06913
University of Southern California, (213) 740-6913
Los Angeles, California, 90089 [EMAIL PROTECTED]
Information is independent of media or format
-----Original Message-----
From: Tim Donohue [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 21, 2007 9:51 AM
To: Brian Helstien
Cc: [email protected]
Subject: Re: [Dspace-tech] Implementing OAI-PMH as a Data Provider
Brian,
Could you also post the error log message from Tomcat/DSpace, to get
more details on the "Internal Server Error" that you are seeing?
More description of the underlying error should be logged in either
[tomcat]/logs or [dspace]/log/dspace.log (or both)
Without the actual underlying error message it's hard to say what is
going on.
You first "ListSets" request should have been a valid one (assuming you
have tomcat running on port 8180, and haven't renamed the
dspace-oai.war). As an example, if you ran something similar on our
UIUC DSpace site, you get back a proper OAI-PMH response (in an XML
browser display)
http://www.ideals.uiuc.edu/dspace-oai/request?verb=ListSets
- Tim
Brian Helstien wrote:
> I'm also trying to get OAI-PMH functional. I AM using tomcat and am
> sort of getting responses. Solaris 9/Dspace 1.3.2/Oracle 9i. Using
> http://re.cs.uct.ac.za/ pointed to my .../dspace-oai/request, I get a
> number of errors, such as the following;
>
> (4) Testing : ListSets
> URL : http://cassandra.usc.edu:8180/dspace-oai/request?verb=ListSets
> ------ Start of XML Response ------
> <html><head><title>Apache Tomcat/5.5.17 - Error
> report</title><style><!--H1
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525
> D7
> 6;font-size:22px;} H2
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525
> D7
> 6;font-size:16px;} H3
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525
> D7
> 6;font-size:14px;} BODY
> {font-family:Tahoma,Arial,sans-serif;color:black;background-color:whit
> e;
> } B
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525
> D7
> 6;} P
> {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font
> -s ize:12px;}A {color : black;}A.name {color : black;}HR {color :
> #525D76;}--></style> </head><body><h1>HTTP Status 500 - </h1><HR
> size="1" noshade="noshade"><p><b>type</b> Status
> report</p><p><b>message</b> <u></u></p><p><b>description</b> <u>The
> server encountered an internal error () that prevented it from
> fulfilling this request.</u></p><HR size="1"
> noshade="noshade"><h3>Apache Tomcat/5.5.17</h3></body></html>
> ------- End of XML Response -------
> Test Result : FAIL!
> **** [ERROR] Unexpected HTTP Error : 500 / Internal Server Error
>
> And using Tim's suggested
> http://localhost:8080/dspace-oai/request?verb=ListRecords&metadataPref
> ix =oai_dc, I either get an xml display in my browser or a tomcat 500
> error.
>
> <?xml version="1.0" encoding="UTF-8" ?>
> - <OAI-PMH xmlns="http://www.openarchives.org/OAI/2.0/";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/
> http://www.openarchives.org/OAI/2.0/OAI-PMH.xsd";>
> <responseDate>2007-02-21T00:00:04Z</responseDate>
> <request>http://cassandra.usc.edu:8180/dspace-oai/request</request>
> <error code="badVerb">Illegal verb</error>
> </OAI-PMH>
>
> I've all the appropriate jar files in the locations discussed in the
> last few days. Could someone point me in the right direction as to
> what to look for?
>
> Brian A. Helstien, SISD, MLS,
> Director, Special Technologies Initiatives,
> IDM, University Libraries
x06913
> University of Southern California, (213) 740-6913
> Los Angeles, California, 90089 [EMAIL PROTECTED]
> Information is independent of media or format
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> [EMAIL PROTECTED]
> Sent: Tuesday, February 20, 2007 12:07 PM
> To: [email protected]
> Subject: DSpace-tech Digest, Vol 10, Issue 49
>
> Send DSpace-tech mailing list submissions to
> [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> or, via email, send a message with subject or body 'help' to
> [EMAIL PROTECTED]
>
> You can reach the person managing the list at
> [EMAIL PROTECTED]
>
> When replying, please edit your Subject line so it is more specific
> than
> "Re: Contents of DSpace-tech digest..."
>
>
> Today's Topics:
>
> 1. Re: Implementing OAI-PMH as a Data Provider (Tim Donohue)
> 2. Re: Implementing OAI-PMH as a Data Provider (Sue
> Walker-Thornton)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 20 Feb 2007 13:28:15 -0600
> From: Tim Donohue <[EMAIL PROTECTED]>
> Subject: Re: [Dspace-tech] Implementing OAI-PMH as a Data Provider
> To: Sue Walker-Thornton <[EMAIL PROTECTED]>
> Cc: [email protected]
> Message-ID: <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> Sue,
>
> The OAICat JAR that your noted actually comes bundled with DSpace (so
> it's there when you download DSpace).
>
> In fact, you really don't have to do much to implement OAI-PMH. It's
> all done for you. When you compile the DSpace software, it generates
> two ".war" files: dspace.war and dspace-oai.war (the former is the
> DSpace application, the latter being the OAI-PMH interface).
>
> Assuming you place the "dspace-oai.war" alongside your "dspace.war" in
> Tomcat, then your OAI-PMH base URL should be something like:
>
> http://localhost:8080/dspace-oai/request
> (you may need to replace "localhost" with your server-name)
>
> You can test it by passing the OAI-PMH "ListRecords" verb:
>
> http://localhost:8080/dspace-oai/request?verb=ListRecords&metadataPref
> ix
> =oai_dc
>
> Let us know if any of this still doesn't make sense or isn't working
> for you!
>
> - Tim
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
