import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
/*
* Here we will learn to Create Table in DB using JDBC Statements in Oracle and MySQL DB
*/
public class CreateTableWithStatement {
public static void main(String[] args) {
String tableCreateQuery = "create table JBT(name varchar2(10), course varchar2(10))";
Statement statement = null;
Connection connection = null;
Scanner scanner = new Scanner(System.in);
System.out
.println("Please provide below details to connect Oracle Database");
System.out.println("Enter Database");
String dbName = scanner.next();
System.out.println("Enter UserName");
String userName = scanner.next();
System.out.println("Enter Password");
String password = scanner.next();
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
connection = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:" + dbName, userName,
password);
} catch (SQLException e) {
e.printStackTrace();
}
if (connection != null) {
System.out.println("nSuccessfullly connected to Oracle DB");
try {
statement = connection.createStatement();
System.out.println("Create Table Query :"+tableCreateQuery);
statement.execute(tableCreateQuery);
System.out.println("Table Created Successfully");
} catch (SQLException e) {
e.printStackTrace();
}
} else {
System.out.println("nFailed to connect to Oracle DB");
}
}
}
where can i find the created table in my oracle 11g express edition?
I have the same question !!
“where do i find the created table in my oracle 11g express edition ? “
remove that db name from query
connection = DriverManager.getConnection(
“jdbc:oracle:thin:@localhost:1521:” , userName,
password);
table created successfully but was unable to describe that table in oracle 11g.
i got this error/////////
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at CreateTableWithStatement.main(CreateTableWithStatement.java:29)
Failed to connect to Oracle DB
Process completed.
Hi Suma,
As mentioned clearly in the error this problem is related to connection to Oracle DB.
There could be several reason behind it. Check for the firewall access. Also chekc the tnsname.ora file for proper configuration.
You can also use “tnsping” command in command prompt to check if connectivity is proper or not.
First check the connectivity of Oracle DB then try to create table in DB.
Please let me know if you need more help.
Thanks