Wednesday, February 29, 2012

Java has discovered application components that could indicate a security concern



Here is where I went wrong, maybe you can benefit:

I had an icon.jar file and I needed to add one more icon so I just went and used winrar without thinking.

What you need to do is to use the jar command to wrap up the file:

JAVA_HOME\bin\jar cvf icnFileName.jar *.gif


Don't forget to resign the file.



Thursday, February 23, 2012

Tracing A Forms User

Tracing A Forms User 10g - quick and dirty

Let the user run the regular link + record=forms&tracegroup=0-199
ie:
http://machine:port/forms/frmservlet?config=myConfig&record=forms&tracegroup=0-199

You will get a trace file in the following location:

%ORACLE_HOME%\forms\trace\forms_xxx.trc where xxx is the forms session ID.


Open CMD window and do the following:

set ORACLE_HOME=[oracle home location]

set PATH=%ORACLE_HOME%\jdk\bin;%PATH%

set CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes12.zip;%ORACLE_HOME%\forms\java\frmxlate.jar

java oracle.forms.diagnostics.Xlate datafile=%ORACLE_HOME%\forms\trace\forms_xxx.trc outputfile=%ORACLE_HOME%\forms\trace\html_xxx.html outputclass=WriteOutHTMLoutputclass parameter:
WriteOutHTML = HTML output


WriteOut = XML output

you will get a file html_xxx.html in your %ORACLE_HOME%\forms\trace directory.




In grater details:



Monday, February 20, 2012

ShowJobs parameters for Oracle Reports


ShowJobs parameters for Oracle Reports

http://[serverName]/reports/rwservlet/showjobs?queuetype=past&count=100000&startrow=0&statusformat=xml


/reports/rwservlet/showjobs[n] - The refresh number n is optional. When it is specified, the report's queue status will be updated every n seconds.
[?]
[server=server_name]
[&authid=username/password]
[&queuetype={current|past|future}]
[&startrow=start_position_in_job_queue]
[&count=number_of_jobs_to_display]
[&statusformat={html|xml|xmldtd}]

Separate the Java client instances


Those parameters will separate the Java client instances so that they will not depend on each other:

[PARAM NAME="separate_jvm" value="true"]

separate_jvm="true"