SQL query error when using form

Dale McClung

April 21, 2015 02:08

TypeError: A DOCTYPE is not allowed in content.

OrderFormV2_form.zip
configuration.xml

Comments

14 comments

Prajakta April 22, 2015 14:47

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

Comment actions Permalink
Dale McClung April 22, 2015 17:16

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

Comment actions Permalink
Prajakta April 22, 2015 19:03

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

Comment actions Permalink
Dale McClung April 22, 2015 20:45

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

0

Comment actions Permalink
Prajakta April 23, 2015 20:36

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

Comment actions Permalink
Dale McClung April 28, 2015 17:36

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

Thanks

Dale

0

Comment actions Permalink
Prajakta April 28, 2015 19:03

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

Comment actions Permalink
Dale McClung April 28, 2015 19:25

See attached - error after URL in Google Chrome

Frevvvo error.pdf

0

Comment actions Permalink
Prajakta April 28, 2015 19:27

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

Comment actions Permalink
Dale McClung April 29, 2015 12:12

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

Comment actions Permalink
Prajakta April 29, 2015 15:01

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

Comment actions Permalink
Dale McClung April 30, 2015 00:37

The URL resulted in the following message.

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

0

Comment actions Permalink
Prajakta April 30, 2015 14:18

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

Comment actions Permalink
Dale McClung May 01, 2015 04:00

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

Thanks

0

Comment actions Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?