hi,

When i am trying to retrieve resultset from database i am getting
ClassCastException i.e.
java.math.BigInteger.Here actually iam using EJB3.0.in database the
datatype of the
column is 'bigint'.but when i am trying to retrieve resultset by using
EntityManager's createNativeQuery its giving this exception.

javax.ejb.EJBException: java.lang.ClassCastException:
java.math.BigInteger
    at
org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:69)
    at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)
    at
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:192)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:54)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225)
    at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:104)
    at
org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
    at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:828)
    at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:681)
    at
org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:358)
    at
org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:412)
    at
org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:239)
Caused by: java.lang.ClassCastException: java.math.BigInteger
    at
com.hqs.ppsadvantage.ejb.PatientSearchBean.searchPatientByPrimaryAndSecondary(Unknown
Source)
    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:585)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:109)
    at
org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
    at
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:192)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:54)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225)
    at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:104)
    at
org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
    at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:828)
    at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:681)
    at
org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:358)
    at
org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:412)
    at
org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:239)
    at
org.jboss.remoting.RemoteClientInvoker.invoke(RemoteClientInvoker.java:190)
    at org.jboss.remoting.Client.invoke(Client.java:525)
    at org.jboss.remoting.Client.invoke(Client.java:488)
    at
org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:55)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(ClientTxPropagationInterceptor.java:61)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.aspects.security.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:55)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:65)
    at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
    at
org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:102)
    at $Proxy2.searchPatientByPrimaryAndSecondary(Unknown Source)
    at com.hqs.ppsadvantage.bo.SearchBO.searchPatient(Unknown Source)
    at com.hqs.ppsadvantage.utils.TestSearchBO.main(Unknown Source)