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.


No comments:

Post a Comment