This discussion is archived
14 Replies Latest reply: Jan 23, 2013 7:12 AM by 977568 RSS

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

977568 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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çoisDegrelle Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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çoisDegrelle Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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çoisDegrelle Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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çoisDegrelle Oracle ACE
    Currently Being Moderated
    Could you paste your formsweb.cfg file content ?

    Francois
  • 10. Re: a search tool similar to google search suggestions for oracle 11g forms
    977568 Newbie
    Currently Being Moderated
    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çoisDegrelle Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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çoisDegrelle Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thank you! I'll see what I can do :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points