All,

So I finally got things to work. A couple of notes here about things and gotchas...


1) DSN or driver is AdagioDataSourceDriver. It does not matter if you are on a 32bit or 64bit machine.
The value is the same. Using the values in the manual generates a unknown driver error.

2) You must encrypt the password unless you flag the connection string with a "RAWPASSWORD=1"

3) If you are within the 60 day period, you can work with the sample data with no problems with out registering .
I think that you can also work with your data, things got a little out of sync so I am not positive.

4) The Java-ODBC bridge has been removed in Java 8 so either compile with Java 7 or
go through the process of migrating the 7 bridge to 8 with this bit of useful info.
http://bigfatball.blogspot.com/2016/03/how-to-enable-jdbc-odbc-bridge-for-jdk-8.html

5) TestODC will actually return something if you have things right. Otherwise it is a black
hole with no other responses or errors.

Below is my test code to make sure that I could pull data from the Inventory. It works for
me but I won't promise you that it will work for you.

Cheers,
Brian



/*
* <----------------------- Test ODBC Java Code ---------------------------------->
*
* Note You must replace the values in the conStr to match your installation
*
* Works only with Java 1.7 unless you add the ODBC jar into Java 1.8
*/


package com.peacesurplus.odbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestODBC {

private Connection con;
public TestODBC() {

}
public void connectToDatabase(String username, String password) throws SQLException, InstantiationException, IllegalAccessException {

try
{
// Load Sun's jdbc-odbc driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
}
catch (ClassNotFoundException cnfe) // driver not found
{
System.err.println ("Unable to load database driver");
System.err.println ("Details : " + cnfe);
System.exit(0);
}
// DriverManager.setLogStream(System.out);

String conStr = "jdbc:odbc:Driver=AdagioDataSourceDriver;"
+ "NAMES=LONG;"
+ "DBSELELECTOR=PCE;"
+ "COLUMNS=COMMON;"
+ "DBDIRECTORY=H:\\SOFTRAK\\data;"
+ "DBQ=H:\\SOFTRAK\\data PCE;"
+ "USERID=SYS;"
+ "PASSWORD=<HIDDEN>;"
+ "DBFILTER={AN9*};"
+ "TABLESALL=FALSE;"
+ "RAWPASSWORD=1;";




con = DriverManager.getConnection(conStr);



}
private void fullICquery() throws SQLException {

String query = "SELECT \"Item\", \"Description\", \"QtyOnHand\", \"UPC\" FROM \"ICItems123Master__an92aicf\" WHERE \"QtyOnHand\" > 0 AND \"UPC\" > \'0\'";

// TODO Auto-generated method stub
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
int count = rs.getFetchSize();
while (rs.next()) {
// String upc = rs.getString("UPC");
int qty = rs.getInt("QtyOnHand");
String upc = rs.getString("UPC");
int row = rs.getRow();
System.out.println(String.valueOf(row) + ", "+ upc+", "+qty);
}


con.close();
}

public static void main(String[] args) {
// TODO Auto-generated method stub

TestODBC to = new TestODBC();

try {
to.connectToDatabase("", "");
to.fullICquery();

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.exit(0);
}

}

/*
* End of TestODBC.java
*/