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

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. 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 | 3 years ago | Dima Svider
    java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression
  6. 0

    ORA-00918: "Column ambiguously defined"

    Stack Overflow | 2 years ago | Flash_Back
    java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined

  1. rafafviola 1 times, last 1 month ago
  2. wendellpereira 128 times, last 2 months ago
  3. balintn 4 times, last 2 months ago
  4. balintn 3 times, last 3 months ago
  5. pnaranja 2 times, last 4 months ago
1 more registered users
30 unregistered visitors
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