java.sql.SQLSyntaxErrorException: ORA-00904: "ITEM_ID": invalid identifier I will post the full stack trace below, but here is the "interesting bit":

Sakai JIRA | Hardy Pottinger | 2 years ago
  1. 0

    Running a branch based on a recent clone of DSpace:master (including the commit for the Metadata for All DSpace Objects code), and with Shibboleth Authentication configured, I can see the following error in dspace.log when I attempt to log in via Shibboleth: java.sql.SQLSyntaxErrorException: ORA-00904: "NETID": invalid identifier Here is the relevant section of the stack trace: at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:225) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseManager.java:372) at org.dspace.storage.rdbms.DatabaseManager.findByUnique(DatabaseManager.java:537) at org.dspace.eperson.EPerson.findByNetid(EPerson.java:226) at org.dspace.authenticate.ShibAuthentication.findEPerson(ShibAuthentication.java:588) at org.dspace.authenticate.ShibAuthentication.authenticate(ShibAuthentication.java:211) I brought this up on IRC in #dspace, and mhwood commented thusly: Looks like we missed one in Metadata4All. EPerson.findByNetid is calling DatabaseManager.findByUnique when it should be looking up EPerson E JOIN MetadataValue M on somethingorother WHERE M.value = theNetID etc. Mark had to leave for the day, but he signed off with this comment: "JOIN USING not JOIN ON, I think" I will have to leave shortly, so I at least wanted to create this ticket to alert everyone to the issue, maybe we can put our heads together early next week and iron this one out?

    Sakai JIRA | 2 years ago | Hardy Pottinger
    java.sql.SQLSyntaxErrorException: ORA-00904: "NETID": invalid identifier Here is the relevant section of the stack trace:
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    Running a branch based on a recent clone of DSpace:master (including the commit for the Metadata for All DSpace Objects code), and with Shibboleth Authentication configured, I can see the following error in dspace.log when I attempt to log in via Shibboleth: java.sql.SQLSyntaxErrorException: ORA-00904: "NETID": invalid identifier Here is the relevant section of the stack trace: at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:225) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseManager.java:372) at org.dspace.storage.rdbms.DatabaseManager.findByUnique(DatabaseManager.java:537) at org.dspace.eperson.EPerson.findByNetid(EPerson.java:226) at org.dspace.authenticate.ShibAuthentication.findEPerson(ShibAuthentication.java:588) at org.dspace.authenticate.ShibAuthentication.authenticate(ShibAuthentication.java:211) I brought this up on IRC in #dspace, and mhwood commented thusly: Looks like we missed one in Metadata4All. EPerson.findByNetid is calling DatabaseManager.findByUnique when it should be looking up EPerson E JOIN MetadataValue M on somethingorother WHERE M.value = theNetID etc. Mark had to leave for the day, but he signed off with this comment: "JOIN USING not JOIN ON, I think" I will have to leave shortly, so I at least wanted to create this ticket to alert everyone to the issue, maybe we can put our heads together early next week and iron this one out?

    Sakai JIRA | 2 years ago | Hardy Pottinger
    java.sql.SQLSyntaxErrorException: ORA-00904: "NETID": invalid identifier Here is the relevant section of the stack trace:
  4. 0

    jposee oracle error

    Google Groups | 7 months ago | Peiter Brown
    org.hibernate.tool.schema.spi.SchemaManagementException: Unable to execute schema management to JDBC target [create table revision (id number(19,0) not null, date timestamp, info long, ref varchar2(64 char), author number(19,0), primary key (id))]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-00904: "ITEM_ID": invalid identifier I will post the full stack trace below, but here is the "interesting bit":

      at org.dspace.storage.rdbms.DatabaseManager.execute()
    2. DSpace Kernel :: API and Implementation
      Item.update
      1. org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:1145)
      2. org.dspace.storage.rdbms.DatabaseManager.doInsertGeneric(DatabaseManager.java:1876)
      3. org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:718)
      4. org.dspace.content.MetadataValue.create(MetadataValue.java:293)
      5. org.dspace.content.DSpaceObject.updateMetadata(DSpaceObject.java:256)
      6. org.dspace.content.Item.update(Item.java:1100)
      6 frames