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,
Just found the problem, it is the spacing between the query parameter which was causing the problem:

SELECT c FROM vmlo.certificate WHERE CertPIN = ?1

The correct one :

SELECT c FROM vmlo.certificate WHERE CertPIN=?1

On Fri, Aug 6, 2010 at 8:27 PM, Tom Ware <tom.ware@xxxxxxxxxx> wrote:
You should be able to try the new version by simply replacing EclipseLink.jar.

If that works, Oracle should be able to provide you an official patch that includes a newer version. (Likely not the "tip", but a fairly recent version)

Tanujit Chowdhury wrote:
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
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users



--
Tanujit Chowdhury

Back to the top