wood burning stoves 2.0*
The moose likes JDBC and the fly likes Just need to download a free oracle DB for home use Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Just need to download a free oracle DB for home use" Watch "Just need to download a free oracle DB for home use" New topic
Author

Just need to download a free oracle DB for home use

Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 579
Looking for a free oracle DB download just for home study use. Just want to create a few simple tables an connect to them from a java app.

Cheers for any help
wang lei
Greenhorn

Joined: Mar 09, 2010
Posts: 12
if used by yourself,i suggest the mysql,because it is small
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2504
    
    8

MySQL is very good. It is from Oracle.

If you are looking for the Oracle database, that is free for download on http://www.oracle.com/technology/software/index.html
The Development license grants you:
Free to download, free to learn, unlimited evaluation time
Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 579
found a free oracle database to download

http://www.oracle.com/technology/products/database/xe/index.html

Downloads Oracle enterprise edition 10G.

I am using eclipse so then add
c:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar

to your eclipse build path

public class ConnectionTest {

static public void main(String argcv []){
Connection conn = null;
String driverName = "oracle.jdbc.driver.OracleDriver";
try {
Class.forName(driverName);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection("jdbcracleci8:@","hr","hr" );
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Employees");
while (rs.next()) {
int id= rs.getInt(1);
System.out.println("EMPLOYEE_ID "+id);
}

} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
}

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Just need to download a free oracle DB for home use