connection

Home/connection

Questions and answers begin here Latest Questions

Asked: 1 year agoIn:

I’m new to database management and I’m facing a really annoying issue that I’d like some help on. I’m trying to connect to a remote Oracle database located on a different machine. I keep getting the error “ORA-02019: connection description ...Read more

I’m new to database management and I’m facing a really annoying issue that I’d like some help on. I’m trying to connect to a remote Oracle database located on a different machine. I keep getting the error “ORA-02019: connection description for remote database not found” whenever I try to establish a connection. I’ve checked everything I can think of, but I can’t figure out what’s wrong.
Here’s the code I’m using to establish the connection:
“`java
String jdbcURL = “jdbc:oracle:thin:@remoteDB:1521:ORCL”;
String username = “myUsername”;
String password = “myPassword”;
Connection conn = null;
try {
Class.forName(“oracle.jdbc.driver.OracleDriver”);
conn = DriverManager.getConnection(jdbcURL, username, password);
System.out.println(“Connection established”);
} catch (SQLException ex) {
System.err.println(“SQLException: ” + ex.getMessage());
} catch (ClassNotFoundException ex) {
System.err.println(“ClassNotFoundException: ” + ex.getMessage());
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException ex) {
System.err.println(“SQLException on closing connection: ” + ex.getMessage());
}
}
}
“`
I know the remote database exists and that the host machine is reachable from my local machine. I’ve also verified that the username and password are correct. Can someone help me figure out what I’m doing wrong? I would really appreciate it.

Read less
connectiondatabasedescriptionerrororacleremotetroubleshooting
  1. Dive into Turkish History
    Your answer is awaiting moderation.

    Explore the significant historical events that shaped Turkey on our website. It's a journey into the past.

    Explore the significant historical events that shaped Turkey on our website. It’s a journey into the past.

    See less
    • 0
Asked: 5 years agoIn:
Teacher

I’ve been working on a website that interacts with a MongoDB database, but I keep running into an error when trying to connect to the MongoDB instance. The error message reads: “MongoError: connect ECONNREFUSED 127.0.0.1:27017”. This happens whenever I try ...Read more

I’ve been working on a website that interacts with a MongoDB database, but I keep running into an error when trying to connect to the MongoDB instance. The error message reads: “MongoError: connect ECONNREFUSED 127.0.0.1:27017”. This happens whenever I try to run my Node.js application.
Here’s my code:

const mongoose = require('mongoose');
mongoose.connect('mongodb://localhost/myDatabase', {useNewUrlParser: true});
const db = mongoose.connection;
db.on('error', console.error.bind(console, 'connection error:'));
db.once('open', function() {
console.log("Connected successfully.");
});

I have already checked that MongoDB is running on the default port (27017). I have also tried using the IP address 0.0.0.0 instead of localhost, but that didn’t work either. What could be causing this error and how can I fix it? Any help would be greatly appreciated.

Read less
connectionerrorlocalhostmongodbNode.js
  1. scytheria.nel Teacher

    It seems like you are facing an issue with connecting to the MongoDB database. There could be several reasons for this error, but one common possibility is that the MongoDB server is not running. To resolve this issue, you can start by checking if the MongoDB service is running. You can do this by rRead more

    It seems like you are facing an issue with connecting to the MongoDB database. There could be several reasons for this error, but one common possibility is that the MongoDB server is not running.

    To resolve this issue, you can start by checking if the MongoDB service is running. You can do this by running the following command in your terminal or command prompt:

    “`sudo service mongod status“`

    If the service is not running, you can start it by running the following command:

    “`sudo service mongod start“`

    If the service is already running, you can try restarting it and then attempting to connect to the MongoDB database again.

    Another reason for this error could be a mismatch between the port number specified in your connection string and the actual port number on which the MongoDB server is running. Make sure that you have specified the correct port number in your connection string.

    I hope this helps you resolve the issue. Let me know if you have any other questions or if this solution does not work for you.

    See less
    • 14