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.html5) 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
*/
Previous Topic
Index