java.sql.SQLSyntaxErrorException: ORA-00904: "NETID": invalid identifier Here is the relevant section of the stack trace:

Sakai JIRA | Hardy Pottinger | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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. 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:
  3. 0

    Extend a baseclass and perform findById in Hibernate

    Stack Overflow | 3 years ago | user3018766
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not load an entity: [ExtendedClass#1011361]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ora-00979 not a GROUP BY expression error

    Stack Overflow | 4 years ago | Dima Svider
    java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression
  6. 0

    ORA-00918: "Column ambiguously defined"

    Stack Overflow | 3 years ago | Flash_Back
    java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
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: "NETID": invalid identifier Here is the relevant section of the stack trace:

    at oracle.jdbc.driver.T4CTTIfun.receive()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    2. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    3. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    4. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    5. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
    6. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
    7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
    8. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
    10. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    10 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    3. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    3 frames
  4. DSpace Kernel :: API and Implementation
    ShibAuthentication.authenticate
    1. org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:225)
    2. org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseManager.java:372)
    3. org.dspace.storage.rdbms.DatabaseManager.findByUnique(DatabaseManager.java:537)
    4. org.dspace.eperson.EPerson.findByNetid(EPerson.java:226)
    5. org.dspace.authenticate.ShibAuthentication.findEPerson(ShibAuthentication.java:588)
    6. org.dspace.authenticate.ShibAuthentication.authenticate(ShibAuthentication.java:211)
    6 frames