Jdeveloper 11g + decode syntax exception

10-11  Source: Network gathering  Views:2 

Advertisement
Hello,
I am using Build JDEVADF_11.1.1.2.0_GENERIC_091029.2229.5536.
When I add decode sql function in order by clause,following exception throws in Jdeveloper IDE. it looks like pattern issue,any clue??
SEVERE: exception visiting [email protected]
DeptView.xml [1047:1063) [45,4:45,20)
44: <ViewLinkAccessor
45: Name="EmpEOView"
46: ViewLink="model.WorksInDeptLink"
47: Type="oracle.jbo.RowIterator"
java.util.regex.PatternSyntaxException: Unclosed group near index 16
\bDECODE(DNAME\b
^
     at java.util.regex.Pattern.error(Pattern.java:1713)
     at java.util.regex.Pattern.accept(Pattern.java:1571)
     at java.util.regex.Pattern.group0(Pattern.java:2533)
     at java.util.regex.Pattern.sequence(Pattern.java:1806)
     at java.util.regex.Pattern.expr(Pattern.java:1752)
     at java.util.regex.Pattern.compile(Pattern.java:1460)
     at java.util.regex.Pattern.<init>(Pattern.java:1133)
     at java.util.regex.Pattern.compile(Pattern.java:823)
     at oracle.jbo.dt.dependency.xdf.SQLReferenceFactory.getStartIndex(SQLReferenceFactory.java:286)
Thanks
RB
To anyone else encountering this:
I would just like to report, that Oracle Development has managed to reproduce this problem from scratch by following a similar upgrade path 10.1.3.0->10.1.3.4->11.1.1.0. The problem is NOT OS-related, but related to migrating the user settings from 10.1.3.3. So Jan you were right about that. Credits go to you :)
The only workaround for me has so far been to take a backup of my old SYSTEM directory causing the problem, and I have been forced to carefully recreate all my settings to get around this problem, since I already removed my old 10.1.3.3 installation, assuming the migration went OK - which it didn't... So, I will keep my old backup, in the hope that Development finds a fix to this issue, so I can go back to the settings I used to have, even though I THINK I have recreated them all for 11g - not completely sure though... time will tell.
Until then, I will track the bug, that Didier has logged for me, which he mentioned in his post.
Regards,
Jacob
Related articles
  • Jdeveloper 11g + decode syntax exception 10-11

    Hello, I am using Build JDEVADF_11.1.1.2.0_GENERIC_091029.2229.5536. When I add decode sql function in order by clause,following exception throws in Jdeveloper IDE. it looks like pattern issue,any clue?? SEVERE: exception visiting oracle.xml.parser.v

  • Can't create WS from PLSQL package (Jdeveloper 11g 4) (Exception occured) 10-11

    Hello, I'am using JDeveloper 11g preview 4. On database i have a package with 2 procedures. When I like to create a WS from database package I get the Exception: java.lang.ClassCastException: oracle.jdeveloper.webservices.model.plsql.PLSQLPortType   

  • SOAP Exception, Connection refused error in jdeveloper 11g 11-30

    Hello, I am using jdeveloper 11g 11.1.2.3.0. I have been experiencing the following error everytime I try to run the applicaiton. I use webservices in my applicaiton and recently the webservices url were changed pointing now to dev instead of the lab

  • JDeveloper 11g - Exception when trying to run on Tomcat 5.5.20 11-30

    I am trying to get an application working on JDeveloper 11g Technology Preview (4524) using Tomcat 5.5.20 as the server (NOT the Oracle embeded server), so that I can run and debug on Tomcat from JDeveloper. I can deploy to the Tomcat server but when

  • JDeveloper 11g - exception when trying to set Code Style in Preferences 11-30

    Hi forum I have just installed the new JDeveloper 11g and have upgraded my projects, and would now like to define my code style. But when I open Preferences -> Code Editor -> Code Style, I get the following error. Is this a known issue? Not being ab

  • Problem with tutorial; "Build a Web Application with JDeveloper 11g Using " 10-11

    I've got a rather new installation of Vista Business x64 on my developer rig, and last week I installed the new JDeveloper 11g version. The installation was all-inclusive, no customization on my end. In addition I've got a test installation of an Ora

  • Error when re-deploy WLS in Jdeveloper 11g v.11.1.1.2.0 on Mac OSX 10-11

    Hi, Would appreciate if anyone can help me for the following issue:- After installed JDeveloper 11g v.11.1.1.2.0 on Mac OSX by following:- http://blogs.oracle.com/shay/2009/04/installing_jdeveloper_11g_on_m.html http://www.oracle.com/technology/produ

  • JDeveloper 11g deployment error to local Web Logic server 10-11

    I'm trying to run an existing ADF project for the first time from a JDeveloper 11g. But get the error below, can anyone help me? Deploying Application... <09-03-2009 11:07:23 CET> <Warning> <J2EE> <BEA-160195> <The application v

  • Deploy Swing Java DB application in Jdeveloper 11g 10-11

    Hi I created a simple Swing Java DB application in Jdeveloper 11g, after I deploy this simple swing application, I try to run the jar file, I got the following error: C:\Jdev1013\jdevhome\jdev\mywork\Application2\Client\deploy>java -jar myJar.jar Exc

  • JDeveloper 11g just displays Loading... image only 10-11

    Hi, I am having problem in testing my web application. i m using JDeveloper 11g 11.1.1.0.0 and ADF faces. the problem occurs whenever i run my web application. the browser displays white page with Loading... image and keeps showing this image and not

  • JDeveloper 11g and JDK 1.4.2_16 10-11

    Hi! I just created a new simple app in JDev 11g and selected the JDK 1.4.2_16 for the model project. I created a set of business components from tables, built the project and them attempted to run the AppModule tester. I got the following error: /usr

  • Error occured during Configuring of SOA in Jdeveloper 11g TP4 10-11

    Hi, I am not able to configure SOA in jdeveloper 11g. I got the following error in the startsoa log file July 13, 2008 3:02:44 PM oracle.j2ee.xml.XMLMessages warningException WARNING: Exception Encountered Error in building SOA BUILD FAILED D:\Projec

  • Problem with BundleUtils class in Oracle JDeveloper 11g Cookbook 11-30

    Hi All, While practising Using a custom exception class, in the first chapter of Oracle Jdeveloper 11g cookbook, author states: Note that in the Using a generic backing bean actions framework recipe in this chapter, we refactored the code in getMessa

  • Oracle Jdeveloper 11g R1 has a Bug?-- Swing Application Deploy Error 11-30

    Oracle Jdeveloper 11g R1 (11.1.1.2.0) (build 5536) 1. Create an empty swing application. File-->New-->Applications-->Java Desktop Application New-->Swing/AWT-->Frame 2. Project properties--->Deployment: Create new JAR Deployment Profile:

  • Configuring SOA in Jdeveloper 11g 11-30

    Hi, I am not able to configure SOA in jdeveloper 11g. I got the following error in the startsoa log file Jun 25, 2008 3:02:44 PM oracle.j2ee.xml.XMLMessages warningException WARNING: Exception Encountered Error in building SOA BUILD FAILED D:\Project

  • Problem whith JDeveloper 11g to startup EJB Client 11-30

    When i Run the EJBBean display this error message: 1/02/2008 10:03:54 AM oracle.j2ee.xml.XMLMessages warningException ADVERTENCIA: Exception Encountered 1/02/2008 10:03:55 AM oracle.oc4j.util.SystemLog log GRAVE: Server start failed processing config

  • Migration from Jdeveloper 11g r1 to 11g r2 problem 11-30

    Hi all I have a project initially created in Jdeveloper 11g r1 after migrating it to Jdeveloper 11g r2 i tried to replace lookup ejb invocation to dependency injection. So i used @EJB annotation in my managed bean. I'm shure there could be no mistake

  • New Jdeveloper 11g problem 11-30

    Hi , I intalled the new Jdeveloper 11g preview version and tried craeting a simple page using my database connection.Its does everything fine but when i run the page it generates following log: :\Documents and Settings\deolk\Application Data\JDevelop

  • Oracle JDeveloper 11g - Technical Preview 3 - SEVERE: FAILED_IN_CONFIG 11-30

    Hi I have installed "Oracle JDeveloper 11g - Technical Preview 3" and build simple ADF application. When I am trying to run it is giving me below error. Apr 4, 2008 1:02:50 PM oracle.j2ee.xml.XMLMessages warningException WARNING: Exception Encou

  • Jdeveloper 11g Migration to 11.1.1.0.1 build 5188 11-30

    Hi Jdev team, 1) the new update 11.1.1.0.1 build 5188 is out, but on the download site the filenames are still jdevstudio11110install.exe and jdevstudio11110install.bin Has some one a good explanation for this dirty updating approach? 2) After instal