Requirements for JDBC based services #63
Description
I have create a decent prototype for integrating databases in pvmanager/csstudio using pvmanager services. This would allow to integrate with site dependent infrastructure data available through Oracle/MySQL/etc.Ideally, one would have an actual service to serve the data, but in practice the database may be a one off or outside of the control of the group deploying CSS.
The code is in org.csstudio.utility.pvmanager.jdbc for the core, and org.csstudio.service.jdbcsample for an example on how to use it. The service can then be used in BOY with the Service Panel and other widgets.
There are plenty of open question, then can only be understood through usage, so I am looking for potential early users.
Open questions at this point:
- Should the service description be simply and XML? That is, instead of making people write code, would it be better to simply require them to write an xml file with connection parameters, queries, and query parameters?
- How should the authentication be handled? If the username/password of the database are in the configuration, it means they need to be written somewhere. But for some databases, especially for read only whose access is handled by a totally different group, giving a username/password combination for each user may be even worse (it would be written on a post-it in the control room anyway)