Establishing Connection and Execute Query Using JDBC Driver

This example code shows how to connect and execute query using JDBC Driver:

String url = "jdbc:oracle:enterpriseone://JDV920"; String user = “JDE’;
String password = “JDE”;
String query = "SELECT COUNT(DISTINCT SAL),AVG(SAL),HMCO FROM F060116 GROUP BY HMCO";
Connection conn = null; ResultSet rs = null;

try{
JDBCDriver driver = new JDBCDriver();
conn = driver.connect(url, user, password); rs = driver.executeQuery(conn, query);
---
---
---
} catch (SQLException e) {
}finally{
if(rs != null) rs.close();
if (conn != null) conn.close();
}

Starting with Tools Release 9.2.7, you can connect to ERP environments with token-based authentication. The example code shows how to connect and execute query using token-based authentication with JDBC Driver.

String url = "jdbc:oracle:enterpriseone://JDV920"; String user = "JDE’;
String token = “XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX’;
String query = "SELECT COUNT(DISTINCT SAL),AVG(SAL),HMCO FROM F060116 GROUP BY HMCO";
Connection conn = null; ResultSet rs = null;

try{
JDBCDriver driver = new JDBCDriver();
conn = driver.connectUsingToken(url, user, token); rs = driver.executeQuery(conn, query);
---
---
---
} catch (SQLException e) {
}finally{
if(rs != null) rs.close();
if (conn != null) conn.close();
}