Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class Task implements Runnable {
- public void run() {
- String routerIP ="*.*.*.*"; //blanked it out for privacy reasons
- //String url = "jdbc:pervasive://192.168.1.139:1583/DB"; // THIS WORKS LOCALLY
- String url = "jdbc:pervasive://" + routerIP + ":1583/DB"; //this throws exception
- String query = "select NAME from CUSTOMER";
- Statement stmt;
- try {
- Class.forName("com.pervasive.jdbc.v2.Driver");
- } catch (Exception e) {
- Log.d("ClassNotFoundException:", e.toString());
- toast1.show();
- }
- try {
- Connection conn = DriverManager.getConnection(url, "username", "password");
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery(query);
- ResultSetMetaData rsmd = rs.getMetaData();
- int numberOfColumns = rsmd.getColumnCount();
- int i = 1;
- while (rs.next()) {
- for (i = 1; i <= numberOfColumns; i++) {
- Log.d("Data", rs.getString(i));
- myStringArray1.add(rs.getString(i));
- }
- }
- stmt.close();
- conn.close();
- } catch (SQLException ex) {
- Log.d("Error", ex.toString());
- toast2.show();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement