Netbeans-Oracle DB-AWS“amazon RDB”-java 8

Question

我想将我的java文件连接到amazon oracle数据库。

public class DataSource {

private static String dbName = System.getenv("PUBLIC");
private static String userName = System.getenv("root");
private static String password = System.getenv("3deemala7sas");
private static String hostname = System.getenv("oracleinstance.ctnrs4kazdmm.ap-south-1.rds.amazonaws.com");
private static String port = System.getenv("1521");

public static final String JDBC_DRIVER = "oracle.jdbc.OracleDriver";
public static final String DB_URL = "jdbc:oracle:thin://" + hostname + ":" + port + "/" + dbName + "?user=" + userName + "&password=" + password;

public static boolean checkDomain()
{
    if (System.getenv("oracleinstance.ctnrs4kazdmm.ap-south-1.rds.amazonaws.com") != null) {
        return true;
    }
    return false;
}

public static Connection getConnection( )
{


    try {
        Class.forName(DataSource.JDBC_DRIVER);
         connection = DriverManager.getConnection(DataSource.DB_URL);
        //connection = (Connection) DriverManager.getConnection(DataSource.DB_URL);

        System.out.println("Connected ....");

        return connection;
    }
     catch (SQLException ex) {
        System.out.println("Error syntax");
         System.out.println(ex.toString());
         ex.printStackTrace();
    }catch (ClassNotFoundException ex) {
        System.out.println("Class not found error ...");
    }


    return null;
}

public class App01 {



public static void main(String[] args) throws SQLException {
    Connection connection = null ;
    System.out.println(DataSource.checkDomain());
   connection =  DbConnection.getConnection();

}}

JAVAsql。SQLRecoverableException:IO错误：网络适配器无法建立连接

注意：我已经使用dbvisualizer成功连接，还尝试使用neatbeas数据库服务，但它也没有连接

Netbeans错误：无法建立到jdbc:oracle:thin:@oracleinstance的连接。ctnrs4kazdmm。ap-south-1。rds。亚马逊。com:1521:XE使用oracle。jdbc。OracleDriver（侦听器拒绝连接，出现以下错误：ORA-12505，TNS:侦听器当前不知道连接描述符中给出的SID）

Answer 1

根据您的错误消息ORA-12505，TNS:listener目前不知道connect descriptor中给出的SID，我认为您的连接字符串中有一个错误。具体来说，您可能使用了错误的SID。

oracleinstance。ctnrs4kazdmm。ap-south-1。rds。亚马逊。com:1521:XE

尝试以下连接字符串，oracleinstance。ctnrs4kazdmm。ap-south-1。rds。亚马逊。com:1521:orcl。通常，在RDS中创建Oracle实例时，默认SID为orcl。

您还可以使用AWS CLI来确定SID。

$ aws rds describe-db-instances
{
"DBInstances": [
...
  {
        "DBInstanceStatus": "available",
        "DBInstanceIdentifier": "MYORACLEDB",
        "MasterUsername": "USERWITHSYSDBA",
        "EngineVersion": "11.2.0.4.v1",
        ...
        "Endpoint": {
            "Port": 1521,
            "Address": "MYORACLEDB.blahblahblach.us-west-2.rds.amazonaws.c                                                                                                                                                         om"
        },
        "PendingModifiedValues": {},
        ...
        "DBName": "ORCL",
        ...

其中DBName是SID（在本例中为ORCL）。

Answer 2

谢谢你回答我的问题。

我已经弄清楚了。错误在于您提到的连接db的URL。所以，发现的是url应该是这样的：-

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@"+hostname+":1521:orcl", "username", "password");

ORCL是AWS（亚马逊云）的defualt db名称

谢谢