Re: [eclipselink-users] Fw: CriteriaQuery.where()??

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Fw: CriteriaQuery.where()??
From: Frank Schwarz <fs5@xxxxxxx>
Date: Thu, 11 Nov 2010 14:11:10 -0800 (PST)
Delivered-to: eclipselink-users@xxxxxxxxxxx
List-archive: <https://dev.eclipse.org/mailman/private/eclipselink-users>
List-help: <mailto:eclipselink-users-request@eclipse.org?subject=help>
List-subscribe: <https://dev.eclipse.org/mailman/listinfo/eclipselink-users>, <mailto:eclipselink-users-request@eclipse.org?subject=subscribe>
List-unsubscribe: <https://dev.eclipse.org/mailman/options/eclipselink-users>, <mailto:eclipselink-users-request@eclipse.org?subject=unsubscribe>
Sorry for being rude. Quise decir que con los excepciones siempre conviene
leerlas hasta el final ;-). O sea, lo del fallo en el tns (Transparent
Network Substrate) fue la raíz del problema.

-- Frank


Oggie wrote:
> 
> Excuse me Frank. I have pasted the exception and I have not seen the words 
> in Spanish.
> 
> Translated into English it is something like TNS: fail in the package 
> writer.
> 
> I do not know what it means but no problem, it was a fail of my system and 
> not about anything else.
> 
> --------------------
> Jose
> 
> --------------------------------------------------
> From: "Frank Schwarz" <fs5@xxxxxxx>
> Sent: Wednesday, November 10, 2010 7:00 AM
> To: <eclipselink-users@xxxxxxxxxxx>
> Subject: Re: [eclipselink-users] Fw:  CriteriaQuery.where()??
> 
>>
>> Caused by: java.sql.SQLException: ORA-12571: TNS:fallo en el escritor del
>> paquete
>>
>> -- Frank
>>
>>
>> Oggie wrote:
>>>
>>> At the end I have got to code the following method,public Usuarios
>>> findUsuario(String usuario, String clave) {        CriteriaBuilder
>>> queryBuilder = getEntityManager().getCriteriaBuilder();
>>> CriteriaQuery<Usuarios> queryDefinition =
>>> queryBuilder.createQuery(Usuarios.class);        Root<Usuarios> usuarios 
>>> =
>>> queryDefinition.from(Usuarios.class);        Expression<Boolean>
>>> expUsuario = queryBuilder.equal(usuarios.get("usuario"), usuario);
>>> Expression<Boolean> expClave = queryBuilder.equal(usuarios.get("clave"),
>>> clave);
>>> queryDefinition.select(usuarios).where(queryBuilder.and(expUsuario,
>>> expClave));        return
>>> getEntityManager().createQuery(queryDefinition).getSingleResult();}but
>>> even building the correct query, it gives me the following
>>> exception,javax.faces.el.EvaluationException: javax.ejb.EJBException
>>> at
>>> javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
>>> at
>>> com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
>>> at javax.faces.component.UICommand.broadcast(UICommand.java:315)
>>> at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:775)
>>> at
>>> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1267)
>>> at
>>> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
>>> at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
>>> at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
>>> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)
>>> at
>>> org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523)
>>> at
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
>>> at
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)
>>> at
>>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641)
>>> at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:97)
>>> at
>>> com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:85)
>>> at
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:185)
>>> at
>>> org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325)
>>> at
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:226)
>>> at
>>> com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:165)
>>> at
>>> com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791)
>>> at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693)
>>> at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954)
>>> at
>>> com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170)
>>> at
>>> com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135)
>>> at
>>> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102)
>>> at
>>> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88)
>>> at
>>> com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
>>> at
>>> com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53)
>>> at
>>> com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57)
>>> at com.sun.grizzly.ContextTask.run(ContextTask.java:69)
>>> at
>>> com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330)
>>> at
>>> com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309)
>>> at java.lang.Thread.run(Thread.java:619)
>>> Caused by: javax.ejb.EJBException
>>> at
>>> com.sun.ejb.containers.BaseContainer.processSystemException(BaseContainer.java:5119)
>>> at
>>> com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:5017)
>>> at
>>> com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4805)
>>> at
>>> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2004)
>>> at
>>> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1955)
>>> at
>>> com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:198)
>>> at
>>> com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:84)
>>> at $Proxy326.findUsuario(Unknown Source)
>>> at
>>> ejb.__EJB31_Generated__UsuariosFacade__Intf____Bean__.findUsuario(Unknown
>>> Source)
>>> at bean.LoginManagedBean.login(LoginManagedBean.java:36)
>>> 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 com.sun.el.parser.AstValue.invoke(AstValue.java:234)
>>> at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
>>> at
>>> com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:98)
>>> at
>>> javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
>>> ... 32 more
>>> Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services -
>>> 2.0.1.v20100213-r6600):
>>> org.eclipse.persistence.exceptions.DatabaseException
>>> Internal Exception: java.sql.SQLException: ORA-12571: TNS:fallo en el
>>> escritor del paquete
>>>
>>> Error Code: 12571
>>> Call: SELECT USERID, USUARIO, DESCRIPCION, CLAVE FROM USUARIOS WHERE
>>> ((USUARIO = ?) AND (CLAVE = ?))
>>> bind => [TR, TR]
>>> Query: ReadAllQuery(referenceClass=Usuarios sql="SELECT USERID, USUARIO,
>>> DESCRIPCION, CLAVE FROM USUARIOS WHERE ((USUARIO = ?) AND (CLAVE = ?))")
>>> at
>>> org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
>>> at
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1422)
>>> at
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:679)
>>> at
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:530)
>>> at
>>> org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529)
>>> at
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
>>> at
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
>>> at
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:262)
>>> at
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:618)
>>> at
>>> org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2537)
>>> at
>>> org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2496)
>>> at
>>> org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:455)
>>> at
>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:997)
>>> at
>>> org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:675)
>>> at
>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:958)
>>> at
>>> org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:432)
>>> at
>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1021)
>>> at
>>> org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2857)
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1225)
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1299)
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1299)
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1299)
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1299)
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1207)
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1181)
>>> at
>>> org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:453)
>>> at
>>> org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:714)
>>> at ejb.UsuariosFacade.findUsuario(UsuariosFacade.java:60)
>>> 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.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1056)
>>> at
>>> org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1128)
>>> at
>>> com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:5292)
>>> at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:615)
>>> at
>>> com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:797)
>>> at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:567)
>>> at
>>> com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doAround(SystemInterceptorProxy.java:157)
>>> at
>>> com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:139)
>>> 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
>>> com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:858)
>>> at
>>> com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:797)
>>> at
>>> com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:367)
>>> at
>>> com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:5264)
>>> at
>>> com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:5252)
>>> at
>>> com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:190)
>>> ... 44 more
>>> Caused by: java.sql.SQLException: ORA-12571: TNS:fallo en el escritor
>>> del
>>> paquete
>>>
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:672)
>>> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:598)
>>> at
>>> oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
>>> at
>>> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
>>> at
>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
>>> at
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:892)
>>> at
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:602)
>>> ... 91 more
>>>
>>>
>>> From: Jose Alvarez de Lara
>>> Sent: Tuesday, November 09, 2010 1:45 PM
>>> To: EclipseLink-Users
>>> Subject: [eclipselink-users] CriteriaQuery.where()??
>>>
>>>
>>> Hi,
>>>
>>> I am developing a workflow and I need to optimize a query form inside an
>>> Ejb 3.1
>>>
>>> My code is as follows,
>>>
>>> from an abstract facade I have,
>>>
>>> public List<T> findAll() {
>>>         javax.persistence.criteria.CriteriaQuery cq =
>>> getEntityManager().getCriteriaBuilder().createQuery();
>>>         cq.select(cq.from(entityClass));
>>>         return getEntityManager().createQuery(cq).getResultList();
>>> }
>>>
>>> when I create the Ejb I extends this abstract facade and the method
>>> looks
>>> for an entity 'Mensajes' like,
>>>
>>> public List<Mensajes> findAll() {
>>>         javax.persistence.criteria.CriteriaQuery cq =
>>> getEntityManager().getCriteriaBuilder().createQuery();
>>>         cq.select(cq.from(Mensajes.class));
>>>         return getEntityManager().createQuery(cq).getResultList();
>>> }
>>>
>>> so my method is,
>>>
>>> public List<Mensajes> leerMensajes(BigInteger userId) {
>>>
>>>         List<Mensajes> aList = findAll();
>>>
>>>         List<Mensajes> result = new ArrayList<Mensajes>();
>>>         for(Mensajes m: aList){
>>>             if(( m.getEstado() == BigInteger.ZERO ) &&
>>> (m.getUserid().equals(userId)))
>>>                 result.add(m);
>>>         }
>>>
>>>         return result;
>>> }
>>>
>>> And I am thinking of something like the following code,
>>>
>>> public List<Mensajes> findAll() {
>>>         javax.persistence.criteria.CriteriaQuery cq =
>>> getEntityManager().getCriteriaBuilder().createQuery();
>>>         cq.select(cq.from(Mensajes.class));
>>>         cq.where(Predicate pred);
>>>         return getEntityManager().createQuery(cq).getResultList();
>>> }
>>>
>>> where my Predicate must be as the if clause in leerMensajes()
>>>
>>> But I do not know how to get it.
>>>
>>> Thanks in advence,
>>> Jose
>>>
>>>
>>> --------------------------------------------------------------------------------
>>>
>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>>>
>>
>> -- 
>> View this message in context: 
>> http://old.nabble.com/Fw%3A--CriteriaQuery.where%28%29---tp30175786p30177884.html
>> Sent from the EclipseLink - Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>> 
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> 
> 

-- 
View this message in context: http://old.nabble.com/Fw%3A--CriteriaQuery.where%28%29---tp30175786p30194482.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.
References:
- [eclipselink-users] Fw: CriteriaQuery.where()??
  - From: Jose Alvarez de Lara
- Re: [eclipselink-users] Fw: CriteriaQuery.where()??
  - From: Frank Schwarz
- Re: [eclipselink-users] Fw: CriteriaQuery.where()??
  - From: Jose Alvarez de Lara
Prev by Date: Re: [eclipselink-users] Fw: CriteriaQuery.where()??
Next by Date: [eclipselink-users] Undetected problem mapping fields to columns
Previous by thread: Re: [eclipselink-users] Fw: CriteriaQuery.where()??
Next by thread: [eclipselink-users] Inheritance. Exception "Missing class for indicator field value"
Index(es):
- Date
- Thread
Breadcrumbs
