Tracing of client's part request's with OO4O - OO4O and Wizards(Archived)

any sugestions about subj ?
(like as OracleMonitor for DOA does)
thanks

Related

CAPI_FetchEventsByRange and Day Events

Hi,
The method CAPI_FetchEventsByRange is failing when requesting day events and appointments. If we just request appointments it is working. Any ideas on why it is behaving this way.
Thanks. 
Hi,
Which version of the sdk are you using? Server version? Do you have a logs? Error message? Sample program?
The CAPI_* calls are deprecated in 10G and replaced by CSDK_* calls so I strongly recommand using the CSDK_* calls instead.
BTW, I can confirm that functionality you are describing is working fine in 10G with function call CSDK_FetchEventsByRange().
Regards,
Jean-Philippe

tracing of client requests

any sugestions about subj ?
(like as OracleMonitor for DOA does)
thanks

Running external programs

I am trying to learn APEX and how it can be used in my organization. We would like to develop an application that needs to run some external JAVA programs on the server. These programs do some complex validations or lookups. How easy or difficult to do this? Can someone explain how this can be done. If there are limitations, please also let me know.
Thanks,
RJ 
RJ,
you could:
1) start the java program as an operating system command and return the result:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:952229840241
http://www.guj.com.br/posts/list/23651.java
http://www.oracle-base.com/articles/8i/ShellCommandsFromPLSQL.php
2) load the java class directly into Oracle as a stored function and call it through a plsql wrapper:
http://www.developer.com/db/article.php/10920_3337411_1
http://download-uk.oracle.com/docs/cd/B19306_01/java.102/b14187/chtwo.htm
3) call the java application running a J2EE container through a http interface, see UTL_HTTP for reference (the application would to be deployed as a J2EE app for that):
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_http.htm#ARPLS070
4) call the java application as a web service (if it was published as one):
http://www.oracle-base.com/articles/10g/utl_dbws10g.php
Regards,
~Dietmar. 
Dietmar,
From the four methods that you mentioned, what would be the best or common one to use?
Thanks,
RJ 
RJ,
as always, it depends a lot on your specific use case.
a) describe a bit your requirements. What kind of calculations are done?
b) How often are they called? Do you need to call the java function synchronously for each row that you process, i.e. that is has to be callable in a trigger?
c) What kind of information do you pass to the java function, only scalar values or java objects?
d) Which version of Oracle do you plan to use that? 10.2.x, 9.2.x or Oracle Express Edition (XE)?
e) How complex is the code that you call? What other java libraries do you reference?
~Dietmar. 
Dietmar,
Thanks for your quick reply. I am not really familiar with JAVA and what the developers want to do, so I passed along your replies to the developers.
RJ

Reports Runtime Java Bean

In: Reports Runtime (Reports Builder 6.0.8.11.3)
According to the on-line help, I should be able to find further documentation in the "Javadoc for the bean in ORACLE_HOME/REPORTS60/JAVA," but I can't find anything there. I've searched various information sources and failed to find anything on this. Can anyone help, or at least point me in the right direction for documentation.
I simply want to run the report runtime from within a Java application (if there's any way other than using Runtime).
Thanks, Mario.
Hi Mario,
Runtime.exec() works well using a command line. Or are you looking for something special, e.g. to be able to run alot of reports in rapid succession with low overhead?
regards,
Stewart 
Yes, it probably does work well enough, and if there is no other way then I'll use this. But, if there is a Java component I can use directly within a Java program (same process), like the on-line help indicates, then I would rather use this.
Thanks, Mario. 
The Runtime Java bean has effectively been discontinued (the documentation is yet to catch up with this). The primary reason for this was that the bean didn't provide a lot more functionality that could be achieved with a Runtime.exec() call.
Regards,
Danny

Notification Oracle 9i -> Java

Hi Community!
I checked the forum already for a matching, but didnt find any answer for my problem.
I want to get a notification in a Java Class if an entry in my db table was changed (trigger).
I read alot about Java Stored Procedures and Packages but i cant find a hint how they (db-java) would communicate and where to begin.
Could anyone help me out?
Thanks alot in advance!
Marc 
Please, clarify your needs.
Do you mean your class is in separate Java app acting as Oracle client? Or it is running (as Java Stored Procedure) within Oracle JVM? If last, I'm sure Java Stored Procedure is not intended to be notified of something. It is just called on demand (e.g. from trigger). If first, you can call Java stored procedure from trigger, and use RMI or JMS to notify someone. 
The Java App is an Oracle Client which needs the notification.
I will check if JMS will serve the needs and will write down my experiences ;)
Thanx for the tip!

Categories

Resources