HELP JSP for SQL Queries
XSQL query the default database
and output XML (transformed by the IE5 browser) IE5 is required !
The form submits the query to the JSP xsql.jsp
SQL query the default database and output HTML table
The form submits the query to the JSP sql.jsp
COMING SOON ! TSQL query the default database and output HTML table
The form submits the query to the JSP which includes JSP TagLibs devoded to JDBC connactions ad queries.
COMING SOON ! CSQL query the default database and output HTML table
The form submits the query to the Coccon XSP csql.xsp
WMLSQL query the default database and output WML table
Test it from a WAP/WML browser or emulator (Nokia, UP, ...)
Configure the Database
For MS Access
Config
The default database is factcmd.mdb, an MS Access database
You must configure the ODBC source named "ECOM" with factcmd.mdb
For Oracle
Config
The database must be generated with the SqlPlus scripts located in
./factcmd-db4oracle
You must include the driver (.zip or .jar) in the servlet server's CLASSPATH
For MySQL
Config
For PostGres
Config
For InstantDB (v4 from Lutris)
Config
For InstantDB (v3 from Enhydra)
Config
For InterBase
Config
Send your comments to Didier.Donsez@imag.fr