Hi,
We are in the process of migrating our Postgresql database to Oracle and
encounter a problem with the most_recent_checksum table. This table contains
records with '' (empty strings) for expected_checksum and current_checksum when
to_be_processed=0.
Oracle returns an ORA-01400 error on these records
ORA-01400: cannot insert NULL into
("DSPACE"."MOST_RECENT_CHECKSUM"."EXPECTED_CHECKSUM")
Oracle interprets the empty string as NULL, while the columns are declared as
NOT NULL. I checked BitstreamInfoDAO. Here the empty string is also used for
the Oracle variant of the query. However when importing existing data this does
not seem to work. What value should we use to insert these empty strings?
Best wishes,
Francis Brouns
Open Universiteit Nederland
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
