Suivre ce blog
Editer l'article Administration Créer mon blog
27 août 2011 6 27 /08 /août /2011 07:56


Here is a Java Bean from Gert Poel, to Drop an external file within the Forms applications.

The Java source

     FileDrop.java   FileDropBean.java

The implementation class of the Java Bean


The event fired by the Java Bean


The full filemane is transmitted in the EVENT_MSG parameter.

 l_eventName varchar2(30) := :system.custom_item_event;
 l_eventValues ParamList;
 l_eventValueType number;
 l_event_msg VARCHAR2(255);
   IF l_eventName = 'DROP'
      l_eventValues := get_parameter_list(:system.custom_item_event_parameters);
      get_parameter_attr(l_eventValues,'EVENT_MSG',l_eventValueType, l_event_msg);
      IF :system.record_status <> 'NEW'
      END IF;
      :ctrl.file_location := l_event_msg;
   END IF;

The sample dialog

Download the filedrop.zip file
     . Unzip the filedrop.zip file
     . Copy the FileDrop.jar file in your /forms/java/ folder
     . Add it to the archive and archive_jini tags of the /forms/server/formsweb.cfg file
     . Open the FILEDROP.fmb module (Oracle Forms 10.1.2)
     . Compile all and run the module

Partager cet article

Published by Oracle Forms community - dans Bean - general
commenter cet article


Alexandra GAUTHIER 13/02/2013 17:35


I was really interested by your Java Bean ... but I have this error message, could you help me ?

error java.lang.UnsupportedClassVersion ....



Oracle Forms community 14/02/2013 05:11

This means that the Bean was compiled with a more recent version than the JRE you use to run Form. Maybe you're still using the old JInitiator. Upgrade to a more recent JRE.

Philippe 21/11/2012 15:25

Hi Geert,


I'm having trouble with the filedropper: the demo fmb is ok but when I enhance it to have a base tabled block to store Blobs using webutil it freezes the application and the file explorer (during
the communication with the bean in th WCIE).  Can you help me ?

Oracle Forms community 21/11/2012 15:41

Gert has no access to my blog, so I suggest you to ask that question on the Forms.PJC.Bean forum.
Choose one of the first two sub-forums (PJC or JavaBean)  ;-)


Stephan van Hoof 08/10/2012 16:18


Regarding the FileDropBean:

Am I right to conclude that only the file-name is send from applet to the Forms runtime (connected and running frmweb.exe) on server?

In other words: no bytes are transfered to the server?

Thanks, regards, Stephan



Oracle Forms community 08/10/2012 23:26

Yes, you are right.