Staroffice 7 - jdbc - linux - oracle setup

[Eric Sundby]

What a pain getting this to work... I'm not real versed in java at the
moment so it's probably not hard for someone with that experience but I
thought I'd post my steps for others looking at how to do this.

1. Make sure you have Oracle client installed with jdbc.
(check to make sure you have an ORACLE_HOME/jdbc directory

2. Startup Star Office 7 Spreadsheet (xcalc)

3. Goto Tools-Options-Security

4. Enter the following two entries in the ClassPath location:
/home/oracle/jdbc/lib/classes12.jar
/home/oracle/jdbc/lib/nls_charset12.jar
(replace /home/oracle with whatever your oracle_home is)

5. Restart Star Office

6. Select Tools-Data Sources

7. Select New Data Source

8. Under the General Tab
Name: Portal(or whatever)
Connection
Database type: JDBC
Data Source URL: jdbc:oracle:thin:@10.31.1.19:1521:portal2

9. Under the JDBC Tab
JDBC driver class: oracle.jdbc.driver.OracleDriver
URL: jdbc:oracle:thin:@10.31.1.65:1521:mydb
User name: scott
Check PASSWORD REQUIRED

(the JDBC Driver Class is important!)

Who says you need MS Excel!

Eric Sundby
er...@sundby.net