I am using Windows 7 and have weblogic(11.1.16) and forms (version 11.1.2.2.0) installed locally on my computer.
I have been trying to add a PJC calendar to my form. I downloaded an example from this site: http://forms.pjc.bean.over-blog.com/article-14848846.html
As a first step, I'm just trying to run the example form that came in the download. There is a button on the form that should trigger the calendar to appear.
The steps I've taken so far are:
1. Copy the the .jar files to <%ORACLE_HOME%>\Forms\java folder.
2. modify formsweb.cfg to include the .jar files
Initially, I was receiving an error saying that the app can't run because of unsigned jars. I lowered the security settings (via the Security tab in Java in Control Panel) and got the calendar to pop up successfully ONCE. I went back and raised the security settings, and now the form runs without a warning or error popping up, but pressing the button does nothing even if I lower the security settings. The code behind the button is as follows:
Copy('BL.TEXTITEM','GLOBAL.ITEM');
Set_Custom_Property('BL.BEAN',1, 'SHOW_CALENDAR','50,50');
I put messages around the SET_CUSTOM_PROPERTY:
Copy('BL.TEXTITEM','GLOBAL.ITEM');
msgbox('pre set');
Set_Custom_Property('BL.BEAN',1, 'SHOW_CALENDAR','50,50');
msgbox('post set');
and within the custom_event trigger on the bean:
DECLARE
eventName varchar2(30);-- := :system.custom_item_event;
eventValues ParamList;
eventValueType number;
LC$Date varchar2(256);
LC$Day varchar2(256);
LC$Month varchar2(256);
LC$Year varchar2(256);
BEGIN
msgbox('in trigger');
eventName := :system.custom_item_event;
IF (eventName='CALENDAR_EVENT') THEN
eventValues := get_parameter_list(:system.custom_item_event_parameters);
get_parameter_attr(eventValues,'CALENDAR_EVENT_DATE',eventValueType, LC$Date);
get_parameter_attr(eventValues,'CALENDAR_EVENT_DAY',eventValueType, LC$Day);
get_parameter_attr(eventValues,'CALENDAR_EVENT_MONTH',eventValueType, LC$Month);
get_parameter_attr(eventValues,'CALENDAR_EVENT_YEAR',eventValueType, LC$Year);
Clear_Message;
Message('Selected date:'|| LC$Date || '(' || LC$Day||'/'||LC$Month||'/'||LC$Year || ')');
Copy(LC$Date,Name_in('GLOBAL.ITEM'));
Synchronize ;
END IF;
END;
and I get both the pre set and post set but I don't get the messages within the custom_event_trigger.
I'm thinking there is probably still a signature issue with the jars, since I never resolved that issue because although I have tried to sign the jars, it doesn't seem to "take." Here is the verification from FJCalendar.jar:
c:\Program Files\Java\jdk1.7.0_55\bin>jarsigner -verify c:\Oracle\Middleware10_3
\Oracle_FRHome1\forms\java\FJCalendar.jar -verbose -certs
s 323 Tue Dec 25 17:08:30 EST 2007 META-INF/MANIFEST.MF
X.509, CN=Degrelle, OU=Development, O=Oracle, C=FR
[certificate expired on 1/22/08 5:59 AM]
[CertPath not validated: Path does not chain with any of the trust anchors
]
380 Tue Dec 25 17:08:30 EST 2007 META-INF/FDEGRELL.SF
929 Tue Dec 25 17:08:30 EST 2007 META-INF/FDEGRELL.DSA
sm 1491 Tue Dec 25 17:08:26 EST 2007 oracle/forms/fd/JCalendar$1.class
X.509, CN=Degrelle, OU=Development, O=Oracle, C=FR
[certificate expired on 1/22/08 5:59 AM]
[CertPath not validated: Path does not chain with any of the trust anchors
]
sm 817 Tue Dec 25 17:08:26 EST 2007 oracle/forms/fd/JCalendar$2.class
X.509, CN=Degrelle, OU=Development, O=Oracle, C=FR
[certificate expired on 1/22/08 5:59 AM]
[CertPath not validated: Path does not chain with any of the trust anchors
]
sm 10647 Tue Dec 25 17:08:26 EST 2007 oracle/forms/fd/JCalendar.class
X.509, CN=Degrelle, OU=Development, O=Oracle, C=FR
[certificate expired on 1/22/08 5:59 AM]
[CertPath not validated: Path does not chain with any of the trust anchors
]
s = signature was verified
m = entry is listed in manifest
k = at least one certificate was found in keystore
i = at least one certificate was found in identity scope
jar verified.
Warning:
This jar contains entries whose signer certificate has expired.
This jar contains entries whose certificate chain is not validated.
This jar contains signatures that does not include a timestamp. Without a timest
amp, users may not be able to validate this jar after the signer certificate's e
xpiration date (2008-01-22) or after any future revocation date.
c:\Program Files\Java\jdk1.7.0_55\bin>jarsigner -verify c:\Oracle\Middleware10_3
\Oracle_FRHome1\forms\java\FJCalendar.jar -verbose -certs
I'm pretty much grasping at straws here, and have not worked with PJCs before. I may need some hand holding here