Db2

 View Only

  • 1.  facing issue

    Posted Fri May 01, 2020 02:01 PM

    Hi Team,
    We are using isim, isam, db2 & ISDS. with this we are using liferay application to merge our modules/applicaiton on a single platform. but when are connecting using login in webseal portal, after login in that we are unable to get our application. where we already define junction in webseal . can you please tell me something about this issue ?

    error:
    11:25:54,505 WARN [404_jsp:91] /favicon.ico
    15:58:54,929 ERROR [JDBCExceptionReporter:234] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=( select * from ( select rownumber() over;BEGIN-OF-STATEMENT;<delete>, DRIVER=3.69.49
    15:58:54,932 ERROR [JDBCExceptionReporter:234] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-104;42601;( select * from ( select rownumber() over|BEGIN-OF-STATE, DRIVER=3.69.49
    15:58:54,934 ERROR [velocity:151] Exception rendering #parse(_SERVLET_CONTEXT_/html/themes/_unstyled/templates/init.vm) at _SERVLET_CONTEXT_/html/themes/classic/templates/portal_normal.vm[line 3, column 1]
    15:58:54,934 ERROR [IncludeTag:410] Current URL /web/it-dept generates exception: Invocation of method 'hasMyPlaces' in class com.liferay.portal.model.impl.UserImpl threw exception com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query at _SERVLET_CONTEXT_/html/themes/_unstyled/templates/init.vm[line 288, column 31]
    15:58:54,936 ERROR [IncludeTag:154] com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=( select * from ( select rownumber() over;BEGIN-OF-STATEMENT;<delete>, DRIVER=3.69.49
    at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)

    ------------------------------
    ankur tyagi
    ------------------------------

    #Db2


  • 2.  RE: facing issue

    Posted Mon May 04, 2020 03:22 PM
    Is your applcation a web application? Have you tested it without WebSEAL junction? The errors here indicate issue with the SQL itself. 

    --Sunit

    ------------------------------
    Sunit
    ------------------------------

    Original Message


  • 3.  RE: facing issue

    Posted Tue May 05, 2020 05:16 AM
    Hi Sunita & IBM Community,
    First i want to told you, thanks for the revert on my query. 

    Here, i tested without webseal also, and the issue was same. Application that i am using is liferay. 
    To direct login, i follow method that are below mention -
    open liferay -. login with user id and credentials -> only blank page comes.

    When i check the log, it show error like -
    11:25:54,505 WARN [404_jsp:91] /favicon.ico
    15:58:54,929 ERROR [JDBCExceptionReporter:234] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=( select * from ( select rownumber() over;BEGIN-OF-STATEMENT;<delete>, DRIVER=3.69.49
    15:58:54,932 ERROR [JDBCExceptionReporter:234] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-104;42601;( select * from ( select rownumber() over|BEGIN-OF-STATE, DRIVER=3.69.49




    --

    Thanks & Regards

    Ankur Tyagi| Application Engineer | ITIM-ITAM Admin

    Infinite| exciting times...infinite possibilities...

    IT Services | Product Engineering | Mobility & Messaging

    Telecom | Healthcare | Energy & Utilities | Media & Content | Banking & Finance

    Mobile: +91- 9756773193

    Web site: www.infinite.com  |  Email: ankurankur999@gmail.com

    USA | UK | India | China | Singapore

                           Stay Connected:  



    Original Message


  • 4.  RE: facing issue

    Posted Tue May 05, 2020 08:42 AM
    SQLCODE -104 indicates a bad SQL query (syntax issue). From the error message  select * from ( select rownumber() over; is not a correct SQL statement.

    --Sunit

    ------------------------------
    Sunit
    ------------------------------

    Original Message


  • 5.  RE: facing issue

    Posted Tue May 05, 2020 11:32 AM
    Hi Sunita,
    yes i know it's a syntax error. but from where it's generated? because i have not pushed any query. Unable to get exact issue. 
    Here, in the log it's not showing complete error so i can't test it directly in my db side. 

    Can you please help on this.

    --

    Thanks & Regards

    Ankur Tyagi| Application Engineer | ITIM-ITAM Admin

    Infinite| exciting times...infinite possibilities...

    IT Services | Product Engineering | Mobility & Messaging

    Telecom | Healthcare | Energy & Utilities | Media & Content | Banking & Finance

    Mobile: +91- 9756773193

    Web site: www.infinite.com  |  Email: ankurankur999@gmail.com

    USA | UK | India | China | Singapore

                           Stay Connected:  



    Original Message


  • 6.  RE: facing issue

    Posted Tue May 05, 2020 01:43 PM
    Ankur,

    Two things.
    1. My name does not have "a" at the end i.e Sunit not Sunita
    2. The code should be part of the liferay application. SQLERRMC has the SQL text in it.

    --Sunit

    ------------------------------
    Sunit
    ------------------------------

    Original Message


  • 7.  RE: facing issue

    Posted Tue May 05, 2020 02:11 PM
    Hi Sunit,
    Sorry for 'A'. 
    Thanks for your reply.
    Now I have resolved the issue. My application connected to DB and connection also established with application and db.
     

    --

    Thanks & Regards

    Ankur Tyagi| Application Engineer | ITIM-ITAM Admin

    Infinite| exciting times...infinite possibilities...

    IT Services | Product Engineering | Mobility & Messaging

    Telecom | Healthcare | Energy & Utilities | Media & Content | Banking & Finance

    Mobile: +91- 9756773193

    Web site: www.infinite.com  |  Email: ankurankur999@gmail.com

    USA | UK | India | China | Singapore

                           Stay Connected:  



    Original Message