Announcement Announcement Module
Collapse
No announcement yet.
How to retrive clob data using hibernate with springframework Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to retrive clob data using hibernate with springframework

    Hi

    when i try to retrive clob data from oracle 10g using hibernate3.1 and spring 2.0.5 ,i am getting the following error.


    Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
    at org.hibernate.exception.SQLStateConverter.handledN onSpecificException(SQLStateConverter.java:103)
    at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:91)
    at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.doList(Loader.java:214 7)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(L oader.java:2028)
    at org.hibernate.loader.Loader.list(Loader.java:2023)
    at org.hibernate.loader.criteria.CriteriaLoader.list( CriteriaLoader.java:95)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.ja va:1569)
    at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl. java:283)
    at com.kerio.ci.incident.dao.IncidentDAO.getTicketByI d(IncidentDAO.java:331)
    ... 75 more
    Caused by: java.sql.SQLException: ORA-04063: view "AXXERA.VW_TICKETS" has errors

    at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:166)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:304)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:271)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 622)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:180)
    at oracle.jdbc.driver.T4CPreparedStatement.execute_fo r_describe(T4CPreparedStatement.java:524)
    at oracle.jdbc.driver.OracleStatement.execute_maybe_d escribe(OracleStatement.java:990)
    at oracle.jdbc.driver.T4CPreparedStatement.execute_ma ybe_describe(T4CPreparedStatement.java:569)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1111)
    at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3039)
    at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3080)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.executeQuery(WrappedPreparedStatement.java: 236)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(Ab stractBatcher.java:186)
    at org.hibernate.loader.Loader.getResultSet(Loader.ja va:1668)
    at org.hibernate.loader.Loader.doQuery(Loader.java:66 2)
    at org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:224)
    at org.hibernate.loader.Loader.doList(Loader.java:214 4)
    ... 81 more
    19:01:56,171 ERROR [ViewTicketController] [Username:not passed in] [No message]
    19:01:56,171 INFO [ViewTicketController] After ViewTicketController onSubmit()
    19:01:56,875 ERROR [BindTag] Neither BindingResult nor plain target object for bean name 'newTicketForm' available as request attribute
    javax.servlet.jsp.JspTagException: Neither BindingResult nor plain target object for bean name 'newTicketForm' available as request attribute
    at org.springframework.web.servlet.tags.BindTag.doSta rtTagInternal(BindTag.java:119)
    at org.springframework.web.servlet.tags.RequestContex tAwareTag.doStartTag(RequestContextAwareTag.java:7 7)
    at org.apache.jsp.WEB_002dINF.jsp.incident.editTicket _jsp._jspService(editTicket_jsp.java:818)
    at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:810)
    at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:334)
    at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314)
    at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:810)

    can any one please provide the solution to solve the problem.
    if you need more details, i will attached with next message.

  • #2
    This is the forum for the Spring Integration project. You should try asking this question in the Data Access forum.

    However, based on the underlying SQL Exception, it looks like you have a problem in your view definition.

    Comment

    Working...
    X