Hello, we are trying to connect Collibra to a instance in our SQL Server with the jdbc string: jdbc:sqlserver://{SERVER}\{INSTANCE}:{PORT};databaseName={DATABASE};encrypt=true;trustServerCertificate=true, but it keeps returning this error:
Unexpected error running test connection
Test jdbc connection failed.
com.collibra.edge.connection.capability.ConnectionTestException: Test jdbc connection failed
at com.collibra.edge.connection.capability.jdbc.JdbcConnectionTestExecutor.executeTest(JdbcConnectionTestExecutor.java:40)
at com.collibra.edge.connection.capability.EdgeTestConnectionCapability.lambda$main$0(EdgeTestConnectionCapability.java:30)
at java.base/java.util.Optional.map(Optional.java:260)
at com.collibra.edge.connection.capability.EdgeTestConnectionCapability.main(EdgeTestConnectionCapability.java:30)
Caused by: java.lang.RuntimeException: java.lang.NullPointerException: Cannot invoke "java.sql.Connection.isReadOnly()" because "this.delegate" is null
at com.collibra.edge.sdk.Retryable.executeWithRetry(Retryable.java:49)
at com.collibra.edge.sdk.Retryable.executeWithRetry(Retryable.java:22)
at com.collibra.edge.sdk.ParameterHandler.connectToJdbc(ParameterHandler.java:201)
at com.collibra.edge.sdk.EdgeRuntime.connectToJdbc(EdgeRuntime.java:123)
at com.collibra.edge.sdk.EdgeRuntime.connectToJdbc(EdgeRuntime.java:117)
at com.collibra.edge.connection.capability.jdbc.JdbcConnectionTestExecutor.executeTest(JdbcConnectionTestExecutor.java:28)
... 3 more
Caused by: java.lang.NullPointerException: Cannot invoke "java.sql.Connection.isReadOnly()" because "this.delegate" is null
at edge.com.collibra.jdbc.connection.DelegatingConnection.isReadOnly(DelegatingConnection.java:96)
at com.collibra.jobserver.edge.DelegatingConnection.isReadOnly(DelegatingConnection.java:96)
at edge.com.collibra.jdbc.connection.readonly.ReadOnlyConnectionDecoratorFactory$ReadOnlyConnectionDecorator.<init>(ReadOnlyConnectionDecoratorFactory.java:44)
at edge.com.collibra.jdbc.connection.readonly.ReadOnlyConnectionDecoratorFactory.decorate(ReadOnlyConnectionDecoratorFactory.java:32)
at edge.com.collibra.jdbc.connection.DefaultJdbcClient.createConnection(DefaultJdbcClient.java:268)
at edge.com.collibra.jdbc.connection.DefaultJdbcClient.connect(DefaultJdbcClient.java:83)
at com.collibra.edge.sdk.ParameterHandler.lambda$connectToJdbc$2(ParameterHandler.java:201)
at com.collibra.edge.sdk.Retryable.lambda$executeWithRetry$0(Retryable.java:25)
at com.collibra.edge.sdk.Retryable.executeWithRetry(Retryable.java:39)
... 8 more
We already connected SQL server that dont have instances with the same user and it worked.
Can someone help me on this please?
