Graham,
# Database name ("oracle", or "postgres")
#db.name = postgres
db.name = oracle
for connecting to database
db.url = jdbc:oracle:thin:@db-dev1.usc.edu:1521:dspacet
ojdbc14.jar
ocrs12.jar
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
________________________________
From: Graham Triggs [mailto:[EMAIL PROTECTED]
Sent: Sun 7/15/2007 11:31 AM
To: Brian Helstien; dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] Another Internal System Error
The 'trick' is to go down the stack trace until you find what is calling the
DatabaseManager - in this case, it's MetadataValue.create(), which means it
is trying to insert into the MetadataValue table.
This probably means it is complaining about the text_value column, which
is/should be a CLOB. If it is a CLOB, and it's being reported as an 'OTHER'
type, then this may be a problem with the drivers. What version of the
Oracle drivers are you using / what is your db.url?
G
----- Original Message -----
From: "Brian Helstien" <[EMAIL PROTECTED]>
To: <dspace-tech@lists.sourceforge.net>
Sent: Friday, July 13, 2007 5:31 PM
Subject: [Dspace-tech] Another Internal System Error
>I too need some analysis of an Internal System Error (Dspace 1.4.2). In
> attempting to submit something to my test instance, after filling out
> the items on the second step and selecting "next" I got the DEBUG error
> below. I'm using Oracle and understand the JDBC 1111 refers to a
> problem with the Oracle tables. Not sure which table, data type, etc I
> should be investigating.
>
> An internal server error occurred on
> http://cassandra.usc.edu:8180/dspace:
>
> Date: 7/13/07 9:25 AM
> Session ID: B9B08D52FA84D1E7B4D4EE95A2BF9EF0
>
> -- URL Was: http://cassandra.usc.edu:8180/dspace/submit
> -- Method: POST
> -- Parameters were:
> -- dc_type: "Article"
> -- dc_contributor_author_last_0: "Helstien"
> -- dc_relation_ispartofseries_1: "5678"
> -- submit_next: "Next >"
> -- dc_title: "My Test Submission"
> -- dc_contributor_author_first_0: "Brian"
> -- dc_identifier_value_0: "1234-5678"
> -- dc_identifier_qualifier_0: "issn"
> -- workspace_item_id: "82"
> -- dc_relation_ispartofseries_0: "1234"
> -- step: "2"
> -- dc_language_iso: "en_US"
>
>
> Exception:
> java.lang.IllegalArgumentException: Unsupported JDBC type: 1111
> at
> org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:14
> 87)
> at
> org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:815
> )
> at
> org.dspace.content.MetadataValue.create(MetadataValue.java:253)
> at org.dspace.content.Item.update(Item.java:1493)
> at
> org.dspace.content.WorkspaceItem.update(WorkspaceItem.java:473)
> at
> org.dspace.app.webui.servlet.SubmitServlet.userHasReached(SubmitServlet.
> java:2209)
> at
> org.dspace.app.webui.servlet.SubmitServlet.processEditMetadata(SubmitSer
> vlet.java:963)
> at
> org.dspace.app.webui.servlet.SubmitServlet.doDSPost(SubmitServlet.java:3
> 82)
> at
> org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.
> java:147)
> at
> org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105
> )
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> 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.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnly
> Filter.java:98)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> 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)
>
> 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: Friday, July 13, 2007 8:59 AM
> To: dspace-tech@lists.sourceforge.net
> Subject: DSpace-tech Digest, Vol 15, Issue 28
>
> Send DSpace-tech mailing list submissions to
> dspace-tech@lists.sourceforge.net
>
> 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. need your help again - internal system error (Felix Mayerhofer)
> 2. Re: Dspace vs Greenstone (George Kozak)
> 3. Re: need your help again - internal system error
> (Felix Mayerhofer)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 13 Jul 2007 17:32:33 +0200
> From: "Felix Mayerhofer" <[EMAIL PROTECTED]>
> Subject: [Dspace-tech] need your help again - internal system error
> To: <dspace-tech@lists.sourceforge.net>
> Message-ID:
>
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi folks!
>
>
>
> Just testing around with my new installation, and it seems dspace
> doesn't run properly, evey time I try to make an upload I get an
> internal server error
>
>
>
> Could this happen when visit the site via ip address, cuz the hostname I
> provided doesn't exist yet?
>
>
>
>
>
> Hope somebody can help!
>
>
>
>
>
> Here's the email alert:
>
>
>
> An internal server error occurred on http://dspace.myhost.com/dspace:
>
>
>
> Date: 12.07.07 09:32
>
> Session ID: E7EA989FF6CF5E948DB68CC33AD0621D
>
>
>
> -- URL Was: http://192.168.36.175:8080/dspace/submit
> <http://192.168.36.175:8080/dspace/submit>
>
> -- Method: POST
>
> -- Parameters were:
>
> -- dc_identifier_value_0: ""
>
> -- step: "2"
>
> -- dc_relation_ispartofseries_1: ""
>
> -- dc_identifier_qualifier_0: "issn"
>
> -- dc_relation_ispartofseries_0: ""
>
> -- dc_contributor_author_last_0: "45645"
>
> -- dc_language_iso: ""
>
> -- submit_next: "Next >"
>
> -- dc_title: "zrtztrztrzrtzrz"
>
> -- dc_contributor_author_first_0: "ertrzrtztr"
>
> -- workspace_item_id: "10"
>
> -- dc_type: "Book"
>
>
>
>
>
> Exception:
>
> java.sql.SQLException: bad_dublin_core SchemaID=1, contributor author
>
> at org.dspace.content.Item.update(Item.java:1463)
>
> at org.dspace.content.WorkspaceItem.update(WorkspaceItem.java:473)
>
> at
> org.dspace.app.webui.servlet.SubmitServlet.userHasReached(SubmitServlet.
> java:2209)
>
> at
> org.dspace.app.webui.servlet.SubmitServlet.processEditMetadata(SubmitSer
> vlet.java:963)
>
> at
> org.dspace.app.webui.servlet.SubmitServlet.doDSPost(SubmitServlet.java:3
> 82)
>
> at
> org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.
> java:147)
>
> at
> org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105
> )
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>
> 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.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnly
> Filter.java:98)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:214)
>
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:104)
>
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
> 20)
>
> at
> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon
> textValve.java:198)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java:152)
>
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:104)
>
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
> 20)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :137)
>
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:104)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :118)
>
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:102)
>
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
> 20)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
> java:109)
>
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:104)
>
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
> 20)
>
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
>
> at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
>
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:79
> 9)
>
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
> onnection(Http11Protocol.java:705)
>
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:57
> 7)
>
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
> .java:684)
>
> at java.lang.Thread.run(Thread.java:619)
>
>
>
>
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
> Date: Fri, 13 Jul 2007 11:43:17 -0400
> From: George Kozak <[EMAIL PROTECTED]>
> Subject: Re: [Dspace-tech] Dspace vs Greenstone
> To: Twaha Daudi <[EMAIL PROTECTED]>,
> dspace-tech@lists.sourceforge.net
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset="us-ascii"
>
> Twaha:
>
> We at Cornell University use both DSpace and Greenstone, but for
> different purposes. DSpace is our institutional repository where we
> store videos, presentations, papers and books. Greenstone is used as a
> Newspaper archive for our Campus Newspaper. So, they are used very
> differently.
>
> At 11:03 AM 7/13/2007, Twaha Daudi wrote:
>>Hi alll,
>>Good day!.
>>I would like to know which is the best between Dspace and Greenstone in
>
>>terms of easy to install and configure,learning curve,performance and
>>usability in Library.
>>Thank you for your help
>>udd
>>
>>
>>Need a vacation?
>><http://us.rd.yahoo.com/evt=48256/*http://travel.yahoo.com/;_ylc=X3oDMT
>>FhN2hucjlpBF9TAzk3NDA3NTg5BHBvcwM1BHNlYwNncm91cHMEc2xrA2VtYWlsLW5jbQ-->
>>Get great deals to amazing places on Yahoo! Travel.
>>-----------------------------------------------------------------------
>>-- This SF.net email is sponsored by DB2 Express Download DB2 Express C
>
>>- the FREE version of DB2 express and take control of your XML. No
>>limits. Just data. Click to get it now.
>>http://sourceforge.net/powerbar/db2/
>>
>>_______________________________________________
>>DSpace-tech mailing list
>>DSpace-tech@lists.sourceforge.net
>>https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
> ***************************
> George Kozak
> Coordinator
> Web Development and Management
> Digital Media Group
> 501 Olin Library
> Cornell University
> 607-255-8924
> ***************************
> [EMAIL PROTECTED]
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 3
> Date: Fri, 13 Jul 2007 17:59:10 +0200
> From: "Felix Mayerhofer" <[EMAIL PROTECTED]>
> Subject: Re: [Dspace-tech] need your help again - internal system
> error
> To: "George Kozak" <[EMAIL PROTECTED]>
> Cc: dspace-tech@lists.sourceforge.net
> Message-ID:
>
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset="us-ascii"
>
> Ok i tried now but i doesnt work, it killed my dspace.cfg file L
>
>
>
> Content of the file is now:
>
>
>
> Unable to locate tools.jar. Expected to find it in
> /usr/lib/jvm/java-1.4.2-gcj-4.1-1.4.2.0/lib/tools.jar
>
> Apache Ant version 1.6.5 compiled on October 26 2005
>
> Buildfile: build.xml does not exist!
>
>
>
> In my /usr/lib/jvm/java-1.4.2-gcj-4.1-1.4.2.0 folder a directory lib
> doesn't exist!
>
>
>
> Really confused now
>
> Von: George Kozak [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 13. Juli 2007 17:46
> An: Felix Mayerhofer
> Betreff: Re: [Dspace-tech] need your help again - internal system error
>
>
>
> Felix:
>
> It looks to me like you need to change the DSPace hostname dspace.cfg
> file to what you are really using and then do an "ant
> -Dconfig=>(path-to-config file)/dspace.cfg update"
>
> At 11:32 AM 7/13/2007, you wrote:
>
>
>
> Hi folks!
>
> Just testing around with my new installation, and it seems dspace
> doesn't run properly, evey time I try to make an upload I get an
> internal server error
>
> Could this happen when visit the site via ip address, cuz the hostname I
> provided doesn't exist yet?
>
>
> Hope somebody can help!
>
>
> Here's the email alert:
>
> An internal server error occurred on http://dspace.myhost.com/dspace:
>
> Date: 12.07.07 09:32
> Session ID: E7EA989FF6CF5E948DB68CC33AD0621D
>
> -- URL Was: http://192.168.36.175:8080/dspace/submit
> -- Method: POST
> -- Parameters were:
> -- dc_identifier_value_0: ""
> -- step: "2"
> -- dc_relation_ispartofseries_1: ""
> -- dc_identifier_qualifier_0: "issn"
> -- dc_relation_ispartofseries_0: ""
> -- dc_contributor_author_last_0: "45645"
> -- dc_language_iso: ""
> -- submit_next: "Next >"
> -- dc_title: "zrtztrztrzrtzrz"
> -- dc_contributor_author_first_0: "ertrzrtztr"
> -- workspace_item_id: "10"
> -- dc_type: "Book"
>
>
> Exception:
> java.sql.SQLException: bad_dublin_core SchemaID=1, contributor author
> at org.dspace.content.Item.update(Item.java:1463)
> at org.dspace.content.WorkspaceItem.update(WorkspaceItem.java:473)
> at
> org.dspace.app.webui.servlet.SubmitServlet.userHasReached(SubmitServlet.
> java:2209)
> at
> org.dspace.app.webui.servlet.SubmitServlet.processEditMetadata(SubmitSer
> vlet.java:963)
> at
> org.dspace.app.webui.servlet.SubmitServlet.doDSPost(SubmitServlet.java:3
> 82)
> at
> org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.
> java:147)
> at
> org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105
> )
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> 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.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnly
> Filter.java:98)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:214)
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:104)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
> 20)
> at
> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon
> textValve.java:198)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java:152)
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:104)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
> 20)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :137)
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:104)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :118)
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:102)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
> 20)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
> java:109)
> at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
> ntext.java:104)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
> 20)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
> at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:79
> 9)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
> onnection(Http11Protocol.java:705)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:57
> 7)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
> .java:684)
> at java.lang.Thread.run(Thread.java:619)
>
>
>
> ------------------------------------------------------------------------
> -
> This SF.net email is sponsored by DB2 Express Download DB2 Express C -
> the FREE version of DB2 express and take control of your XML. No limits.
> Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
>
> _______________________________________________
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
> ***************************
> George Kozak
> Coordinator
> Web Development and Management
> Digital Media Group
> 501 Olin Library
> Cornell University
> 607-255-8924
> ***************************
> [EMAIL PROTECTED]
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> ------------------------------------------------------------------------
> -
> This SF.net email is sponsored by DB2 Express Download DB2 Express C -
> the FREE version of DB2 express and take control of your XML. No limits.
> Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
>
> ------------------------------
>
> _______________________________________________
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
> End of DSpace-tech Digest, Vol 15, Issue 28
> *******************************************
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
This email has been scanned by Postini.
For more information please visit http://www.postini.com
<http://www.postini.com/>
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
