2 Replies Latest reply: Nov 19, 2012 10:00 AM by Hilary-Oracle RSS

    Apex 4.1 remote debugging with dbms_debug_jdwp - breakpoints not working

    Björn
      Hi all,

      I'm using remote debugging with sqldeveloper like described here:
      http://www.oracle.com/webfolder/technetwork/de/community/apex/tipps/remote-debug/index.html
      http://sueharper.blogspot.com/2006/07/remote-debugging-with-sql-developer_13.html
      It works great with my sqldeveloper 3.0 and Apex 4.0.2
      Now i tried the same on two other servers with Apex 4.1
      The debugger is connecting. I can see the connect and diconnect message in the debug windows in the sqldeveloper.
      But the breakpoints are not working.
      Is the debugging working in Apex 4.1 for anyone here?
      Any ideas why the breakpoints are not working?

      BR,
      Björn
        • 1. Re: Apex 4.1 remote debugging with dbms_debug_jdwp - breakpoints not working
          Casufi
          I have the same issue

          Got the answer here Remote debugging with APEX and SQL Developer

          Edited by: Casufi on Nov 19, 2012 7:36 AM
          • 2. Re: Apex 4.1 remote debugging with dbms_debug_jdwp - breakpoints not working
            Hilary-Oracle
            Hi Björn,

            In your APEX application, have you tried updating the URL to include the parameter REMOTE, in order to initiate the remote debug connection? e.g.
            f?p=100:1:&SESSION.::REMOTE::
            Using the REMOTE parameter cuts out the need to specify debug code surrounding statements in the APEX PL/SQL.

            The steps are as follows:
            1) In SQL Developer, set break points in the the PL/SQL code, and compile using the "Compile for debug" option
            2) Execute the following two grants
            grant DEBUG CONNECT SESSION to <PARSE USER>;
            grant debug on <PROC> to public;  <-- might not need public but just whoever the DAD is running as.
            5) In SQL Developer, right-click on your connection and select the "Remote Debug..." context menu item. This will launch the "Listen for JPDA" dialog.
            5) Run the APEX Application page containing/activating the code you wish to debug, and update its URL with REMOTE in the debug parameter of the URL, and then hit Enter.
            6) Carry out the action on the page to trigger the breakpoint in your code e.g. submit the page, or click a button on the page, and you should be redirected to the breakpoint in the code in SQL Developer.

            Although I'm running with the latest release of SQL Developer, version 3.2.2 (http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html), and APEX 4.2, the 'REMOTE' parameter was introduced with our 3.1 release so will also be available for you to use in 4.1.


            Regards,
            Hilary