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: