tag:blogger.com,1999:blog-5874979429188093780.post1482241423852524830..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: LOV in Find Mode - Workaround for JDeveloper 11g TP4Andrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-5874979429188093780.post-54751698535933867612014-03-21T14:13:59.314+01:002014-03-21T14:13:59.314+01:00Hi I am also facing issue in my LOV but in my face...Hi I am also facing issue in my LOV but in my face in my loca deployment i am not getting any error but when i used same code in webcenter space, I am facing below error, I hav ecreated both VO on query based only and binding style of my vo is "OracleName"<br />Please find blow my logs.<br /><br /> <br /> <br /> <getDisplayMessage Called=oracle.jbo.SQLStmtException<br />oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT the_key, ProdLineKey,ProdLineDesc, ProdSegKey<br />FROM (SELECT 1 the_key,<br /> TO_CHAR(trim(SRSRP2)) ProdLineKey,<br /> TO_CHAR(trim(SRDL02)) ProdLineDesc,<br /> TRIM (SRSRP1) ProdSegKey<br /> FROM F590001<br /> WHERE trim(SRSRP1) IS NOT NULL<br /> AND trim(SRSRP1) IN<br /> (SELECT TO_CHAR(trim(DRKY))<br /> FROM F0005<br /> WHERE trim (DRSY) = '41'<br /> AND trim(drrt) = 'S1'<br /> AND trim(drsphd) = 'CPP'<br /> )<br /> UNION ALL<br /> SELECT DISTINCT 2 the_key,<br /> TO_CHAR(trim(SRSRP2)) ProdLineKey,<br /> TO_CHAR(trim(SRDL02)) ProdLineDesc,<br /> NULL ProdSegKey<br /> FROM F590001<br /> WHERE trim(SRSRP1) IS NOT NULL<br /> AND trim(SRSRP1) IN<br /> (SELECT TO_CHAR(trim(DRKY))<br /> FROM F0005<br /> WHERE trim (DRSY) = '41'<br /> AND trim(drrt) = 'S1'<br /> AND trim(drsphd) = 'CPP'<br /> )<br /> )) QRSLT WHERE (:Bind_Prodsegkey is null and the_key = 2)or (:Bind_Prodsegkey is not null and the_key=1 and :Bind_Prodsegkey = ProdSegKey)<br /> at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1293)<br /> at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:968)<br /> at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7178)<br /> at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1217)<br /> at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1062)<br /> at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2810)<br /> at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2788)Anonymoushttps://www.blogger.com/profile/15073454425824306975noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-86942366485269180972011-07-03T13:55:23.401+02:002011-07-03T13:55:23.401+02:00Hi,
Since we are looking error code 27122, i thin...Hi,<br /><br />Since we are looking error code 27122, i think we will gracefully trap only that error. rest of the JBO exceptions will be shown to users, right ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-71282188993699269612011-04-08T10:24:35.583+02:002011-04-08T10:24:35.583+02:00Hi,
You will get this error if Bind Variable is s...Hi,<br /><br />You will get this error if Bind Variable is set as Required and value is not assigned to Bind Variable on runtime.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-60334300604388056972011-04-08T10:23:10.863+02:002011-04-08T10:23:10.863+02:00Hi,
I am working with JDeveloper 11.1.1.4.0 . I am...Hi,<br />I am working with JDeveloper 11.1.1.4.0 . I am just creation a normal LOV that is attached to the view object and this view object extends the BaseViewObject . I have bind variables nad values are also defined to these bind variables . But still i get this exception : Missing in and out parameter . Can you please advice me on this .<br />I have also posted the issue in forum as well.. the link is :<br />http://forums.oracle.com/forums/message.jspa?messageID=9501858#9501858Vinithahttps://www.blogger.com/profile/16187616191468243122noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-5748826136524370602009-06-16T10:42:59.443+02:002009-06-16T10:42:59.443+02:00Hi,
LOV in Find Mode Exception
LOV in Find Mode Ex...Hi,<br />LOV in Find Mode Exception<br />LOV in Find Mode Exception<br />LOV in Find Mode Exception<br /><[weblogic.servlet.internal.WebAppServletContext@10eb552 - appName: 'LOVFindMode', name: 'LOVFindMode-ViewController-context-root', context-path: '/LOVFindMode-ViewController-context-root', spec-version: '2.5', request: weblogic.servlet.internal.ServletRequestImpl@18b8315[<br />POST /LOVFindMode-ViewController-context-root/faces/main?_adf.ctrl-state=953938490_3 HTTP/1.1<br />Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*<br />Referer: http://127.0.0.1:7101/LOVFindMode-ViewController-context-root/faces/main?_adf.ctrl-state=953938490_3<br />Accept-Language: en-us<br />Content-Type: application/x-www-form-urlencoded<br />UA-CPU: x86<br />Accept-Encoding: gzip, deflate<br />User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)<br />Content-Length: 2549<br />Connection: Keep-Alive<br />Cache-Control: no-cache<br />Cookie: JSESSIONID=5nw4K3WDGYCjwk9VdXxrVGlsxwn9K4gdlWR9RB2cyfHmLcCMLfPb!-558683371<br /><br />]] Root cause of ServletException.<br />oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Employees.EMPLOYEE_ID, Employees.FIRST_NAME, Employees.LAST_NAME, Employees.EMAIL, Employees.PHONE_NUMBER, Employees.HIRE_DATE, Employees.JOB_ID, Employees.SALARY, Employees.COMMISSION_PCT, Employees.MANAGER_ID, Employees.DEPARTMENT_ID FROM EMPLOYEES Employees WHERE (Employees.EMPLOYEE_ID = :1)<br /> at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1015)<br /> at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:762)<br /> at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:5681)<br /> at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1005)<br /> at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1162)<br /> Truncated. see log file for complete stacktrace<br />java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: vc_temp_1<br /> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)<br /> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:116)<br /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:177)<br /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:233)<br /> at oracle.jdbc.driver.OraclePreparedStatement.setNullAtName(OraclePreparedStatement.java:4454)<br /> Truncated. see log file for complete stacktrace<br />> <br />How to catch These exception<br />ThanksAmol Patilhttps://www.blogger.com/profile/07999720565363118813noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-17556676172426771762008-08-19T19:16:00.000+02:002008-08-19T19:16:00.000+02:00Hi,In this case, it hides whole exception.Regards,...Hi,<BR/><BR/>In this case, it hides whole exception.<BR/><BR/>Regards,<BR/>AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-31209833085960993592008-08-19T18:53:00.000+02:002008-08-19T18:53:00.000+02:00Hi,It's great. I’m wondering if that will hide the...Hi,<BR/>It's great. I’m wondering if that will hide the whole exception or just JBO-2712<BR/><BR/>ThanksAnonymousnoreply@blogger.com