Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connectivity

 
R.Lakshmi Narasimhan
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34195
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The JDBC tutorial has plenty of code examples. It will make more sense as you start reading it.
http://java.sun.com/docs/books/tutorial/jdbc/index.html
 
Campbell Ritchie
Sheriff
Posts: 48652
56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Bauke Scholtz
Ranch Hand
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think this is where you find information about it Bauke.
 
Bauke Scholtz
Ranch Hand
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic