WARN 2011-03-04 09:33:18 org.hibernate.util.JDBCExceptionReporter – SQL Error: 904, SQLState: 42000
the ERROR 2011-03-04 09:33:18 org. Hibernate. Util. JDBCExceptionReporter – ORA – 00904: “MENU0_”. “MENU_OPEN_IN_HOME” : identifier is invalid
Hibernate: select portletloc0_.PORTLET_LOCATION_ROW as col_0_0_, portletloc0_.PORTLET_LOCATION_COLUMN as col_1_0_, portlet1_.PORTLET_URL as col_2_0_, portlet1_.PORTLET_TITLE as col_3_0_, portletloc0_.PORTLET_ID as col_4_0_ from JEDA_PORTLET_LOCATION portletloc0_, JEDA_PORTLET portlet1_ where portletloc0_.PORTLET_ID=portlet1_.PORTLET_ID and portletloc0_.POSITION_ID=?order by portletloc0_.PORTLET_LOCATION_ROW asc, portletloc0_.PORTLET_LOCATION_COLUMN asc
2011-3-4 9:33:18 org.apache.catalina.core.StandardWrapperValve invoke
severity: servlet.service () for Servlet DispatcherServlet threw exception
java.sqlexception: “MENU0_”.”MENU_OPEN_IN_HOME”: identifier is invalid
the reason:
The attribute name of the
hbm. XML file does not correspond to the attribute name of the database
Read More:
- DB2 SQL ERROR: SQLCODE=-803, SQLSTATE=23505, SQL
- SQL Error: 1452, SQLState: 23000
- SQL Error: 17059, SQLState: 99999
- SQL error: 17006, sqlstate: 99999 invalid column name
- Solve a bug harvest of DB2 (sqlcode = – 805, sqlstate = 51002, error message = DB2 SQL error: sqlcode = – 805, sqlstate = 5100
- DB2 SQL error: sqlcode = – 433, sqlstate = 22001 solved
- DB2 SQL error: SQLCODE: -433, SQLSTATE: 22001, SQLERRMC
- DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703
- SQL Error: 0, SQLState: 08S01 & Communications link failure
- DB2 SQL error: sqlcode = – 803, sqlstate = 23505, sqlerrmc = 2 [solution]
- DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;,?,?,?,?,?,?,?,?);END-OF-STATEMENT
- SQL error: 156, sqlstate: S1000 error encountered in Hibernate
- How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
- Error when connecting to database: DB2 SQL error: sqlcode = – 204, sqlstate = 42704, sqlerrmc= YXUAT.CUST_ BLK_ REL, DRIVER=4.25.13
- Log error SQL Error: 1062, SQLState: 23000
- ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS sqlState
- Spring data JAP SQL error:17059 SQL State:99999
- SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error] with root
- Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the
- SAP SQL error “SQL code: -10692“ occurred while accessing table “ZTXXXX“.