Hi all - New SAS user here. I have a SAS Data Set that I want to read into a Java program and I'm currently hoping to approach this with a SAS Driver for JDBC (Looking into IOM driver before SAS/SHARE driver). I've been referencing the SAS® 9.4 Drivers for JDBC: Cookbook. This is my code (copied from this page of the JDBC notebook😞 import java.sql.*;
import java.util.Properties;
public class AccessSASData {
public static void main(String argv[])
{
Connection connection;
Properties props;
int i;
Statement statement;
String queryString = "SELECT sup_id, sup_name " +
"FROM mySasLib.suppliers ORDER BY sup_name";
ResultSet result;
double id;
String name;
try {
//CONNECT TO THE SERVER BY USING A CONNECTION PROPERTY LIST
Class.forName("com.sas.rio.MVADriver");
props = new Properties();
props.setProperty("user","jdoe");
props.setProperty("password", "4ht8d");
props.setProperty("librefs", "mySasLib c:\\sasdata';");
props.setProperty("user","sasadm");
props.setProperty("password", "password");
props.setProperty("librefs", "mySasLib '/home/sas/pruebaint';");
connection = DriverManager.getConnection(
"jdbc:sasiom://c123.na.abc.com:8591", props);
//ACCESS DATA
statement = connection.createStatement();
result = statement.executeQuery(queryString);
while (result.next()){
id = result.getDouble(1);
name = result.getString(2);
System.out.println(id + " " + name);
}
statement.close();
connection.close();
}
catch(Exception e){
System.out.println("error " + e);
}
}
} I copied sas.core.jar into my Eclipse project, but am getting a java.lang.ClassNotFoundException: com.sas.rio.MVADriver. What else do I need to do to even just load the driver class? I found this post somewhat helpful, but it didn't resolve my problem.
... View more