File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Java and SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Java and SQL" Watch "Java and SQL" New topic

Java and SQL

Brandi Love
Ranch Hand

Joined: Sep 19, 2003
Posts: 133
Hey all. I'm working on a project and I would like to use java with a sql database. I don't know a whole lot about sql (though I understand its not too terrible difficult)and I have no idea how to make it interact with java at all. Does anyone know of any guides that might help me get started or what software I might need for the sql side of things? Any help would be more than appreciated!
Ilja Preuss

Joined: Jul 11, 2001
Posts: 14112
That's what JDBC is good for. See

Moving to our JDBC forum...

The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
Brandi Love
Ranch Hand

Joined: Sep 19, 2003
Posts: 133
Thanks for the link, that was very helpful Is there a specific dbms anyone recommends?
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

What's the best type of car?

Sorry, depends on your requirements. There are some extremely light databases like Hypersonic (HSQLDB) but while it is fine playing around it isn't suitable for real systems. MySQL is a good free database with a rich set of features but is harder to set up and maintain. Something large scale like Oracle is so rich you can make a career of learning what it can do, but you run the risk of learning Oracle rather than JDBC.


I agree. Here's the link:
subject: Java and SQL
It's not a secret anymore!