SAP Crystal Report failed to open JDBC connection to Hazelcast

[engkian]

Hi Crystal Report Support Team.

Is there a way for us to connect to Hazelcast in Crystal Report?

We need to connect to Hazelcast and execute SQL in Hazelcast in Crystal Report so that we can display data on Crystal Report.

We tried

(Scenario 1) Using SAP Crystal Report 2020 on Windows: CR throws error "Failed to open a connection" when connect to Hazelcast in Crystal Report using latest v5.2 Hazecast JDBC Driver, using the same Hazelcast JDBC Driver Connector.

(Scenario 2) Using DBeaver tool: DBeaver successfully opens connection to Hazelcast and we can retrieve data from Hazelcast Maps in DBeaver.

Attached are the screenshots I captured from CR and DBeaver. I have collected CR trace files for investigations.

Currently we are following the below guide link to

* to connect to database using JDBC

https://userapps.support.sap.com/sap/support/knowledge/en/1527666

* to retrieve the Crystal Report Trace Log

https://userapps.support.sap.com/sap/support/knowledge/en/1603398

https://kenhamady.com/cru/archives/2075

https://www.computerhope.com/issues/ch000549.htm#windows10

Appreciate you could shed some lights and guidance.

With best regards,

Eng Kian

Attachment:

JDBC Trace logs

Screenshots

(1) Hazelcast JDBC in the Classpath of CRConfig.xml

Connection

(2) Using SAP Crystal Report 2020

(3) Create JDBC Connection to Hazelcast

(4) Try connect to Hazelcast

(5) CR failed to open JDBC connection to Hazelcast

Scenario 2: Using DBeaver

(1) Specify JDBC Connection to Hazelcast

(2) Can open JDBC Connect to Hazelcast from DBeaver

[engkian]

2022-12-07 10:52:47,863 [ORBacus:ThreadPerRequest:Dispatcher] com.crystaldecisions.data.jdbc.CRDB_JDBCImpl.DbLogonServer(CRDB_JDBCImpl.java:918) INFO -languageCode: 652022-12-07 10:52022-12-07 10:52:47,862 [ORBacus:ThreadPerRequest:Dispatcher] com.crystaldecisions.data.jdbc.CRDB_JDBCImpl.DbLogonServer(CRDB_JDBCImpl.java:915) INFO -connection string: jdbc:hazelcast://localhost:5701?clusterName=dev, user id: root, password: ******, binary data: 202:47,895 [ORBacus:ThreadPerRequest:Dispatcher] com.crystaldecisions.data.javaserver.CRDB_JavaServerImpl.DbLogonServer(CRDB_JavaServerImpl.java:675) FATAL -Exception: [Error Message:] Not supported: http://javax.xml.XMLConstants/property/accessExternalDTD

[engkian]

From the CR trace log fie, i notice this error message

"Not supported: http://javax.xml.XMLConstants/property/accessExternalDTD"

Is Hazelcast not supported by Crystal Report even thought other tool such as DBeaver can connect to it?

Is there a way for us to connect to Hazelcast in Crystal Report?

We need to connect to Hazelcast and execute SQL in Hazelcast in Crystal Report so that we can display data on Crystal Report.

Appreciate your advise.

With Best Regards,

Eng Kian

[DellSC]

When you seen an error in Crystal that includes "Database Error Code", that code is being passed directly back from the database. Do you know what Hazelcast error 7209071 means? That will tell you what the problem is that is preventing the connection. A quick Google didn't show me anything and I'm not familiar with Hazelcast.

-Dell