Labels

Tuesday, October 21, 2014

java.sql.SQLException: ORA-04063: view

java.sql.SQLException: ORA-04063: view "XXXXX

 oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
 oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
 oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
 oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
 oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
 oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
 oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
 oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
 oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
 oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
 oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
 oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
 oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
 org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
 org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:698)
 org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:112)
 org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:122)
 

Solution:- If it is not finding related view we will get this error.To fix issue we need to create related view.


Monday, October 20, 2014

PreparedStatementCallback; bad SQL grammar nested exception is java.sql.SQLException: ORA-00980

ERROR [com..AN010Action] - PreparedStatementCallback; bad SQL grammar [ SELECT ? ]; nested exception is java.sql.SQLException: ORA-00980: シノニム変換が無効です。

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar nested exception is java.sql.SQLException: ORA-00980: シノニム変換が無効です。

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:111)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:187)
at com.gehc.ohr.common.dao.BaseDao.queryList(BaseDao.java:20)
at com.gehc.ohr.common.dao.impl.LoginSearchDaoImpl.searchUserInfo(LoginSearchDaoImpl.java:41)
at com.gehc.ohr.common.service.impl.LoginServiceImpl.getUserInfo(LoginServiceImpl.java:30)
at com.gehc.ohr.common.action.BaseAction.getUserSession(BaseAction.java:258)
at com.gehc.ohr.common.action.BaseAction.baseExecute(BaseAction.java:188)
at com.gehc.ohr.common.action.BaseAction.execute(BaseAction.java:133)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableReque



Solution:- If it is not finding related view we will get this error.To fix issue we need to create related view.