Skip to Content
0
Dec 04, 2022 at 06:49 PM

SAP Crystal Report failed to open JDBC connection to Hazelcast

94 Views Last edit Dec 05, 2022 at 08:31 AM 2 rev

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

cr-s1.png

Connection

(2) Using SAP Crystal Report 2020

cr-s2.png

(3) Create JDBC Connection to Hazelcast

cr-s3.png

(4) Try connect to Hazelcast

cr-s3-1.png

(5) CR failed to open JDBC connection to Hazelcast

cr-s4.png

Scenario 2: Using DBeaver

(1) Specify JDBC Connection to Hazelcast

dbeaver-s1.png

(2) Can open JDBC Connect to Hazelcast from DBeaver

dbeaver-s2.png

dbeaver-s3.png

Attachments

cr-s1.png (100.8 kB)
cr-s2.png (192.8 kB)
cr-s3.png (122.6 kB)
cr-s3-1.png (144.5 kB)
cr-s4.png (156.0 kB)
dbeaver-s1.png (41.5 kB)
dbeaver-s2.png (50.0 kB)
dbeaver-s3.png (55.7 kB)