Not able to fetch data from Oracle DB

[Shikha bajpai]

Hi All,

I am using Hibernate 3.0, JPA (spring-orm-3.0.3.RELEASE.jar) and Oracle 11G for our project. Project is running in JBOSS 5.1.0GA.

In Oracle we are having one table ( EP) with one COlumn as XMLTYPE datatype.

In JPA Entity defined as with XMLTYPE column type:

@Column(name = "PAYLOAD_YOGTEST", columnDefinition="XMLCOLUMN XMLType") //nullable = true, length = 255)
    private String payload; 

when I am running this code always getting below exception:

2015-02-24 17:20:16,993 INFO  [STDOUT] (http-127.0.0.1-8080-5) Hibernate: select errorpaylo0_.ERROR_EVENT_GUID as ERROR1_62_0_, errorpaylo0_.CREATED_DATE as CREATED2_62_0_, errorpaylo0_.CREATED_USER as CREATED3_62_0_, errorpaylo0_.MODIFIED_DATE as MODIFIED4_62_0_, errorpaylo0_.MODIFIED_USER as MODIFIED5_62_0_, errorpaylo0_.PAYLOAD_YOGTEST as PAYLOAD6_62_0_, errorpaylo0_.VERSION as VERSION62_0_ from ERROR_PAYLOAD errorpaylo0_ where errorpaylo0_.ERROR_EVENT_GUID=?
2015-02-24 17:20:39,273 WARN  [org.hibernate.util.JDBCExceptionReporter] (http-127.0.0.1-8080-5) SQL Error: 17002, SQLState: 08006
2015-02-24 17:20:39,273 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-127.0.0.1-8080-5) Io exception: Socket read timed out
2015-02-24 17:20:39,273 INFO  [org.hibernate.event.def.DefaultLoadEventListener] (http-127.0.0.1-8080-5) Error performing load command
org.hibernate.exception.JDBCConnectionException: could not load an entity: [com.fts.wiley.ehs.core.ErrorPayload#00352275-F6C4-4E55-9DB5-B3BFE51DDDF2]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.loadEntity(Loader.java:1798)
	at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
	at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
	at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2977)
	at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:393)
	at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374)
	at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137)
	at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
	at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
	at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
	at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
	at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
	at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365)
	at $Proxy318.find(Unknown Source)
	at org.springframework.orm.jpa.JpaTemplate$1.doInJpa(JpaTemplate.java:231)
	at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:183)
	at org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:229)
	at com.fts.wiley.ehs.dao.GenericDAOImpl.get(GenericDAOImpl.java:107)
	at com.fts.wiley.ehs.dao.GenericDAOImpl$$FastClassByCGLIB$$a90820b.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
	at com.fts.wiley.ehs.dao.GenericDAOImpl$$EnhancerByCGLIB$$7989bf2e.get(<generated>)
	at com.fts.wiley.ehs.dao.ErrorPayloadDAOImpl.findErrorPayloadById(ErrorPayloadDAOImpl.java:105)
	at com.fts.wiley.ehs.service.ErrorPayloadServiceImpl.findErrorPayloadById(ErrorPayloadServiceImpl.java:104)
	at com.fts.wiley.ehs.service.ErrorPayloadServiceImpl.findErrorPayloadById(ErrorPayloadServiceImpl.java:159)
	at com.fts.wiley.ehs.service.ErrorPayloadServiceImpl$$FastClassByCGLIB$$60303742.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
	at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
	at com.fts.wiley.ehs.service.ErrorPayloadServiceImpl$$EnhancerByCGLIB$$affec58b.findErrorPayloadById(<generated>)
	at com.fts.wiley.ehs.web.util.ServiceHelper.getPayload(ServiceHelper.java:342)
	at com.fts.wiley.ehs.web.controller.SearchWorkListController.viewErrDetails(SearchWorkListController.java:564)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.el.parser.AstValue.invoke(AstValue.java:170)
	at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
	at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
	at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:99)
	at javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
	at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:771)
	at javax.faces.component.UICommand.broadcast(UICommand.java:372)
	at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
	at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
	at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
	at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
	at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
	at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
	at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
	at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
	at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
	at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.fts.wiley.ehs.web.logic.EHSWebAuthenticationFilter.doFilter(EHSWebAuthenticationFilter.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.fts.wiley.ehs.web.logic.EHSWebSessionTimeoutFilter.doFilter(EHSWebSessionTimeoutFilter.java:61)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:662)

Can you please let me know what the problem in mapping. I am not getting the issue and its resolution.

Persistence.xml is having dialect and JPA as below:

<properties>
<!-- Transaction integration -->
<property name="hibernate.transaction.factory_class"
value="org.hibernate.ejb.transaction.JoinableCMTTransactionFactory" />
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup" />
<property name="jboss.entity.manager.factory.jndi.name"
value="persistence-units/JpaPersistence" />
<property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>
<property name="hibernate.hbm2ddl.auto" value="validation" />

</properties>
</persistence-unit>
</persistence>

Thanks

[Rafael de Sousa]

Hi Shikha bajpai,

Try this,

@Column(name = "PAYLOAD_YOGTEST", columnDefinition="XMLType") //nullable = true, length = 255)
private String payload;

if you still haven't lucky, try to convert the column

@ColumnTransformer(read = "to_clob(data)", write = "?")
@Column(name = "PAYLOAD_YOGTEST", columnDefinition="XMLType") //nullable = true, length = 255)
private String payload;

Cheers!

[Shikha bajpai]

Hi Rafael

Thanks for your reply. But I am using Hibernate3 jar which is not having ColumnTransformer annotation class. I can't use Hibernate 3.6.0 jar as this will impact current Project structure. Is there any other way to resolve this issue. Please help me.

Also first one also I tried, but still in same condition.

Thanks
Shikha