Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. try {
  2. Class.forName("com.sap.db.jdbc.Driver");
  3. String url = "jdbc:sap://myhost:39015/?";
  4. String user = "MYUSER";
  5. String password = "PASSWORD";
  6. System.out.println("Connecting to HANA..!");
  7. Connection cn = DriverManager.getConnection(url, user, password);
  8. System.out.println("Connection to HANA successful!");
  9. ResultSet rs = cn.createStatement().executeQuery("select * from "TWEETS"");
  10. rs.next();
  11. System.out.println(rs.getString(1));
  12. } catch (Exception e) {
  13. e.printStackTrace();
  14. }
  15.  
  16. com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259] (at 14): invalid table name: Could not find table/view TWEETS in schema SYSTEM: line 1 col 15 (at pos 14)
  17. at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:334)
  18. at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:165)
  19. at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:104)
  20. at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1110)
  21. at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:854)
  22. at com.sap.db.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:925)
  23.  
  24. `
  25. 1. "select * from TWEETS"
  26. 2. "select * from SYSTEM.TWEETS"
  27. 3. "select * from "TWEETS"
  28. 4. "select * from "SYSTEM"."TWEETS"" `
  29.  
  30. `
  31. CREATE COLUMN TABLE TWEETS(
  32. "ID" INTEGER NOT NULL,
  33. "USER_NAME" NVARCHAR(100),
  34. "CREATED_AT" DATE,
  35. "TEXT" NVARCHAR (140),
  36. "HASH_TAGS" NVARCHAR (100),
  37. PRIMARY KEY("ID")
  38. );
  39.  
  40. `
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement