Categories
java

jdbc hello world

I am in a java mood today, let’s check how to print hello world with jdbc 🙂
import java.sql.*;
public class HelloWorld {
public static void main(String[] args) throws SQLException {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
ResultSet res = DriverManager.
getConnection("jdbc:oracle:thin:@srv1:1521:DB01", "scott", "tiger").
prepareCall("select 'Hello World' txt from dual").
executeQuery();
res.next();
System.out.println(res.getString("TXT"));
}
}

let’s compile
javac -classpath $ORACLE_HOME/jdbc/lib/classes12.jar HelloWorld.java

and run
$ java -classpath $ORACLE_HOME/jdbc/lib/classes12.jar:. HelloWorld
Hello World

that’s all folks!

By Laurent Schneider

Oracle Certified Master

8 replies on “jdbc hello world”

Just one problem: find the correct version of classes12.jar

Performance team is fond of this solution 🙂

A java is a good program, and a nice way to develop with oracle database.
JDBC Thin doesn’t need tnsnames… that’s nice. But if need to use RAC(TAF) JDBC OCI may a better way …

By the way, Connection Pooling + Caching are good thing to learn and …

Enjoy!

[…] Link to the original site Tags: Class Helloworld, Getconnection, Getstring, Hello World, Import Java, Java Classpath, Jdbc Oracle, Lib, Main String, Nbsp Nbsp Nbsp Nbsp Nbsp, Oracle, ORACLE BLOGS, Oracle Home, Oracle Jdbc, Quot Quot, Resultset, Run Java, Srv1, String Args, Tiger […]

Leave a Reply

Your email address will not be published.