wood burning stoves*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 573
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: 2491
    
    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: 573
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();
}
}
}

 
jQuery in Action, 2nd edition
 
subject: Just need to download a free oracle DB for home use
 
Similar Threads
Database for study..J2EE
Project from home
Getting OC4J 10g, how ??
prepared statement in for loop
Oracle Weblogic server is free to download and use ?