open office database in java

[Peter Timbol]

how can i connect an open office database in java?

[r035198x]

how can i connect an open office database in java?

What do you mean by an office database? Java uses ldbc to connect to databases. You may want to read sun's jdbc tutorial.

[Peter Timbol]

i'm using ubuntu.. with open office database..

import java.sql.*;


public class DB {

/**
* @param args
*/
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub

Class.forName("org.hsqldb.jdbcDriver");

Connection mycon=DriverManager.getConnection("jdbc:hsqldb:fil e://home//workspace//Database//db","sa","");
Statement Que=mycon.createStatement();
ResultSet result=Que.executeQuery("SELECT * FROM Table1");

}


im having an exception
Exception in thread "main" java.lang.ClassNotFoundException: org.hsqldb.jdbcDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java: 200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 06)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 51)
at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at DB.main(DB.java:12)

maybe i did not include the hsqldb.jar
how can i include the file? im using eclipse

[JosAH]

maybe i did not include the hsqldb.jar
how can i include the file? im using eclipse

I'm sure you didn't include it; navigate to:

Project>Properties>Java Build Path>Libraries>Add External Jars ...

and add the hsqldb.jar file.

kind regards,

Jos

[Peter Timbol]

its works.. thanks..

but i'm having Table not found in statement [SELECT ID FROM Assets]

i think i can figure this out..

thanks again..

[Peter Timbol]

Is openOffice.org database has a different method in displaying filtered contents?

im having Table not found in java.. and in openoffice itself..

but in queries tab, it will work.. how can i do that in java?

[r035198x]

Is openOffice.org database has a different method in displaying filtered contents?

im having Table not found in java.. and in openoffice itself..

but in queries tab, it will work.. how can i do that in java?

Perhaps you are passing an incorrect table name (case issues e.t.c).

[Peter Timbol]

O just misinterpret the jdbc...

it will create it's own database file if the file is not present..

So you need to create tables etc..

that was great.. thanks guys..