Linux.com

I 'ave worked through "SAMS TEACH YOURSELF JAVA 6 in 21 Days" in Windows XP environment + MS Access I am now going through in UBUNTU 8.10 using Eclipse 3.2 + IcedTea 6 JDK, with Open Office 3.0 Chapter [day] 18 see topic subject I 'ave exported relevant Tables into OO3.database using MDB-tools GUI [b]I need to create a JDBC-ODBC Bridge [/b] import java.sql.*; public class CoalReporter { public static void main(String[] arguments) { String data = "jdbc:odbc:WorldEnergy"; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection( data, "", ""); Statement st = conn.createStatement(); ResultSet rec = st.executeQuery( "SELECT * " + etc [i]I have tried hsqldb.jar and altered code but no joy[/i] I am stumped, rest of Book works OK in 'new' environment!