Debugging a running (web-)application

[Basti]

Hi There,

i'm quite new to the forum and new to Oracle and PLSQL and that's my question:

in our company, we are using the PLSQL-Developer 7.1.5 for programming different procedures in PLSQL. For testing these, we are using the Debugging tool. This works quite fine, but ...

Our Solution consits of a Java-based web interface that runs as thin-client in a web-browser. The Java-Procedures call the PLSQL-procedures, wich contain the programm-logic.

My question is:

Is there a posibility to set a breakpoint in the PLSQL-Code, so that after calling a certain PLSQL-Procudere (by clicking the appropriate button in the Java-Web-interface) the execution is stopped at the defined braekpoit and I can regard/ watch the modified parameters given over by the Java-GUI?

This would make it much easier to reconstruct bugs that occured during daily use of our running systems.

Many thanks in advance for your answers,
Basti

 

[D.]

Hi,

I would doubt you can do what you want in this or any other Oracle IDE. But, you can implement logging in your PLSQL to at least trace your execution. Try out something like log4plsql (similar to Log4J).

Regards,
D.

 

[Basti]

Hi,

thanks for your response.

We are working with logging at the moment, but it is not very comfortable to fish out the the stuff I need off these log-tables.

If I can't do It with this IDE, maybe it's something worth to be put on the todo list.

I mean, all the debuger has to know is the Session ID of the Web-Client. Shouldn't be that difficult. But maybe I am wrong.

Greez,
Basti

 

[D.]

Hi,

Have you looked at log4plsql ? It has some Log4JbackgroundProcess features to log to other destinations other than a log table.

From the docs :-
Currently, some log4j appenders exist for the console, files, GUI components, remote socket servers, JMS, NT Event Loggers, and remote UNIX Syslog daemons. It is also possible to log asynchronously.

Might be something to try in the meantime, although not as good as interactive debugging.

Cheers,
D.

 

[Basti]

Hi,

well thats exactly what we are using, although I wasn't aware of all the features it has. It was introduced to our system by someone else...

I think I'll have a closer look at it. Thanks for the hint.

regards
Basti