14 Replies Latest reply: Jan 23, 2013 9:12 AM by 977568 RSS

    a search tool similar to google search suggestions for oracle 11g forms

    977568
      Good day,
      I was wondering if there exists a tool/plugin that would show something like google search suggestions for a field on oracle 11g. It would search a column in the database. The thing is, I have a column where new fields need to be added every year, in case they do not exist. it is a bit complicated and time consuming to search if the field exists manually, a tool that would give suggestions when writing a keyword would be really helpful.
      if that's not possible, i would really appreciate any advice I could get on how to make it easier for the user to search for already existing data
      Thanks

      Edited by: 974565 on Jan 21, 2013 1:21 AM
        • 1. Re: a search tool similar to google search suggestions for oracle 11g forms
          yoonas
          Hi,

          see if this one is helpful
          {message:id=10149605}


          Regards
          yoonas
          • 2. Re: a search tool similar to google search suggestions for oracle 11g forms
            977568
            Thanks Younes, but it seems this bean is for 9i and i'm working on 11g. I will try to look for an update
            • 3. Re: a search tool similar to google search suggestions for oracle 11g forms
              François Degrelle
              Hello,

              If it works for 9i, it will work the same for 10g and 11g.

              Francois
              • 4. Re: a search tool similar to google search suggestions for oracle 11g forms
                977568
                Hello Francois,
                I have added the bean on our 11g and 10g platforms, it didn't work. can't see the combo box after launching the sample screen (the one that came with the bean download). I see a grey rectabgle instead.
                I was wondering though, the bean did not need to be signed when i added it, i verified it with jarsign. Might it be that I need to resign it? If not then it seems that this bean does not work on 10g and 11g. If you know any similar bean I could download I would appreciate it if you link me
                Regards,
                Omar
                • 5. Re: a search tool similar to google search suggestions for oracle 11g forms
                  François Degrelle
                  When you play with Java Beans, always display the Java Console at runtime to see error messages.

                  Francois
                  • 6. Re: a search tool similar to google search suggestions for oracle 11g forms
                    977568
                    I checked the java console and this is what I got, I am not well informed with java to be honest, I'd appreciate if you can tell me what the message means and how to fix it.
                    Forms Session ID is formsapp.8
                    The proxy host is null, and the proxy port is 0.
                    Native HTTP implementation is being used for the connection.
                    The connection mode is HTTP.
                    Forms Applet version is 11.1.2.0
                    java.lang.ClassNotFoundException: oracle.forms.fd.ComboBoxCompletion
                         at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
                         at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source)
                         at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
                         at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
                         at java.lang.ClassLoader.loadClass(Unknown Source)
                         at java.lang.Class.forName0(Native Method)
                         at java.lang.Class.forName(Unknown Source)
                         at oracle.forms.handler.UICommon.instantiate(Unknown Source)
                         at oracle.forms.handler.UICommon.onCreate(Unknown Source)
                         at oracle.forms.handler.JavaContainer.onCreate(Unknown Source)
                         at oracle.forms.engine.Runform.onCreateHandler(Unknown Source)
                         at oracle.forms.engine.Runform.processMessage(Unknown Source)
                         at oracle.forms.engine.Runform.processSet(Unknown Source)
                         at oracle.forms.engine.Runform.onMessageReal(Unknown Source)
                         at oracle.forms.engine.Runform.onMessage(Unknown Source)
                         at oracle.forms.engine.Runform.sendInitialMessage(Unknown Source)
                         at oracle.forms.engine.Runform.startRunform(Unknown Source)
                         at oracle.forms.engine.Main.createRunform(Unknown Source)
                         at oracle.forms.engine.Main.start(Unknown Source)
                         at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
                         at java.lang.Thread.run(Unknown Source)

                    Regards,
                    • 7. Re: a search tool similar to google search suggestions for oracle 11g forms
                      François Degrelle
                      You have to copy the JAR file in the <FORMS_HOME>/forms/java folder, and also add it to the archive tags of the <FORMS_HOME>/forms/server/formsweb.cfg file (be careful, Java is case sensitive with filenames).
                      I'm not sure this bean will work with the old JInitiator, so you'd probably have to use the Sun Java plug-in instead. (The plug-in used is displayed at the very first lines in the Java Console)

                      Francois
                      • 8. Re: a search tool similar to google search suggestions for oracle 11g forms
                        977568
                        I've already copied the jar file to the Java folder and I've added the jar file's name to formsweb (in archive, and i copy/pasted the name so it's prolly not a case sensitive issue). I've tried it on both 10g and 11g, we're using 11g but we keep a 10g platform for testing purposes, I've tried it on both.
                        On 11g I've used the Sun Java plug-in, no Jinitiator there. I used the Jinitiator on 10g though.
                        Regards
                        • 9. Re: a search tool similar to google search suggestions for oracle 11g forms
                          François Degrelle
                          Could you paste your formsweb.cfg file content ?

                          Francois
                          • 10. Re: a search tool similar to google search suggestions for oracle 11g forms
                            977568
                            sure here it is:
                            # $Id: formsweb.cfg /main/164 2010/10/19 05:20:53 atyagi Exp $
                            # formsweb.cfg defines parameter values used by the FormsServlet (frmservlet)
                            # This section defines the Default settings. Any of them may be overridden in the
                            # following Named Configuration sections. If they are not overridden, then the
                            # values here will be used.
                            # The default settings comprise two types of parameters: System parameters,
                            # which cannot be overridden in the URL, and User Parameters, which can.
                            # Parameters which are not marked as System parameters are User parameters.
                            # SYSTEM PARAMETERS
                            # -----------------
                            # These have fixed names and give information required by the Forms
                            # Servlet in order to function. They cannot be specified in the URL query
                            # string. But they can be overridden in a named configuration (see below).
                            # Some parameters specify file names: if the full path is not given,
                            # they are assumed to be in the same directory as this file. If a path
                            # is given, then it should be a physical path, not a URL.
                            # USER PARAMETERS
                            # ---------------
                            # These match variables (e.g. %form%) in the baseHTML file. Their values
                            # may be overridden by specifying them in the URL query string
                            # (e.g. "http://myhost.example.com/forms/frmservlet?form=myform&width=700")
                            # or by overriding them in a specific, named configuration (see below)
                            [default]
                            # System parameter: default base HTML file
                            baseHTML=base.htm
                            # System parameter: base HTML file for use with Sun's Java Plug-In
                            baseHTMLjpi=basejpi.htm
                            # System parameter: delimiter for parameters in the base HTML files
                            HTMLdelimiter=%
                            # System parameter: file setting environment variables for the Forms runtime processes
                            envFile=default.env

                            # Forms runtime argument: whether to escape certain special characters
                            # in values extracted from the URL for other runtime arguments
                            escapeparams=true
                            # Forms runtime argument: which form module to run
                            form=test.fmx
                            # Forms runtime argument: database connection details
                            userid=
                            # Forms runtime argument: whether to run in debug mode
                            debug=no
                            # Forms runtime argument: host for debugging
                            host=
                            # Forms runtime argument: port for debugging
                            port=
                            # Forms runtime argument: BIDI digitSubstitution
                            digitSubstitution=context
                            # Other Forms runtime arguments: grouped together as one parameter.
                            # These settings support running and debugging a form from the Builder:
                            otherparams=obr=%obr% record=%record% tracegroup=%tracegroup% log=%log% term=%term% ssoProxyConnect=%ssoProxyConnect%
                            # Sub argument for otherparams
                            obr=no
                            # Sub argument for otherparams
                            record=
                            # Sub argument for otherparams
                            tracegroup=
                            # Sub argument for otherparams
                            log=
                            # Sub argument for otherparams
                            term=

                            # HTML page title
                            pageTitle=Oracle Fusion Middleware Forms Services
                            # HTML attributes for the BODY tag
                            HTMLbodyAttrs=
                            # HTML to add before the form
                            HTMLbeforeForm=
                            # HTML to add after the form
                            HTMLafterForm=

                            # Forms applet parameter: URL path to Forms ListenerServlet
                            serverURL=/forms/lservlet
                            # Forms applet parameter
                            codebase=/forms/java
                            # Forms applet parameter
                            imageBase=codebase
                            # Forms applet parameter
                            width=750
                            # Forms applet parameter
                            height=600
                            # Forms applet parameter
                            separateFrame=false
                            # Forms applet parameter
                            splashScreen=
                            # Forms applet parameter
                            allowAlertClipboard=true
                            # Forms applet parameter
                            disableValidateClipboard=false
                            # Forms applet parameter
                            highContrast=false
                            # Forms applet parameter
                            background=
                            # Forms applet parameter
                            lookAndFeel=Oracle
                            # Forms applet parameter
                            colorScheme=teal
                            # Forms applet parameter
                            logo=
                            # Forms applet parameter, valid range [0-3]
                            guiMode=0
                            # Forms applet parameter
                            restrictedURLparams=pageTitle,HTMLbodyAttrs,HTMLbeforeForm,HTMLafterForm,log
                            # Forms applet parameter
                            formsMessageListener=
                            # Forms applet parameter
                            recordFileName=
                            # Forms applet parameter
                            serverApp=default
                            # Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
                            archive=frmall.jar
                            # Number of times client should retry if a network failure occurs. You should
                            # only change this after reading the documentation.
                            networkRetries=0


                            # Page displayed to users to allow them to download Sun's Java Plugin.
                            # Sun's Java Plugin is typically used for non-Windows clients.
                            # (NOTE: you should check this page and possibly change the settings)
                            jpi_download_page=http://java.sun.com/products/archive/j2se/6u12/index.html
                            # Parameter related to the version of the Java Plugin
                            jpi_classid=clsid:CAFEEFAC-0016-0000-0012-ABCDEFFEDCBA
                            # Parameter related to the version of the Java Plugin
                            jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6-windows-i586.cab#Version=1,6,0,12
                            # Parameter related to the version of the Java Plugin
                            jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_12
                            # Applet parameter for Sun's Java Plugin
                            legacy_lifecycle=false

                            # Single Sign-On OID configuration parameter: indicates whether we allow
                            # dynamic resource creation if the resource is not yet created in the OID.
                            ssoDynamicResourceCreate=true
                            # Single Sign-On parameter: URL to redirect to if ssoDynamicResourceCreate=false
                            ssoErrorUrl=
                            # Single Sign-On parameter: Cancel URL for the dynamic resource creation DAS page.
                            ssoCancelUrl=
                            # Single Sign-On parameter: indicates whether the url is protected in which
                            # case mod_osso will be given control for authentication or continue in
                            # the FormsServlet if not. It is false by default. Set it to true in an
                            # application-specific section to enable Single Sign-On for that application.
                            ssoMode=false
                            # Single Sign-On parameter: indicates whether session should operate in proxy
                            # user support or not. Specify ssoProxyConnect=yes to enable for particular application.
                            ssoProxyConnect=no

                            # The parameter allow_debug determines whether debugging is permitted.
                            # Administrators should set allow_debug to "true" if servlet
                            # debugging is required, or to provide access to the Forms Trace Xlate utility.
                            # Otherwise these activities will not be allowed (for security reasons).
                            allow_debug=false
                            # Parameter which determines whether new Forms sessions are allowed.
                            # This is also read by the Forms EM Overview page to show the
                            # current Forms status.
                            allowNewConnections=true

                            # EndUserMonitoring

                            # EndUserMonitoringEnabled parameter
                            # Indicates whether EUM/Chronos integration is enabled
                            EndUserMonitoringEnabled=false

                            # EndUserMonitoringURL
                            # indicates where to record EUM/Chronos data
                            EndUserMonitoringURL=

                            # Config for javascript integration
                            applet_name=
                            enableJavascriptEvent=true

                            # Config variable that will indicate if heartbeat will
                            # be blocked when a javascript call is a blocking call.
                            # The default value if false, i.e heart beat will not be
                            # blocked for any javascript calls.
                            JavaScriptBlocksHeartBeat=false

                            # Example Named Configuration Section
                            # Example 1: configuration to run forms in a separate browser window with
                            # "generic" look and feel (include "config=sepwin" in the URL)
                            # You may define your own specific, named configurations (sets of parameters)
                            # by adding special sections as illustrated in the following examples.
                            # Note that you need only specify the parameters you want to change. The
                            # default values (defined above) will be used for all other parameters.
                            # Use of a specific configuration can be requested by including the text
                            # "config=<your_config_name>" in the query string of the URL used to run
                            # a form. For example, to use the sepwin configuration, your could issue
                            # a URL like "http://myhost.example.com/forms/frmservlet?config=sepwin".
                            [sepwin]
                            separateFrame=True
                            lookandfeel=Generic


                            # Example Named Configuration Section
                            # Example 2: configuration running the Forms ListenerServlet in debug mode
                            # (debug messages will be written to the servlet engine's log file).
                            [debug]
                            serverURL=/forms/lservlet/debug

                            # Sample configuration for deploying WebUtil. Note that WebUtil is
                            # only installed with the Forms Builder and is also available for download
                            # from OTN.
                            [webutil]
                            WebUtilArchive=frmwebutil.jar,jacob.jar
                            WebUtilLogging=off
                            WebUtilLoggingDetail=normal
                            WebUtilErrorMode=Alert
                            WebUtilDispatchMonitorInterval=5
                            WebUtilTrustInternal=true
                            WebUtilMaxTransferSize=16384
                            baseHTML=webutilbase.htm
                            baseHTMLjpi=webutiljpi.htm
                            archive=frmall.jar
                            lookAndFeel=oracle
                            [Regie]
                            imageBase=codebase
                            archive=frmall.jar,regie_icons.jar,laf_11112.jar,ComboBoxCompletion.jar
                            separateFrame=True
                            WorkingDirectory=C:\Temp
                            networkRetries=30
                            WebUtilArchive=frmwebutil.jar,jacob.jar
                            WebUtilLogging=off
                            WebUtilLoggingDetail=normal
                            WebUtilErrorMode=Alert
                            WebUtilDispatchMonitorInterval=5
                            WebUtilTrustInternal=true
                            WebUtilMaxTransferSize=16384
                            baseHTML=webutilbase.htm
                            baseHTMLjpi=webutiljpi.htm
                            lookAndFeel=oracle
                            logo=
                            background=http://localhost:7001/forms/java/ERP-Background.gif
                            colorScheme=swan
                            pageTitle=Regie Integrated Business Solution
                            • 11. Re: a search tool similar to google search suggestions for oracle 11g forms
                              François Degrelle
                              Are you sure to use the [regie] section at runtime ?
                              Because in the main global archive, there is no bean added:

                              ...
                              # Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
                              archive=frmall.jar
                              ...

                              Francois
                              • 12. Re: a search tool similar to google search suggestions for oracle 11g forms
                                977568
                                Ah, the regie part is for forms that are integrated with our application it seems. Since this is a dummy form from the bean developer, I had, as you advised, to add the bean's name to the main section.
                                It worked now, I can see the combo box just fine.
                                I am not sure if you are aware of how this bean works, but if you are, do you think it would work (as in to autocomplete or search) for a list that is 1- rather big, 2- in a different language (arabic in my case) and 3- if i start writing a word that is not the first word in the string (as in if the user wants to write a keyword to see if the record exists, this keyword might be in the middle of the string).
                                If not, any idea if there is any other bean that might be useful in this case?
                                Thanks again
                                Regards,
                                • 13. Re: a search tool similar to google search suggestions for oracle 11g forms
                                  François Degrelle
                                  Unfortunately, I cannot say much more on this bean as I have released it a long time ago, and my memory is not as good as it was ;-)
                                  I don't even know if this bean is able to insert a word just typed by the user...

                                  But, as all the material on the Java Bean site is free, you are also free to find a Java developer that could enhance the existing code.

                                  Francois
                                  • 14. Re: a search tool similar to google search suggestions for oracle 11g forms
                                    977568
                                    Thank you! I'll see what I can do :)