Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set database connection from java class.

ShemeerNov 30 2016 — edited Nov 30 2016

I want to get my database connection from java class instead of using JDBC Datasource or JDBC URL at runtime.

For example I will write my java class for getting my connection as follows.

import java.sql.Connection;

import java.sql.SQLException;

import oracle.jdbc.pool.OracleDataSource;

public class DataHandler {

  public DataHandler() {

  }

  String jdbcUrl = null;

  String userid = null;

  String password = null;

  Connection conn;

  public void getDBConnection() throws SQLException{

  OracleDataSource ds;

  ds = new OracleDataSource();

  ds.setURL(jdbcUrl);

  conn=ds.getConnection(userid,password);  

  }

}

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2016
Added on Nov 30 2016
7 comments
365 views