Hi,
There is no update running on the Entity manager before this query.
Secondly I am using Weblogic 10.3g which does not support
Eclipselink/Toplink as default. I had to apply their official patch
"*9J3A*" and added 3 jars in the server lib, they are :
1. *eclipselink.jar*
2. *toplink.jar*
3. *commonj.sdo_2.1.0.jar*
I have checked that the patch provides Eclipselink jar of
Implementation-Version: *1.0.2.20081024 *(from MANIFEST).
So, how can I update the library to newer version? Oracle will not
provide any support if I update these libraries as opposed to what is
given as the patch and encounter any problem in Production environment.
I will however update the jars locally and check the query.
On Fri, Aug 6, 2010 at 7:55 PM, Tom Ware <tom.ware@xxxxxxxxxx
<mailto:tom.ware@xxxxxxxxxx>> wrote:
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>
<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>
<mailto: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>
<mailto: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>
<mailto:eclipselink-users@xxxxxxxxxxx
<mailto:eclipselink-users@xxxxxxxxxxx>>
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
--
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
