on 10-15-2014 1:10 PM
Hello SDN!
My WebDynpro application should connect to HANA DB via JDBC and read some data. We've made settings according to this http://help.sap.com/SAPhelp_nw73/helpdata/en/1c/e05bc0c9ca41a783169ce4e18c1bfe/content.htm?frameset=.... But now I'm confused how to get a connection to the DB. If I use the following code:
Class.forName("com.sap.db.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:sap://hanaServer:31015/?autocommit=false");
without user credentials, then I get an error "com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException: [10]: invalid username or password".
If I use credentials, everything is ok, but in this case URL to DB and user's credentials are hardcoded which is no good. There're destinations in the link mentioned above. How I can use these destinations in my code to get connection?
regards,
Lev
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lev
Could you refer the SAP KBA for the exception
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sriram!
I'm afraid that this note is not suitable for me since this note for SAP BI and I'm talking about SAP NW 7.31 and Web Dynpro applications.
Is it true, that JDBC destinations are not for using in WDJ applications? And the only way to connect to the HANA DB from WDJ app is using the JDBC Connection pool? Please correct me if I'm wrong.
regards,
Lev
Does anybody know how to work with JDBC in WDJ 7.31?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.