I have a lot of adapter services using the same JDBC Adapter Connection definition. I would like to move this connection to a different Package. How can I achieve that without rewriting every adapter service? There seems to be no refactoring capabilities provided.
thanks for your reply. Suvigya - how did you solve this issue? If it is not possible to move a connection, changing the adapter service to use another connection would also be a way. Can I change an adapter service to use a different connection.
Oh my… this is hard to accept. So I need to delete all my adapter services and recreate them using the new connection.
There must be another way. Where does the server store the information which connection to use for a service. Maybe I can change it on file level with out tooling support?!
You can use the service
pub.art.service:setAdapterServiceNodeConnection in the WmART package to change the connection used by a service .
So I will proceed this way:
create the new JDBC connection using Admin console of the JDBC Adapter
Call pub.art.service:setAdapterServiceNodeConnection for each of my adapter services.
2a. to automate this you could also write a service that uses pub.art.service:listAdapterServices called with adapterTypeName=JDBCAdapter to list all adapter service and then use a loop to update the connection using pub.art.service:setAdapterServiceNodeConnection
check if any adapter services remain using the old connection before deleting it.
This is mind blowing buddy…
Actually I have never used WmART package, so didn’t knew about it, but you have done great job…
You can do one thing, make a new thread, with title changing of adapter service from one package to another. It will be helpful to others.
Really thanks, even I will have less headache now…