[Dspace-tech] 1.4.2 Upgrade problems
At our institution we are working with (Dspace 1.3.2 with Oracle 9) located at
http://dspace.uah.es/dspace and we haven't modified the schema locally.
Last Wednesday (6/27) tried to update of Dspace 1.3.2 to Dspace 1.4.2 but we
had problems with the updating of database. When we ran the SQL script for
Oracle database_schema_13-14.sql gave error because this script has some
errors as:
- CREATE SEQUENCE tasklistitem_seq (This sequence exist in the release 1.3.2)
- The function setval is invalid for Oracle.
- In Oracle the type VARCHAR needs to put the byte number.
- The sentence date_trunc('milliseconds', now() is invalid for Oracle.
.
However the database_schema1.4-142.sql is correct.
Brian Helstien in the message 2007-06-19 reports the Oracle error log. We don't
know if there is database_schema_13-14.sql for Oracle correct in somewhere to
download.
Regards,
M. JOSE GOMEZ
-
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
[Dspace-tech] can I use xml instead of RDBMS for backend support?
Hi, I am in a process of analysing the DSpace technology to implement in my project. My requirement is like this: 1) There will be around 50,000 reports in pdf formats 2) Index used in my case are customized.(name,account number, date...like this) 3) I just need to search through them to get the respective file corresponding to my indices. 4) there is no need for adding any further data in the store, just i need to browse through the the files, no need for addition. Please tell me , can I use xml for storing the metadata indexes to the pdf files?? or is it a mandatory requirement to have RDBMS support If yes then in which classes I have to look for changes Please reply at you earliest. Thanks in advance. Neetika DISCLAIMER: This message contains privileged and confidential information and is intended only for an individual named. If you are not the intended recipient, you should not disseminate, distribute, store, print, copy or deliver this message. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The sender, therefore, does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required, please request a hard-copy version. - 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
Re: [Dspace-tech] can I use xml instead of RDBMS for backend support?
On Fri, Jun 29, 2007 at 03:16:49PM +0530, [EMAIL PROTECTED] wrote: 4) there is no need for adding any further data in the store, just i need to browse through the the files, no need for addition. Please tell me , can I use xml for storing the metadata indexes to the pdf files?? or is it a mandatory requirement to have RDBMS support It's actually far more complicated than that. DSpace simply won't function without a database. You couldn't even have a format registry that told you it was a pdf without a database, let alone have user authentication, metadata, etc. The database is also used to store other information about the file such as size, name, location on disk, etc. cheers, Jim -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as HP CONFIDENTIAL. - 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
[Dspace-tech] Sort logic for search results
Hi... This may seem a dumb question, but what is the sort logic for search results in DSpace? I have been looking at the results and can't quite figure it out. *** George Kozak Coordinator Web Development and Management Digital Media Group 501 Olin Library Cornell University 607-255-8924 *** [EMAIL PROTECTED] - 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
[Dspace-tech] Using Dspace 1.5 with Eclipse, How??
Hi, Anybody know how to use the new, reorganized code structure of Dspace 1.5 with Eclipse?? Pointers in the right direction would help a lot. Kiran - 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
Re: [Dspace-tech] Using Dspace 1.5 with Eclipse, How??
Hi Kiran, you need the m2eclipse plugin. You can get it at http://m2eclipse.codehaus.org/ There are some instructions on the new build process in the wiki: http://wiki.dspace.org/index.php/SimpleAddonMechanism#How_does_one_.22Compile.22_and_.22package.22_a_distribution_of_DSpace.3F hope that helps Claudia Hi, Anybody know how to use the new, reorganized code structure of Dspace 1.5 with Eclipse?? Pointers in the right direction would help a lot. Kiran - 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 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
[Dspace-tech] Dstat.jar error
Hi, I'm getting a error when running stats. Has anyone seen it before, or knows what's going on. Thanks a bunch Ben [EMAIL PROTECTED] ~]# /dspace/bin/dsrun ac.ed.dspace.stats.LogAnalyser -start 2007-05-0 1 -end 2007-05-31 /dspace/custom_stats/stats.dat Exception in thread main org.postgresql.util.PSQLException: ERROR: Relation dctyperegistry does not exist at org.postgresql.core.v2.QueryExecutorImpl.receiveErrorMessage(QueryExe cutorImpl.java:557) at org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutor Impl.java:480) at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:364) at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:258) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat ement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract Jdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc 2Statement.java:255) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:2 59) at org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager. java:384) at org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager. java:395) at ac.ed.dspace.stats.LogAnalyser.getNumItems(LogAnalyser.java:1226) at ac.ed.dspace.stats.LogAnalyser.getNumItems(LogAnalyser.java:1246) at ac.ed.dspace.stats.LogAnalyser.processLogs(LogAnalyser.java:529) at ac.ed.dspace.stats.LogAnalyser.main(LogAnalyser.java:324) [EMAIL PROTECTED] ~]# - 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
