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
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;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> 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
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

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




--
Tanujit Chowdhury

Back to the top