Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Class.forName("com.sap.db.jdbc.Driver");
- String url = "jdbc:sap://myhost:39015/?";
- String user = "MYUSER";
- String password = "PASSWORD";
- System.out.println("Connecting to HANA..!");
- Connection cn = DriverManager.getConnection(url, user, password);
- System.out.println("Connection to HANA successful!");
- ResultSet rs = cn.createStatement().executeQuery("select * from "TWEETS"");
- rs.next();
- System.out.println(rs.getString(1));
- } catch (Exception e) {
- e.printStackTrace();
- }
- 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)
- at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:334)
- at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:165)
- at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:104)
- at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1110)
- at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:854)
- at com.sap.db.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:925)
- `
- 1. "select * from TWEETS"
- 2. "select * from SYSTEM.TWEETS"
- 3. "select * from "TWEETS"
- 4. "select * from "SYSTEM"."TWEETS"" `
- `
- CREATE COLUMN TABLE TWEETS(
- "ID" INTEGER NOT NULL,
- "USER_NAME" NVARCHAR(100),
- "CREATED_AT" DATE,
- "TEXT" NVARCHAR (140),
- "HASH_TAGS" NVARCHAR (100),
- PRIMARY KEY("ID")
- );
- `
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement