Setting Up the Data Access Infrastructure
To use the JdbcSource data access component, considerable infrastructure must be set up. Make sure that you do the following setup to correctly install and run the applet:
- Setup one or more databases (typically a Relational database or Notes database)
- Setup a Web server (Domino, for example)
- Install database client elements on the Web server (e.g. Notes API, SQL Server "dblib" or Oracle SQL*Net)
- Install the JDBC elements on the Web server. This includes:
- A vendor's alternate "java.sql" package, e.g. "symjava.sql", "dataramp.sql", "jdbc.sql"
- Classes which implement the JDBC driver, and any classes needed by the driver
- Middleware executables (for example, dbaw.exe and the .dlls it requires). Depending on the exact middleware and database being used, this may include installing ODBC driver(s) on Web server (for example, the NotesSQL ODBC to Notes-API driver, or an ODBC to SQL Server driver, or an ODBC to Oracle driver);
- Register ODBC data source names
- Make one or more .HTML pages which use lotus.jdbc.JdbcSource available on the Web server
- Start the middleware executable (e.g. Symantec's dbaw.exe)
Only after all the above are setup is it possible to exercise JdbcSource.