0
Cargando...
hi,
I had some trouble
I think about the Java code has some problem
import java.sql.*;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
public class CRSampleDataSourceBean {
private ResultSet resultSet = null;
private Connection connection = null;
private String connectionURL = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.x)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SID)))";
private String databaseClass = "oracle.jdbc.driver.OracleDriver";
private String query = "SELECT 1 AS ONE FROM DUAL";
public ResultSet CRSampleDataSourceBean() {
try {
// Ensure database class exists
Class.forName(databaseClass);
// Create a connection
connection = DriverManager.getConnection(connectionURL, "xx",
"xxx");
// Create an SQL statement to execute
Statement statement = connection
.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
// Execute the select statement to populate the ResultSet
resultSet = statement.executeQuery(query);
while (resultSet.next()) {
String name = resultSet.getString("ONE");
// Display values
System.out.print("value: " + name);
}
} catch (ClassNotFoundException ex) {
System.out.println("Ensure that database driver class
Respondido el 15/04/2024
LUCIANO RIOJA GHIOTTO
Se unió el 13/07/2019
