I am new to java. I am testing java connectivity using java thin. The script giving an error.
After compilinng I am compiling using javac TestDBOracle.class, I am sunning using java TestDBOracle.
Tried vith various combination of instances
Error Is :
============
Exception in thread "main" java.sql.SQLException: SO Exception was generated
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at TestDBOracle.main(TestDBOracle.java:23)
---
---
===================================
Code for TestDBOracle.java
import java.sql.*;
//(HOST=grievous)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=r12d) (INSTANCE_NAME=r12d1)))grievous
public class TestDBOracle {
public static void main(String[] args)
throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
// jdbc:oracle:thin:@//host:port/service
//String url = "jdbc:oracle:thin:@//myhost:1521/mydb";
// Real Application Cluster database
//String url =
//"jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=yes)(ADDRESS=(PROTOCOL=TCP)(HOST=grievous)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=grievous)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=r12d1)))";
String url = "jdbc:oracle:thin:@(HOST=grievous)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=r12d1) (INSTANCE_NAME=r12d1)))";
//String url = "jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=balin.numatic.root.local) (PORT=1521) ) (CONNECT_DATA= (INSTANCE_NAME=r12e1) (SERVICE_NAME=r12e1)))";
Connection conn =
DriverManager.getConnection(url,"apps","m0nk3y");
conn.setAutoCommit(false);
Statement stmt = conn.createStatement();
ResultSet rset =
stmt.executeQuery("select BANNER from SYS.V_$VERSION");
while (rset.next()) {
System.out.println (rset.getString(1));
}
stmt.close();
System.out.println ("Success!");
}
}