wood burning stoves*
The moose likes JDBC and the fly likes JDBC connectivity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC connectivity" Watch "JDBC connectivity" New topic
Author

JDBC connectivity

R.Lakshmi Narasimhan
Greenhorn

Joined: Feb 02, 2009
Posts: 5
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36453
    
  15
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

Joined: Oct 08, 2006
Posts: 2458
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

Joined: Apr 14, 2004
Posts: 10336

I think this is where you find information about it Bauke.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
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

Joined: Apr 14, 2004
Posts: 10336

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC connectivity
 
Similar Threads
Which database should be used?
Microsoft Access DB
How does jdbc handles concurrency?
SQL Server 2000
jdbc connection through Microsoft SQL Server2000