Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Having problem in 'AND' with JPQL and EclipseLink 
There are a couple of things worth looking in to.
1. Is that query run in a clean entity manager, or have there been updates run in that entity manager before the query? If there are updates that make it so this query could return no results, that could be causing the problem. 

2. Can you try a more recent version of EclipseLink 1.0.2 is pretty ancient.

-Tom

Tanujit Chowdhury wrote:

Hi,
I am pasting the FINEST log here which shows the translated query by EclipseLink:
[EL Config]: 2010.08.06 16:03:49.000--ServerSession(9397949)--Connection(5237201)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kern 
el.Default (self-tuning)',5,Pooled Threads])--connecting(DatabaseLogin(
        platform=>SQLServerPlatform
        user name=> ""
        connector=>JNDIConnector datasource name=>null
))
[EL Config]: 2010.08.06 16:03:49.000--ServerSession(9397949)--Connection(8362374)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kern el.Default (self-tuning)',5,Pooled Threads])--Connected: jdbc:bea:sqlserver://scrbcaddkbry101.crb.apmoller.net:1433;CATALOGOPTIONS=2;CONNECTIONRETRYDE 
LAY=1;PORT=1433;DATABASENAME=;MAXPOOLEDSTATEMENTS=0;DB=VLO1D6;ENABLECANCELTIMEOUT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;CODEPAGEOVE
RRIDE=;DESCRIBEPARAMETERS=noDescribe;CONNECTIONRETRYCOUNT=5;BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;HOSTPROCESS=0;USESERVERSIDEUPDATABL
ECURSORS=false;SERVER=scrbcaddkbry101.crb.apmoller.net <http://scrbcaddkbry101.crb.apmoller.net>;ALWAYSREPORTTRIGGERRESULTS=false;RESULTSETMETADATAOPTIONS=0;QUERYTIMEOUT=0;HOSTNAMEINCERTIFICAT 
E=;CATALOGINCLUDESSYNONYMS=true;SNAPSHOTSERIALIZABLE=false;JAVADOUBLETOSTRING=false;SENDSTRINGPARAMETERSASUNICODE=true;LOADLIBRARYPATH=;IMPORTSTATEMEN
TPOOL=;PROGRAMNAME=;NETADDRESS=000000000000;ALTERNATESERVERS=;WSID=;ENCRYPTIONMETHOD=NoEncryption;CONVERTNULL=1;TRUSTSTORE=;AUTHENTICATIONMETHOD=auto;
LOGINTIMEOUT=0;LONGDATACACHESIZE=2048;LOADBALANCING=false;TRANSACTIONMODE=implicit;WORKAROUNDS=0;INSENSITIVERESULTSETBUFFERSIZE=2048;RECEIVESTRINGPARA
METERTYPE=nvarchar;PACKETSIZE=-1;DEFAULTSCALE=4;XMLDESCRIBETYPE=LONGVARCHAR;SELECTMETHOD=direct
        User: dbo
Database: Microsoft SQL Server Version: Microsoft SQL Server Yukon - 9.00.3077 
        Driver: SQLServer  Version: 3.70.27 (029619.012905.017415)
[EL Finest]: 2010.08.06 16:03:49.062--ServerSession(9397949)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuni ng)',5,Pooled Threads])--sequencing connected, state is NoPreallocation_State [EL Finest]: 2010.08.06 16:03:49.062--ServerSession(9397949)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuni 
ng)',5,Pooled Threads])--sequence SEQ_GEN_IDENTITY: preallocation size 1
[EL Info]: 2010.08.06 16:03:49.093--ServerSession(9397949)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning )',5,Pooled Threads])--file:/C:/bea/user_projects/domains/usicaf_domain/servers/AdminServer/tmp/_WL_user/usicaf-ear-1/lu7aon/UCS.jar-usicaf-persistanc 
e login successful
[EL Finest]: 2010.08.06 16:03:49.109--ServerSession(9397949)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuni ng)',5,Pooled Threads])--End deploying Persistence Unit usicaf-persistance; state Deployed; factoryCount 1 [EL Finer]: 2010.08.06 16:03:49.109--ServerSession(9397949)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tunin 
g)',5,Pooled Threads])--client acquired
[EL Finest]: 2010.08.06 16:03:49.265--UnitOfWork(339102)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)' ,5,Pooled Threads])--Execute query ReadAllQuery(net.msl.usicaf.jpa.entities.Certificate) [EL Finest]: 2010.08.06 16:03:49.281--ServerSession(9397949)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuni 
ng)',5,Pooled Threads])--reconnecting to external connection pool
[EL Fine]: 2010.08.06 16:03:49.281--ServerSession(9397949)--Connection(2769093)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel .Default (self-tuning)',5,Pooled Threads])--SELECT CertKeyfield, SerialNumber, CertBrowserName, CertBrowserString, CertBrowserVersion, CertCert, CertC hallenge, CertPIN, CertState, CertValidFrom, CertValidTo, Publickey FROM vmlo.certificate WHERE ((CertPIN = ?) AND (CertState IN (?))) 
        bind => [bK2xEk2, MLOG]
[EL Finer]: 2010.08.06 16:03:49.343--UnitOfWork(339102)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)', 
5,Pooled Threads])--release unit of work
[EL Finer]: 2010.08.06 16:03:49.343--ClientSession(5509673)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tunin 
g)',5,Pooled Threads])--client released
^^^^^^^^^^^^^^ []
[EL Finer]: 2010.08.06 16:03:49.343--ServerSession(9397949)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tunin 
g)',5,Pooled Threads])--client acquired
[EL Finest]: 2010.08.06 16:03:49.343--UnitOfWork(24409133)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning )',5,Pooled Threads])--Execute query ReadAllQuery(net.msl.usicaf.jpa.entities.Certificate) [EL Finest]: 2010.08.06 16:03:49.343--ServerSession(9397949)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuni 
ng)',5,Pooled Threads])--reconnecting to external connection pool
[EL Fine]: 2010.08.06 16:03:49.343--ServerSession(9397949)--Connection(7829171)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel .Default (self-tuning)',5,Pooled Threads])--*SELECT CertKeyfield, SerialNumber, CertBrowserName, CertBrowserString, CertBrowserVersion, CertCert, CertC hallenge, CertPIN, CertState, CertValidFrom, CertValidTo, Publickey FROM vmlo.certificate WHERE ((CertPIN = ?) AND (CertState IN (?))) 
        bind => [bK2xEk2, MLOG]*
[EL Finer]: 2010.08.06 16:03:49.359--UnitOfWork(24409133)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning) 
',5,Pooled Threads])--release unit of work
[EL Finer]: 2010.08.06 16:03:49.359--ClientSession(17962841)--Thread(Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuni 
ng)',5,Pooled Threads])--client released

The above query runs well in databse and fetches a single data.

Can you tell me what is wrong then?
On Fri, Aug 6, 2010 at 3:45 PM, Christopher Delahunt <christopher.delahunt@xxxxxxxxxx <mailto:christopher.delahunt@xxxxxxxxxx>> wrote: 

    Hello,

    Can you turn on logging and then post the SQL that is used for the
query? try adding <property name="eclipselink.logging.level" value="FINEST"/> 
    and showing the sql for both queries.  Also try the sql on the
    database directly to see if you get the expected results.

    Best Regards,
    Chris


    On 06/08/2010 6:01 AM, Tanujit Chowdhury wrote:

    Hi,
    I am using Eclipselink 1.0.2, and Oracle Weblogic 10.3.2. My
    database is SQL Server.

    I am executing a simple query :
    "*select c from Certificate c where c.certPIN = 'bK2xEk2'*"
    ---------- This is working fine with the JPQL.
    But the below query is not returning any data where it should return :
    "*select c from Certificate c where c.certPIN = 'bK2xEk2' and
    c.certState IN ('MLOG')*".-------------- It is returning ZERO
    result but actually it has results.

    Can anyone help in this regard?
-- Tanujit Chowdhury 

    ------------------------------------------------------------------------

    _______________________________________________
    eclipselink-users mailing list
    eclipselink-users@xxxxxxxxxxx <mailto:eclipselink-users@xxxxxxxxxxx>
    https://dev.eclipse.org/mailman/listinfo/eclipselink-users


    _______________________________________________
    eclipselink-users mailing list
    eclipselink-users@xxxxxxxxxxx <mailto:eclipselink-users@xxxxxxxxxxx>
    https://dev.eclipse.org/mailman/listinfo/eclipselink-users




--
Tanujit Chowdhury


------------------------------------------------------------------------

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

Back to the top