Reputation: 1433
How can I manage resources on ignite.
Given the application i am developing, i have a few connections that i used to keep, (JDBC/SAP/others). I used to keep all the connections in a pool and manage them using HIKARI. Now given that now I can have a cluster of machines using ignite, what method can I use, so that I can distribute the connections across the nodes.
Ignite doesn't provide this mechanism out of the box.
I have thought of using services as a container for these connections, but then the management of connection is an extra overhead. As good as reinventing the wheel.
Hikari doesn't have any cluster management features and hence is limited to single node resource.
Any suggestions will be appreciated.
Upvotes: 6
Views: 769
Reputation: 2980
SAP Data Services, as of 4.2 SP2, now supports the use of JDBC drivers as a data source. This capability has been implemented through a new adapter type, JDBC.
To add a JDBC adapter you use the Data Services Administration Console, browse to adapter instances, choose your job server and then select Adapter Configuration.
SAP HANA provides a driver that enables Java applications to connect to the SAP HANA database with the JDBC application programming interface (API).
Upvotes: 0
Reputation: 1006
Did you have a chance to take a look at JDBC client node driver? It should handle distributing the queries between nodes.
Upvotes: 2