Example: Connecting OpenOffice to MaxDB Using
JDBC (Linux) 
Prerequisites
· You use a supported Linux operating system.
· You have installed OpenOffice (www.openoffice.org).
· You have installed JDK 1.2 or above.
·
You have installed the MaxDB software
including the JDBC driver (see Installation Manual, 
Installation
Profile) and made it known to the Java Virtual Machine (see JDBC, Including the JDBC
Driver in Environment Variable CLASSPATH).
· You have created the database instance DEMODB, the database user MONA and the schema HOTEL and filled the tables with data (see SQL Tutorial, HOTEL Demo Schema for the SQL Tutorial).
· The database instance DEMODB is in the ONLINE operational state.
·
The X Server is
started.
Procedure
Depending on your system landscape, the procedure may differ from the one described here.
...
1. Add the MaxDB JDBC driver to the Class Path field in OpenOffice: <independent_program_path>/runtime/jar/sapdbc.jar
/opt/sdb/programs/runtime/jar/sapdbc.jar
2. Configure the database instance DEMODB as a data source in OpenOffice. To do this, you require the following information:
Information on the Data Source
Property |
Value |
Name |
Enter any name for the data source, for example demo database |
Database Type |
JDBC |
JDBC Driver Class |
com.sap.dbtech.jdbc.DriverSapDB |
URL |
Path of the database source, for example jdbc:sapdb://localhost/DEMODB |
User Name |
Name of the database user, for example MONA |
Password Required |
Specifies whether a password is required |
Result
Now you can display and edit the tables of the database instance. If required, enter the password of the database user.
Always specify the user name and password in uppercase.
If problems
occur when you log on to the database instance, or if the tables are not
displayed correctly, then you can switch on the JDBC trace for
troubleshooting; see JDBC Manual, Specifying Other
Connection Options.
See also:
Developing Database Applications