JDBC

Executing a Stored Procedure using Java

You can execute a stored procedure using Java using a CallableStatement
 Connection connection = null;
        try {
            // Instantiate  the appropriate JDBC driver
            final String driverName = "oracle.jdbc.driver.OracleDriver";
            Class.forName(driverName);
 
            // Connection parameters
            final String databaseHost = "databaseHost";
            final String portNumber = "1527"; //Port Number
            final String sid = "dbname";
            final String url = "jdbc:oracle:thin:@" + databaseHost + ":" 

Connecting to Oracle Database using JDBC

Connection connection = null;
try {
 // Instantiate  the appropirateJDBC driver
    final String driverName = "oracle.jdbc.driver.OracleDriver";
    Class.forName(driverName);
 
    // Connection parameters
    final String databaseHost = "hotsname";
    final String portNumber = "1521"; //Port on which oracle database is running
    final String sid = "dbname";
    final String url = "jdbc:oracle:thin:@" + databaseHost + ":" + portNumber + ":" + sid;
    final String username = "username";
    final String password = "password";
    connection = DriverManager.g
Syndicate content