Download RETE-DB - Manual

106
APPENDIX E. DESIGN
E.5
Design of Request URLs
The request URLs (Uniform resource locators) are defined in such a way that
• No URL should exceed the 1024 byte limit. (This cannot be guaranteed)
• A user can bookmark any URL or send it to someone else so that the same page
will be visible when the URL is requested again.
E.5.1
find Parameter
In general, a query URL contains a phrase like ”...find=a2o3e...”. The first a says that
the criteria of the different columns shall be connected by an AND operator. Replace
the ”a” by an ”o” to connect the criteria of the different columns by OR. Or prepend
an ”n” in front of the ”a2o3e...” query to get all results that do not match the specified
criteria (n=NOT).
The digit 2 says that there are 2 columns that are connected by AND. The o3 says
that there are three criteria on the first column that are logically connected by an OR.
Note:
• The NOT operator might produce unexpected results when applied to TEXT,
DATE and TIME fields due to possible NULL values.
E.6
Errors
Table ’rete db meta.accs users data’ doesn’t exist:
You get a ”java.lang.RuntimeException:
java.sql.SQLException:
Table
’rete db meta.accs users data’ doesn’t exist” if you delete the database while
RETE-DB is running.
In this case you need to restart the RETE-DB servlet.
No such file or directory:
You get a java.lang.RuntimeException: java.io.IOException: No such file or directory
exception if either the FileUpload TempFolder in the web.xml file does not exist or is
write protected or if the Archive Folder of the project does not exist or is write protected.
Login impossible or changing data does not work:
These effects may occur if your harddisk is full or if the MySQL database file has reached
the maximum file size of your filesystem.