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