Advertisement
Guest User

Untitled

a guest
Mar 10th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. class Task implements Runnable {
  2. public void run() {
  3.  
  4. String routerIP ="*.*.*.*"; //blanked it out for privacy reasons
  5.  
  6. //String url = "jdbc:pervasive://192.168.1.139:1583/DB"; // THIS WORKS LOCALLY
  7. String url = "jdbc:pervasive://" + routerIP + ":1583/DB"; //this throws exception
  8. String query = "select NAME from CUSTOMER";
  9. Statement stmt;
  10. try {
  11. Class.forName("com.pervasive.jdbc.v2.Driver");
  12. } catch (Exception e) {
  13. Log.d("ClassNotFoundException:", e.toString());
  14. toast1.show();
  15. }
  16. try {
  17. Connection conn = DriverManager.getConnection(url, "username", "password");
  18. stmt = conn.createStatement();
  19. ResultSet rs = stmt.executeQuery(query);
  20. ResultSetMetaData rsmd = rs.getMetaData();
  21. int numberOfColumns = rsmd.getColumnCount();
  22.  
  23. int i = 1;
  24. while (rs.next()) {
  25. for (i = 1; i <= numberOfColumns; i++) {
  26. Log.d("Data", rs.getString(i));
  27. myStringArray1.add(rs.getString(i));
  28. }
  29. }
  30.  
  31. stmt.close();
  32. conn.close();
  33.  
  34. } catch (SQLException ex) {
  35. Log.d("Error", ex.toString());
  36. toast2.show();
  37. }
  38. }
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement