Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Just need to download a free oracle DB for home use

 
Tony Evans
Ranch Hand
Posts: 598
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
if used by yourself,i suggest the mysql,because it is small
 
Jan Cumps
Bartender
Posts: 2602
13
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Tony Evans
Ranch Hand
Posts: 598
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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();
}
}
}

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic