I am using Linux Ubuntu.I am not so good in Java.I need to connect to a Database for which I have installed OpenOffice.org Database. I would like to use JDBC . I could not find any material for providing connection.Please give me directions for connection.If possible please provide me some example codes.
You may be better off with something like MySQL rather than OpenOffice. You will find the links to MySQL documentation here; find the manual, and you will need to look for connector instructions, which are section 21.4 in the manual. You will need to follow the instructions to the letter.
Also make sure to find a decent SQL tutorial. There is a tutorial on that link I posted, but writing SQL is an art all of its own.
I´ve never heard of the "OpenOffice Database", so I googled a bit. Technical information about this database is surprisingly hard to find or doesn´t seem to exist. After reading the "problem topics" related to it, it look like that it is based on Hypersonic and that you can use its JDBC driver for it as well.
At any way, if you want an embedded database, I recommend to just use the JDK´s built-in JavaDB (formerly known as Derby) or Hypersonic. If embeddability is not a pre-requisiste, then just go for for example MySQL. The JDBC driver and the appropriate documentation are normally just available at their (download) homepage.
The whole point of "OpenOffice Database" is fairly confusing. Hypersonic here, PostgreSQL there, MySQL here, SQLite there. I expected a full fledged RDBMS with an even so JDBC driver. But here is just means of relabeling.
Bauke Scholtz wrote:The whole point of "OpenOffice Database" is fairly confusing. Hypersonic here, PostgreSQL there, MySQL here, SQLite there. I expected a full fledged RDBMS with an even so JDBC driver. But here is just means of relabeling.
I think the point of it is an abstraction layer on top of an existing RDBMS, rather than an re-implementation of an RDBMS itself. That part of the implementation appears to be plugable.