-
Notifications
You must be signed in to change notification settings - Fork 17
Establishing secured connection in CF #8
Comments
it seems #7 attempts to solve this issue but it is not done in a configurable (optional) way |
A workaround is to configure the DataSource to be used manually: @Bean
@Primary
public DataSource dataSource(
@Value("${vcap.services.<your-haas.service>.credentials.url}")final String url,
@Value("${vcap.services.<your-haas.service>.credentials.user}")final String user,
@Value("${vcap.services.<your-haas.service>.credentials.password}")final String password
) {
return DataSourceBuilder.create()
.type(HikariDataSource.class)
.driverClassName(com.sap.db.jdbc.Driver.class.getName())
.url(url)
.username(user)
.password(password)
.build();
} |
@Flawi thank you. your solution works for me. Have to use HikariDataSource.class. ( DataSource.class is not working). This solution will be the workaround. Alternatively, if you would want to use Embedded tomcat container to connect to Cloud. You may follow this link https://stackoverflow.com/questions/24941829/how-to-create-jndi-context-in-spring-boot-with-embedded-tomcat-container Any chance that @jonathanbaker7 can fix the not detected HANAServiceInfoCreator during runtime? |
Getting exception mentioned in this thread SAP DBTech JDBC: [4321]: only secure connections are allowed, when trying to connect a Springboot App deployed on SAP cloud CF. Any fix for this ? |
To enable Java encryption, "encrypt=true" needs to appear in JDBC URI. Are you doing this? |
Workaround including the security parameters would be:
|
When trying to establish a Hana DB connection in our CF landscape using spring-cloud-cloudfoundry-hana-service-connector we are getting an exception from the Hana driver:
2018-09-14T13:11:07.52-0700 [APP/PROC/WEB/0] ERR com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [4321]: only secure connections are allowed 2018-09-14T13:11:07.52-0700 [APP/PROC/WEB/0] ERR at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345) 2018-09-14T13:11:07.52-0700 [APP/PROC/WEB/0] ERR at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185) 2018-09-14T13:11:07.52-0700 [APP/PROC/WEB/0] ERR at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:102) 2018-09-14T13:11:07.52-0700 [APP/PROC/WEB/0] ERR at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1033)
From looking into HANAServiceInfoCreator -> createServiceInfo() it seems that the URL created for the connectivity doesn't contain options for:
As a result the connectivity to our Hana instance is failing (see stack trace).
It seems we need some configuration options for HANAServiceInfoCreator to allow for better URL composition.
The text was updated successfully, but these errors were encountered: