[ 
https://jira.duraspace.org/browse/DS-1435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=27470#comment-27470
 ] 

Hardy Pottinger commented on DS-1435:
-------------------------------------

returning to the debugger, I can see that at line 1835 of DatabaseManager.java

row.setColumn(getPrimaryKeyColumn(table), newID);

getPrimaryKeyColumn(table) is returning null, when fed 
"BITSTREAMFORMATREGISTRY" as the table name. Why?

By following the debugger a ways, I can see where the null is coming up, it's 
from when DSpace looks at the table to pull in column metadata (i.e. determine 
which column is a primary key). There are two methods which do this, get 
ColumnInfoInternal and retrieveColumnInfo. I never could see DSpace stepping in 
to retrieveColumnInfo, which goes directly to the DB for its information, so I 
commented out lines 1346-1349 in DatabaseManager

//        if (results != null)
//        {
//            return results;
//        }

to force DSpace to go to the DB for the data it needs. Alas, the null is still 
there... which tells me, I think, that something has changed with what the DB 
driver is returning when retrieveColumnInfo is run.

I'm not sure how to proceed at this point. I am grasping at straws, but I am 
considering trying to elevate the privileges I have given the dspace 
user/schema on this test Oracle DB on my notebook, thinking that perhaps I 
missed something in setting up this test db. 
                
> DSpace 3.0 Oracle compatibility
> -------------------------------
>
>                 Key: DS-1435
>                 URL: https://jira.duraspace.org/browse/DS-1435
>             Project: DSpace
>          Issue Type: Bug
>    Affects Versions: 3.0, 3.1
>         Environment: DSpace 3.0, Oracle back-end
>            Reporter: Hardy Pottinger
>            Assignee: Hardy Pottinger
>            Priority: Critical
>             Fix For: 3.1
>
>
> In my own personal experience, as well as the experience of other Oracle 
> institutions, as reported to the dspace-tech mail list (see [1] and [2]), 
> DSpace 3.0 is not currently capable of running on Oracle. This issue is a 
> place-holder until either I find, or someone else reports more specific 
> issues and problem areas that need addressing. It would be helpful if the 
> community could post specific error messages and stack traces as comments to 
> this ticket, so we can get a clearer understanding of what's going on.
> [1] 
> http://dspace.2283337.n4.nabble.com/Dspace-release-3-0-with-Oracle-td4660552.html
> [2] 
> http://dspace.2283337.n4.nabble.com/Ant-fresh-install-fails-with-Oracle-FATAL-org-dspace-administer-RegistryLoader-anonymous-error-loadi-td4660521.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to