on 08-25-2014 9:28 AM
I am using trial account .at sap cloud server.
What will be my URL of SAP HANA database for Trail account.
For ex:
java.sql.Connection conn= java.sql.DriverManager.getConnection("jdbc:sap://<YOUR SAP HANA IP>:host","<YOUR SAP HANA USER>","<YOUR PASSWORD>");
I had User and password but what supposed to be used in place of IP and Host ?
You don't use DriverManager, instead you should use a DataSource. See Using Plain JDBC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks .But iwant to use like this ..and below properties are not working
repliesd as connectin refused -813
please help onthis
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.sap.db.jdbc.Driver"/>
<property name="url" value="jdbc:sap://localhost:30015/?currrentschema=TestSchema" />
<property name="username" value="p1940828544"/>
<property name="password" value="Vivek@cgt.co.in"/>
</bean>
If you really need the connection details for this kind of configuration, you could open a DB tunnel and use the returned values. However, keep in mind that for trial instances the tunnel is closed and the password invalidated after 24 hours.
Thanks for reply ,I.
I was following below step: and not working .
1.Get the details from Open db tunnel
2. close the tunnel.
3. set the parameter in config file
4. run the application
5. connection refused at localhost:30015 -813
Should i close the database instance in SAP administrator console from eclipse IDE.
User | Count |
---|---|
84 | |
24 | |
12 | |
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.