Establish connection between app server and oracle database using java

Question

I have been given a task to write a script in java, to connect oracle database from an app server. Scheduling tool will be used to schedule the job every 10 minutes.

If connection exists, the script will do nothing and just disconnect it. (and will be run again after 10 minutes). If cannot connect after 10 secs, the program will send an email notification.

The whole thing is to ensure connection can be established between the app server and the oracle db.

Really have no clue on this. Could you please advise what are the steps to do this and what Java APIs I'll need??

Many many thanks in advance!

Bob Jarvis - Слава Україні · Accepted Answer · 2015-08-14 02:48:38Z

1

You will need classes out of the java.sql package. Assuming Java 7+.

import java.sql.*;

public class Test {
    public static void main(String[] args) {
        String url = "..."; // Specify according to JDBC driver in use
        String sql = "SELECT 1 FROM DUAL"; // Test statement. Change depending on SQL vendor
        try (Connection conn = DriverManager.getConnection(url);
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery(sql)) {
            while (rs.next()) {/*Nothing to do*/}
        } catch (SQLException e) {
            // Send email here
        }
    }
}

edited Aug 14, 2015 at 2:48

Bob Jarvis - Слава Україні

50.2k10 gold badges81 silver badges119 bronze badges

answered Aug 14, 2015 at 0:58

Andreas

160k13 gold badges164 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Andreas Over a year ago

@Bob Thanks for the update. I didn't see the oracle tag.

Dorisacat Over a year ago

Thank you for your prompt reply!

kachanov · Accepted Answer · 2015-08-14 00:57:59Z

1

If you are using J2EE App Server, create a database connection pool there which your application is also going to use.

One of the parameters of the database pool can be to verify the connection at regular intervals by sending simple SQL. Then your task boils down just to monitor the logs to see if database connection pool throws any errors when polling.

answered Aug 14, 2015 at 0:57

kachanov

2,7752 gold badges21 silver badges17 bronze badges

1 Comment

Dorisacat Over a year ago

Thanks so much for the quick response.

Collectives™ on Stack Overflow

Establish connection between app server and oracle database using java

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related