SQL query error when using form
-
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 -
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=xml0 -
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 -
Yes -- the same server and browsing from the same server
0 -
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 -
Unfortunately the suggestions have not resolved the issue. What am I missing or overlooking.
Thanks
Dale
0 -
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 -
See attached - error after URL in Google Chrome
Frevvvo error.pdf0 -
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 -
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 -
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 -
The URL resulted in the following message.
The Database Connector has no configuration. Please check the configuration file settings.
0 -
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 -
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.
Comments
14 comments