Skip to main content

Comments

14 comments

  • Prajakta

    Hi Dale,

    In your rule, you are using:

    eval('x='+http.get('http://localhost/OSAS/osaslkup/allCustomers')); 

    Instead, it should be:

    eval('x='+http.get('http://localhost/osaslkup/OSAS/allCustomers')); 

    According to your configuration.xml file, 'osaslkup' is your queryset name and 'OSAS' is your query name.

     

    To test if your DB connector query is working outside frevvo form, you can browse the query URL http://localhost/osaslkup/OSAS/allCustomers in your browser and see if it returns correct data.

     

    Thanks,

    Prajakta

    0
  • Dale McClung

    Getting this message when I process the form  and the url returned the result below:

     HTTP Error 404.0 - Not Found
    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

                           

     TypeError: A DOCTYPE is not allowed in content. ([Order FormV2.Lookup Customer Name]#6(eval)#1)
    7 VERBOSE HTTP_END  GET status=404 (20 ms)
    6 TRACE HTTP_RESULT  GET status=404 (length=4884)
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <title>IIS 8.0 Detailed Error - 404.0 - Not Found</title>
     ...
    5 VERBOSE HTTP_START  GET http://localhost/osaslkup/OSAS/allCustomers?_mediaType=xml

     

     

    0
  • Prajakta

    Are your frevvo forms and database connector on same server? Are you browsing the URL from that same server? If not then you will have to replace localhost in your URL with that server's IP address. 

    0
  • Dale McClung

    Yes -- the same server and browsing from the same server

    0
  • Prajakta

    Hi Dale,

    I am sorry. The URL should be:

    http://localhost/database/osaslkup/OSAS/allCustomers

     

    The /database was missing in the URL before. 

     

    Also, is your frevvo server running on default port 80? If not, then you will have to include the port in your URL. For example, localhost:8082

    0
  • Dale McClung

    Unfortunately the suggestions have not resolved the issue.  What am I missing or overlooking.

    Thanks

    Dale

    0
  • Prajakta

    What do you see if you browse http://localhost/database/status in your browser? 

    Do you see any errors in the catalina.log file in \tomcat\logs directory?

    0
  • Dale McClung

    See attached - error after URL in Google Chrome




    Frevvvo error.pdf
    0
  • Prajakta

    Can you confirm if the database connector is running on port 80? What URL do you use to browse frevvo? Is that URL working, are you able to launch frevvo login page?

    0
  • Dale McClung

    This is the link to the frevvo login page which is working.

    http://192.168.1.64:8082/frevvo/web/login

    Below is the db connector info

    <dbconnector version="2.0">
        <queryset name="osaslkup" dateFormat="yyyy-MM-dd" xmlDateFormat="yyyy-MM-dd" xmlTimeStampFormat="MM/dd/yyyy">
            <resource-def>
                <url>jdbc:sqlserver://192.168.1.64:8082\getsmart;databaseName=OSAS</url>
                <driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
                <user>*********</user>
                <password>**********</password>
            </resource-def>
      
      <query name="allCustomers">
                <retrieve>
                    <statement>select * from tblCustomer</statement>
                </retrieve>
         </query>
      </queryset>
      
    </dbconnector>

    0
  • Prajakta

    So looks like your frevvo and DB connector tomcat is running on port 8082.

     

    Please try the DB connector query URL with server IP address and port 8082 in it:

    http://192.168.1.64:8082/database/osaslkup/OSAS/allCustomers

     

    This should give you correct results.

     

    0
  • Dale McClung

    The URL resulted in the following message.

    The Database Connector has no configuration. Please check the configuration file settings.

    0
  • Prajakta

    Please see this documentation about configuration file required for the DB connector. Have you setup the configuration.xml file in correct location on your server?

    0
  • Dale McClung

    The document referenced help resolve the issue.  The queries now work and the dynamic dropdowns are now populated correctly from the DB

    Thanks

    0

Please sign in to leave a comment.