on 12-04-2022 6:49 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
From the CR trace log fie, i notice this error message
"Not supported: http://javax.xml.XMLConstants/property/accessExternalDTD"
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.